…. 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 values…
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 values…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… its state before updating. This caused some problems for some users, especially if automatic upgrading was configured on machines with running… was 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
… was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to make sure no additional work…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… an online game and you keep track of global achievement statistics in a single table with a row for each stat…, but also updates groups with some metadata: BEGIN; INSERT INTO users_groups (user_id, group_id) VALUES (100, 1); UPDATE groups SET… to update the parent group row so often? INSERT INTO users_groups (user_id, group_id, joined) VALUES (100, 1, NOW()); Conclusion…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
… per user FLUSH 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…
Post: How expensive is USER_STATISTICS?
June 2, 2012 By 14 Comments
… me whether it’s safe to enable the so-called USER_STATISTICS features of Percona Server in a heavy-use production server… new INFORMATION_SCHEMA tables that add counters for activity on users, hosts, tables, indexes, and more. This is very helpful information… used less than 10MB of memory to store all the statistics. It might be time for us to consider making this…
Post: check-unused-keys: A tool to interact with INDEX_STATISTICS
June 26, 2009 By 10 Comments
With the growing adoption of Google’s User Statistics Patch**, the need for supporting scripts has become clear. To … to use -p, –password=
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… new set of commands such as SHOW TABLE_STATISTICS, SHOW INDEX_STATISTICS and SHOW USER_STATISTICS. The first two can interest anyone to periodically… users causing the most traffic to help you with some strategic decisions. Sample outputs: mysql> SHOW USER_STATISTICS LIKE ‘hosting2′\G *************************** 1. row *************************** User…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
… explore the two most common here. User Statistics from Percona Server and pt-index-usage. User Statistics User Statistics is an improvement on Percona Server that….INDEX_STATISTICS but first we should enable User Statistics: mysql> SET GLOBAL userstat=on; After all this hard work we have the statistics plugin…
