…. There was discussion on a bug that makes the INDEX_STATISTICS and TABLE_STATISTICS tables under-report by 1 the number of rows… server code. Percona XtraBackup news: In general, demand for and usage of XtraBackup continues to grow extremely quickly, and innobackupex is…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
…get accurate information about table usage I will use Percona Patches: mysql> select * from information_schema.table_statistics where table_schema=’test’ and…t.table_name,”.key_buffer_size=”,round(least(index_length,(index_length/(select sum(index_length) from information_schema.tables where table_…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… (such as the improvements to the slow log output, and INDEX_STATISTICS). Despite having many requests to port these patches to 5… – Userstat patch Different patches to help with day to day usage of MySQL ® Two new features which not available for 5…() With userstat you can get additional THREADS_STATISTICS which show similar information to USER/CLIENT_STATISTICS but per THREAD granularity (it’s…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… statistics, information about transaction processing and all kinds of other things. In MySQL …index. You can also see number of hash index lookups and number of non-hash index lookups which is indication of hash index… shows Buffer pool activity and memory usage. You can see total memory allocated…
Comment: Duplicate indexes and redundant indexes
January 19, 2012 By 38 Comments
… which shows indexes in the database. (Query for below output is at the end) mysql> source…JOIN information_schema.key_column_usage b ON a.constraint_name =…index separator ‘, ‘), char) as column_list, null as referenced_table_name, null as referenced_column_name FROM information_schema.statistics…
