…. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter…
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 3 Comments
…. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
… to know how many records an InnoDB page stores. The index page has a header PAGE_N_RECS – this is a… in the page: ./constraints_parser -5f pages-actor/FIL_PAGE_INDEX/0-1599/00000000-00000003.page -V … Checking a page Infimum… end it knows how many records were actually recovered. This statistics are printed along with the recovered records: — Page id: 3…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… in Innodb is a single row (well, the PRIMARY KEY index entry for that row). This means typically on a single… an online game and you keep track of global achievement statistics in a single table with a row for each stat…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… explicitly named foreign key constraint which implied an implicit secondary index with the same name. Fixed by detecting such cases and… used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to make sure no additional work…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… explicitly named foreign key constraint which implied an implicit secondary index with the same name. Fixed by detecting such cases and… used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to make sure no additional work…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
…_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_STATS.TABLE_SCHEMA=’tpcc’ AND INNODB_INDEX_STATS.INDEX_NAME’GEN_CLUST_INDEX‘; +————+——————-+ | TABLE_NAME | INDEX_NAME…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… be quite inaccurate as secondary indexes tend to take more space. So we added more detailed index statistics into our xtrabackup utility. The…, index: PRIMARY, space id: 12, root page 3 estimated statistics in dictionary: key vals: 25265338, leaf pages 497839, size pages 498304 real statistics…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… indexes in all_indexes, but not in used_indexes. These indexes (if our original index statistics are good) are candidates to be dropped: create view droppable_indexes as select all_indexes.table…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
… USER_ and CLIENT_STATISTICS commands Our port includes: INFORMATION_SCHEMA tables – USER_STATISTICS, CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS Access protection – USER_STATISTICS, CLIENT_STATISTICS available only for user with SUPER or PROCESS privileges. INDEX_STATISTICS, TABLE_STATISTICS shows only…
