View Mysql index page fragmentation _ MySQL

View Mysql index page fragments bitsCN.com
Query index page fragments: show table status like 'table name'; // when the value of the Data_free column is greater than 0, fragments are generated (as long as data is deleted, the premise is to create an index) OPTIMIZE the TABLE: optimize table name; create an index condition (or): The TABLE has a large amount of data (if the data size is small, the index creation effect is not obvious, but it wastes physical space, increase the difficulty of table maintenance) primary key column/foreign key column (accelerate join)/Common search column View database encoding: show variables like 'character _ set % '; set the return result encoding: SET character_set_results = UTF-8; author: 897457425bitscn.com