… | user | statistics | select … | 6344 | user | | NULL | 6345 | user | Updating | update … | 6346 | user | Sorting result | insert … | 6351 | user | | NULL | 6355 | user | | NULL | 6356 | user | statistics | select … | 6357 | user | statistics | select … | 6358 | user | Sending… … | 6359 | user | statistics | select … | 6360 | user | | NULL | 6361 | user | | NULL +——+——————+—————-+————- Notice all those processes in ‘statistics‘ status. Why is that happening? Look at SHOW INNODB STATUS…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… potential logging and statistics overhead, so now you can fully turn on / off query statistics for microslow patch and user statistics in runtime. Next… are Innodb_scan_* | | userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1.0 | Jeremy Cole…
Post: New patches, new builds
September 5, 2008 By 24 Comments
… Kinoshita | BSD | | | userstats.patch | SHOW USER/TABLE/INDEX statistics | 1.0 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1.0 | Jeremy Cole | N/A | | +————————————————–+——————————————————–+———+—————————-+———+—————————————+ Next, we added tables USER_STATISTICS…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
… commands like SHOW INDEX, SHOW TABLE STATUS and SHOW [FULL] TABLES (or their corresponding queries from INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.STATISTICS) When… of SHOW TABLE STATUS FROM schema taking away a couple of seconds on execution time. # Time: 110923 1:48:17 # User@Host…
Post: Percona build7 with latest patches
November 14, 2008 By 26 Comments
… are Innodb_scan_* | | userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1.0 | Jeremy Cole… locked records in SHOW INNODB STATUS | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch | Extended statistics in slow.log…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER… show processlist; +——–+————-+———–+——+———+——+———————————————————————–+——————+ | Id | User | …
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
… resolution in slow logs) execution plan (show info about query execution in slow log) InnoDB statistic (show extended InnoDB usage during query execution in slow log) Google’s patches with user statistics, and statistics about tables and…
Comment: Percona RPMS for RedHat 5 / CentOS 5 x86_64
July 31, 2008 By 4 Comments
… to export the output from the monitoring rather than SHOW {TABLE,USER,INDEX}_STATISTICS. That sounds great. We are still in a MySQL… the slow query log. And we are trying to add SHOW CLIENT_STATISTICS that will aggregate resource consumption by client IP. That…
Post: How to generate per-database traffic statistics using mk-query-digest
September 16, 2009 By Leave a Comment
… instance with multiple (identical) databases: SHOW DATABASES; +———-+ | Database | +———-+ | db1 | | db2 | | db3 | | db4 | | mysql…doesn’t allow us to examine statistics on a per-database basis. … aggregate information by tables, hosts, users, or databases (full documentation is available …
Comment: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
Kevin, What is showed here is not the Googles V2 complete patch set but the given accounting patch ported to Percona patch set. The user statistics patches in particular are very safe because they do not change any internal logic this is why we put them in the “safe to use” release.
