Recently Google published V2 release of patches, one of them user_statistics we use in our releases. New features are quite interesting so we decided to port it to fresh releases of MySQL… 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…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table …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: New patches, new builds
September 5, 2008 By 24 Comments
…USER_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS to INFORMATION_SCHEMA mysql> select * from information_schema.table_statistics…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… about potential logging and statistics overhead, so now you can fully turn on / off query statistics for microslow patch and user statistics in runtime. Next variables were added: | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… the InnoDB usage statistics. MySQL currently allows you to see many per-session statistics for operations with … not used: # Time: 071031 20:03:16 # User@Host: macko[macko] @ localhost [] # Thread_id: 12 # Query… or on any important system! The patch is available for MySQL Community 5.0.45 on Linux…
Post: Percona build7 with latest patches
November 14, 2008 By 26 Comments
…patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1.0 | Jeremy Cole | N/A | | | innodb_io_patches.patch…
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 that … password of the MySQL user -i, –port=
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
… lag. If you have Cacti (and these Cacti templates for MySQL) you can see this in the graphs. If the graphs… scientifically. Use our patched server, which gives you a USER_STATISTICS table. mysql> SELECT * FROM INFORMATION_SCHEMA.USER_STATISTICS WHERE USER=’#mysql_system#’\G *************************** 1. row *************************** USER: #mysql_system# TOTAL…
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: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… locks Diagnostic patches. – We provide much more statistics in slow.log, i.e. execution plan, InnoDB timing, profiling info – Userstat patch Different patches to help with day to day usage of MySQL ® Two new features which not… information to USER/CLIENT_STATISTICS but per THREAD granularity (it’s useful if you have connection pool) On this stage the patches are…
