…-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute…the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS)…/O error occurs after an INNODB_CHANGED_PAGES query started returning…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 2 Comments
…alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3…calling calloc() directly instead of using InnoDB heap allocation. This may improve … the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…Innodb is a single row (well, the PRIMARY KEY index entry for that row). This means typically on a single Innodb… and you keep track of global achievement statistics in a single table with a row… we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb…which implied an implicit secondary index with the same name. Fixed…(Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
… case the same question arises: How many MySQL records were recovered and how many were lost…ways to know how many records an InnoDB page stores. The index page has a header PAGE_N_…knows how many records were actually recovered. This statistics are printed along with the recovered records: — Page…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb…which implied an implicit secondary index with the same name. Fixed…(Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
… indexes: mysql> SELECT INNODB_INDEX_STATS.TABLE_NAME, INNODB_INDEX_STATS.INDEX_NAME from INNODB_INDEX_STATS WHERE CONCAT(INNODB_INDEX_STATS.index_name, INNODB_INDEX_STATS.table_name)NOT IN(SELECT CONCAT(index_statistics.index_name, index_statistics.table_name) FROM index_statistics) AND INNODB_INDEX…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… our schema with one command: mysql> create table index_analysis.used_indexes select * from information_schema.index_statistics; If the stats come from …_schema.statistics i using (table_schema, table_name) join information_schema.innodb_index_stats s using (table_schema, table_name, index_name) …
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
… InnoDB table statistics is used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query. If a table’s statistics or index…
Post: Find and remove duplicate indexes
June 20, 2012 By 9 Comments
… maintain, calculate and update more index statistics DML and even read queries can be slower because MySQL needs update fetch more data to… long and short index might be good for the query execution. Redundant suffixes on clustered index InnoDB uses a clustered index and that means…
