MySQL Installation Uninstalling MySQL Before installing MySQL, it's important to properly uninstall any previous versions: Stop the MySQL service through the Task Manager Uninstall MySQL via Control Panel or using the installer's uninstall option Clean up residual files in installation and data dire...
MySQL User and Privilege Management This article summarizes the content from Professor Song Hongkang's course. 1. User Administration In MySQL, users can be categorized into regular users and root users. The root user has full privileges including creating, deleting, and modifying user passwords, wh...
Fetching and Storing Web Data This example deomnstrates a data pipeline for processing daily epidemic information. The core process involves retrieving JSON data from a web API, parsing the relevant details, and storing them in a MySQL database using batch operations. When handling a dataset conatin...
Currrent Environment Overview Our monitoring infrastructure consists of a central Zabbix server with multiple distributed proxies. The specific configuration details are as follows: Zabbix Server: Source installation, version 5.0.12, MySQL 5.7 (source installation) Zabbix Proxies: Installed via Yum...
Creating Triggers to Monitor Table Opreations This tutorial demonstrates how to implement triggers in MySQL to automatically log operations performed on a table. We'll create triggers that fire on INSERT, UPDATE, and DELETE operations, capturing each action in a separate tracking table. Dataabse Sch...
1. Initial Auto Increment Value By default, the starting value is 1. When creating a table, you can specify a custom initial value using AUTO_INCREMENT=n. For example: CREATE TABLE test( id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, username VARCHAR(15) NOT NULL ) AUTO_INCREMENT=100; 2. Reset...
MySQL Partitioning TechnologyPartitioning is a database optimization technique that divides large tables, indexes, or their subsets into smaller, manageable physical segments called partitions. Each partition can be stored, backed up, and indexed independently. This approach enhances query performan...
Standard SQL Syntax Rules MySQL statements can span single or multiple lines, with each statement terminated by a semicolon. The database engine treats SQL keywords case-insensitively, though convention dictates uppercase keywords for readability. Code examples through out this guide follow lowercas...
Go's type assertion mechanism provides a powerful way to work with interface values and extract concrete types. This article explores practical applications through a search and data retrieval example combining Elasticsearch and MySQL. package main import ( "context" "database/sql&quo...
Data Structure A B+ tree is a multi-way balanced search tree. All leaf nodes reside at the same depth. Leaf nodes are interconnected via a doubly linked list to optimize range scans. Purpose Indexes expedite query execution by reducing the number of rows scanned. Index Creation Values from the index...