Recently, we added information schema support to Google’s userstats patch. There are three information schema tables added: user_statistics, table_… information_schema.user_statistics along with show user_statistics. Links: Patch for 5.0.62 Patch for 5.1.26
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… individial query from this procedure, not just call storproc() With userstat you can get additional THREADS_STATISTICS which show similar information…
Post: New patches, new builds
September 5, 2008 By 24 Comments
… | BSD | | | control_io-threads.patch | InnoDB patch to control count of IO threads | 1.0 | Yasufumi 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…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… and userstat_running = OFF we have no performance penalties of using of patches. Also we fixed potential memory leaks in microslow and userstats patches, the leak appeared under some workloads. The -percona release includes: | innodb_check_defrag.patch | Session status to…
Comment: Introducing percona-patches for 5.1
May 18, 2010 By 21 Comments
… server binaries Is the userstat patch included? mysql> set global userstat_running = ‘ON’; ERROR 1193 (HY000): Unknown system variable ‘userstat_running’ I am hoping…
Comment: Percona Server and Percona XtraBackup
July 16, 2008 By 25 Comments
>5.1.26 >Patches >microslow-5.1.26.patch >innodb_stat-5.1.26.patch >5.1.26.patch where is userstats patch for this version?
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… implementing are typically focused on the load eliminating – using Google UserStats patches (included in Percona releases) or Log analyzes as well as…
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
Comment: Percona Server and Percona XtraBackup
July 30, 2008 By 25 Comments
What does userstats patch ? thx
Comment: 5.0.77 / 5.0.82 -build16 Percona binaries
June 19, 2009 By 4 Comments
….82-0.rhel5.src.rpm fails because userstatv2.patch can’t be applied cleanly: patching file sql/mysqld.cc Hunk #10 FAILED…_GETRUSAGE, OPT_SLOW_LOG, OPT_SLOW_QUERY_LOG_FILE, + OPT_USERSTAT_RUNNING, OPT_USE_GLOBAL_LONG_QUERY_TIME, OPT_INNODB_ROLLBACK…. Next patch which fails is: Patch #12 (innodb_io_pattern.patch): + /bin/cat /home/foo/rpmbuild/SOURCES/innodb_io_pattern.patch + /usr/bin/patch -s…
