optimize table

As the number of machines monitored increases over time, the amount of data stored in the database will also increase. When the amount of data reaches a certain level, the response speed will be slow. Therefore, we need to clear some historical data.

I remember when I was in college, when I was learning computer, the teacher told me that the delete record only adds a delete ID to the record in the database, so that the database space is not reduced, then did not think so much, yesterday found a

Periodic analysis TableANALYZE [LOCAL | No_write_to_binlog] TABLE tbl_name [, Tbl_name]This statement is used to analyze and store the keyword distribution of a table. During parsing, the table is locked with a read lock. This is useful for MyISAM,

Remember when you learn computer in high school when the teacher told me delete delete record only to the database to add a delete identity, so that the database space is not reduced, then did not think so much, yesterday found a database using

MySQL regular analysis check and optimization TABLE regular analysis table analyze [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name [, tbl_name] This statement is used to ANALYZE and store the TABLE's keyword distribution. During the analysis, a read

The following articles mainly describe the detailed parsing of MySQL DELETE syntax. First, we start with the example of single table syntax and multi-Table syntax, if you are very interested in the MySQL DELETE syntax, you can read the following

With the long-term use of mysql, some problems may occur. In general, mysql tables cannot be accessed, and the tables can be repaired. During optimization, the disk space is reduced. Convenient backup. With the long-term use of mysql, some problems

The database size remains unchanged after the delete record of mysql is deleted, and mysqldelete This problem occurs when conditions are followed after the DELETE operation. Delete from table_name where Condition After the data is deleted, the

The following articles mainly describe the detailed parsing of MySQL DELETE syntax. First, we start with the example of single table syntax and multi-Table syntax, if you are very interested in the MySQL DELETE syntax, you can read the following

Do not use long when you can use short columns of data. If you have a fixed-length char data column, do not allow it to be longer than you really need. If you store the longest value in a data column with 40 characters, do not define char (255), but

The following article mainly describes the MySQL delete syntax of the detailed parsing, first of all, we are from the single table syntax and the example of multiple table syntax, if you are interested in the MySQL delete syntax related content, you

Http://heylinux.com/archives/2367.htmlhttp://blog.csdn.net/ywh147/article/details/8996022Students who have used MySQL have just started to touch the MyISAM table engine, the database of this engine will create three files: Table structure, table

Periodic analysis table ANALYZE [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name [, tbl_name] This statement is used to analyze and store the table's keyword distribution. During the analysis, a read lock is used to lock the table. This applies to MyISAM,

Use the MySQLDELETE syntax to parse bitsCN.com The following articles mainly describe the detailed parsing of MySQL DELETE syntax. First, we start with the example of single table syntax and multi-table syntax, if you are very interested in the

The following articles mainly describe the actual operation steps of mysql delete syntax and the actual application code of mysql delete syntax. The following describes the specific content, I hope it will help you learn this syntax. Single Table

The following articles mainly describe the detailed parsing of MySQL DELETE syntax. First, we start with the example of single table syntax and multi-Table syntax, if you are very interested in the MySQL DELETE syntax, you can read the following

This problem occurs when the delete is followed by the condition. Delete from table_name WHERE condition When you delete data, the amount of space that the datasheet occupies does not change. When you do not follow the conditions directly delete.

Delete syntaxSingle table Syntax: delete [low_priority] [quick] [ignore] from tbl_name [where where_definition] [order by ...] [Limit Row_count] multiple table syntax: delete [low_priority] [quick] [ignore] tbl_name[.*] [, tbl_name[.*] ...] From

Engine INNODB Storage OptimizeWhen MySQL tables grow to a stable period or grow 10 or 100Mb in a row, you can use the Optimize table statement to refactor MySQL tables, increase the availability of MySQL tables, and reduce the storage fragmentation

When emptying a larger table (more than 400 trillion in the Qing dynasty), it is found that the table is recorded as 0 but the space is not released, use the following way to see the occupancy situation--querying each database for disk