MySQL Index
Index, transaction, lock, InnoDB engine
Tablespace\segment\extended\page\row
GAOPENGTTTT, MySQL InnoDB How to calculate the maximum capacity and number of rows for a B + Tree table, http://blog.itpub.net/7728585/viewspace-2139931/
Tokudb
"Administrator" Ta-gakki<[email protected]> 21:13:37
IBD File
"Administrator" Ta-gakki<[email protected]> 21:13:42
50G single table do not exceed 50G
heap engine, after reboot, all data is lost
http://imysql.com/2016/01/06/mysql-faq-different-between-btree-and-hash-index.shtml, the difference between the B + Tree index and the hash index
CPU%user Very high
"Administrator" ta-gakki<[email protected]> 21:46:19
10 is 8, 9 is incorrect index usage
"Administrator" ta-gakki<[email protected]> 21:46:26
If the CPU%sys is very high
"Administrator" ta-gakki<[email protected]> 22:10:59
the InnoDB engine is Oracle's IoT table
the MyISAM engine is the hot watch for Oracle.
"Administrator" Ta-gakki<[email protected]> 22:31:20
Https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
"Administrator" Ta-gakki<[email protected]> 22:31:26
[MySQL FAQ] Series-why InnoDB table to suggest the use of self-increment the master key, http://imysql.com/2014/09/14/mysql-faq-why-innodb-table-using-autoinc-int-as-pk.shtml
"Administrator" Ta-gakki<[email protected]> 22:31:31
[MySQL Optimization case] Series--InnoDB primary key design, http://imysql.com/2010/08/03/sth_about_innodb_primary_key_design.html
mysql-Optimization Class Learning -8-20170606-mysql Index
