…Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing… definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the…
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
…attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona … 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…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…key constraint which implied an implicit secondary index with the same name. Fixed by …Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help… #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to make sure…
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 …: ./constraints_parser -5f pages-actor/FIL_PAGE_INDEX/0-1599/00000000-00000003.page -V … Checking … 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
…key constraint which implied an implicit secondary index with the same name. Fixed by …Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help… #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to make sure…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… a single row (well, the PRIMARY KEY index entry for that row). This means typically … standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? … and you keep track of global achievement statistics in a single table with a row …
Post: Find unused indexes
June 30, 2012 By Leave a Comment
… task of finding unused indexes we’re going to use INFORMATION_SCHEMA.INDEX_STATISTICS but first we should enable User Statistics: mysql> SET GLOBAL userstat… tpcc-mysql. After some runs we can start to analyze the information on INDEX_STATISTICS table. mysql> SELECT * FROM INDEX_STATISTICS; +————–+————+————–+———–+ | TABLE_SCHEMA | TABLE_NAME | INDEX_NAME…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… (just be careful not to break replication!). mysql> create schema index_analysis; If our index_statistics are collecting on the same server, then we… into our schema with one command: mysql> create table index_analysis.used_indexes select * from information_schema.index_statistics; If the stats come from some…
Post: Find and remove duplicate indexes
June 20, 2012 By 9 Comments
… slower because MySQL needs to examine more query plans. The storage engine needs to maintain, calculate and update more index statistics DML and even read queries can be slower because MySQL needs update fetch more data to…
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… statistics we run: xtrabackup –stats –tables=art.link* –datadir=/mnt/data/mysql/ which will show something like this: table: art/link_out104, index: PRIMARY, space id: 12, root page 3 estimated statistics in…
