… 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: 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: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… | user | | NULL | 6328 | user | statistics | select … | 6334 | user | statistics | select … | 6337 | user | | NULL | 6340 | user | Sending data | select … | 6342 | 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…
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… 5.1 and | userstat_running | OFF | to control gathering of user statistics. With both slow_query_log = OFF and userstat_running = OFF… are Innodb_scan_* | | userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1…
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… Next, we added tables USER_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS to INFORMATION_SCHEMA mysql> select * from information_schema.table_statistics; +————————-+———–+————–+———————-+ | TABLE_NAME | ROWS_READ…
Post: Userstats patches with information schema support
August 4, 2008 By 16 Comments
… information schema tables added: user_statistics, table_statistics, index_statistics. One can now use select * from information_schema.user_statistics along with show user_statistics. Links: Patch for…
Comment: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… statistics). I may be biased, but I could not do without this feature. It makes it very easy to determine which users… over time. Once a load problem is isolated to one user, statement sampling can be used to determine the statements that… a column for IO per user to SHOW USER_STATISTICS. I think that the patch left out FLUSH TABLE_STATISTICS, but that will be…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 5 Comments
… their corresponding queries from INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.STATISTICS) When 1 / 16th of the table or 2Billion rows has been modified, whichever comes first. ./row/row0mysql.c:row_update_statistics_if_needed If you or an application constantly executes SHOW… of seconds on execution time. # Time: 110923 1:48:17 # User@Host: user1[user1] @ [172.20.6.1] # Thread_id: 10140441…
Comment: Percona Server and Percona XtraBackup
August 3, 2008 By 25 Comments
using userstats patch, is it somehow possible to flush user_statistics? there is FLUSH TABLE_STATISTICS; FLUSH INDEX_STATISTICS but not something like FLUSH USER_STATISTICS
