… per-user and per-table accounting to the database, accessible with a new set of commands such as SHOW TABLE_STATISTICS, SHOW INDEX_STATISTICS and SHOW USER_STATISTICS… catch users causing the most traffic to help you with some strategic decisions. Sample outputs: mysql> SHOW USER_STATISTICS LIKE ‘hosting2′\G *************************** 1. row *************************** User: hosting2…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
…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…
Comment: Percona builds with Percona patchsets
July 18, 2008 By 35 Comments
This is excellent news and great for users who want performance critical features but don’t want to patch and build MySQL. SHOW USER_STATISTICS is my favorite patch so far, does this include it?
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
…/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | to control gathering of user statistics…scan_* | | userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1.0 |…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 5 Comments
… statistics is used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query. If a table’s statistics… of SHOW TABLE STATUS FROM schema taking away a couple of seconds on execution time. # Time: 110923 1:48:17 # User@Host… the tables’ statistics. Luckily, this can be controlled with Percona Server with the variable innodb_stats_auto_update (from MySQL Community 5…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name |… in odd statuses, like “statistics“, I know something weird …
Comment: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… addition to the Percona Community Edition of MySQL (microslow patch, this, patch for IO statistics). I may be biased, but I could not do without this feature. It makes it very easy to determine which users… a column for IO per user to SHOW USER_STATISTICS. I think that the patch left out FLUSH TABLE_STATISTICS, but that will be in…
Post: Profiling MySQL stored routines
January 19, 2009 By 3 Comments
… tail /var/log/mysql/mysql-slow.log # Time: 090115 2:25:28 # User@Host: me[me] … Merge_passes: 0 # No InnoDB statistics available for this query SELECT….00 sec) mysql> show profiles; +———-+————+————————————————————-+ | Query_ID | Duration | Query …
Comment: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
If we can get the ‘SHOW USER_STATISTICS‘ functionality from the Google patch into MySQL, then you can compute replication load average using the Busy_time output for the system user and Uptime as reported by SHOW STATUS. Busy_time is the number of seconds that user had been running…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…user | statistics | select … | 6360 | user | | NULL | 6361 | user | | NULL +——+——————+—————-+————- Notice all those processes in ‘statistics‘ status. Why is that happening? Look at SHOW…
