PHP

Detailed parsing of MySQLgrant syntax (account permission management) bitsCN.com Detailed parsing of MySQL grant syntax (account permission management) Record some usage of mysql grant. The simple format of commands for granting user permissions

Xtrabackup Official Document Study Notes [full backup] bitsCN.com Study Notes for xtrabackup official documents [full backup part] Introduction Xtrabackup is a C program that links to the InnoDB API and mysql client API. The InnoDB API provides

Reclaim InnoDB tablespace bitsCN.com Reclaim InnoDB tablespace This section assumes that innodb_file_per_table is enabled. Use conventional optimize for recycling: [Plain] mysql> select count(*) from t; +----------+ | count(*) | +----------+ |

MySQL efficient paging solution set bitsCN.com MySQL efficient paging solution set 1. the most common paging method for MYSQL: Select * from content order by id desc limit 0, 10 In the case of small data volumes, such SQL statements are enough.

Mysql storage program and timer bitsCN.com Mysql storage program and timer Storage process timer eventprocedure practice Requirement: a huge log table is used to calculate the total number of days on a regular basis every day and put it in

10 million data entries imported into mysql bitsCN.com 10 million data entries imported into mysql Today, we need to insert a text containing 10 million pieces of data into a database table. at first, we naturally thought of using Insertinto

Use RMAN to downgrade ORACLE10G64 bit to 32-bit ORACLE RMAN BitsCN.com Use RMAN to downgrade ORACLE 10G 64-bit to 32-bit Because the project needs to test the environment, the original database is ORACLE 10.2.0.4 64-bit, and the environment needs

MySQL Query statement execution and performance optimization-query process and optimization method (JOINORDERBY) bitsCN.com MySQL Query statement execution process and performance optimization-query process and optimization method (JOIN/order)

[MariaDB] install MariaDB and coexist with MySQL MariaDB BitsCN.com [MariaDB] install MariaDB and coexist with MySQL MariaDB can be used to replace enhanced MySQL versions, but MariaDB can also be installed when MySQL is installed. (This makes

MySQL real-time online backup recovery solution: Replication + LVMSnapshot bitsCN.com MySQL real-time online backup recovery solution: Replication + LVM Snapshot The combination of snapshot and replication technology ensures a real-time online

High-Performance MySql evolution: speeding up AlterTable bitsCN.com High-Performance MySql evolution: accelerating Alter Table During routine maintenance of the system, you often need to update the table structure, such as adding/deleting a field

MySql configuration master-slave replication read/write splitting bitsCN.com Configure master-slave replication read/write splitting for MySql In the my. ini configuration file Master-slave replication must be performed through binary log files.

MYSQL tablespace migration bitsCN.com MYSQL tablespace migration You may need to copy the InnoDB table to different database servers for the following reasons. Generate a report without increasing the production load Create a table with the same

[MySQL] permission check for stored procedures, functions, triggers, and views [MySQL] permission check for stored procedures, functions, triggers, and views After a stored procedure, function, trigger, or view is created, other users may need to

MySQL default validation rules are case insensitive bitsCN.com MySQL default validation rules are case insensitive Background:The system determines whether to insert or update a name by determining whether it exists. because it is a key

[MySQL production environment data recovery] innobackupex: fatalerror: ORno bitsCN.com [MySQL production environment data recovery] innobackupex: fatal error: OR no 'datadir 'option in group 'mysqld 'in MySQL options 1. execute the recovery

Conversion of mysql Query timestamp and date bitsCN.com Mysql Query timestamp and date conversion In the use of the database, you often need to query records by specified date for statistics. in the database, many of them store timestamps, Some

Default value of all variables of mysql5.34x64 Community Edition in win environment: bitsCN.com Default values of all variables in mysql5.34x64 Community Edition in win environment My. ini file content: [mysqld]port =

After mysql is upgraded, Tableamp; #39; mysql. serversamp; #39; doesnamp; #39; texist bitsCN.com is reported to solve Table 'MySQL. servers' 'doesn' t exist. One thing I encountered today is that after upgrading the mysql database, I entered the

Relationship between paip. mysql Performance, iops, and hard disk cache bitsCN.com Relationship between paip. mysql Performance, iops, and hard disk cache Two hard disks. A.500g cache 16 M B .160g cache 8 M, The file read and write operations