…query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | to control gathering …leaks in microslow and userstats patches, the leak appeared under some workloads. The -percona release includes: | innodb_check_defrag.patch | Session status to check…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… plan, InnoDB timing, profiling info – Userstat patch Different patches to help with day to day usage of MySQL ® Two new features which not… stage the patches are available only in source code, you can get them from Launchpad https://code.launchpad.net/~percona-dev/percona-patches/5…
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 | … MySQL 5.1 RC, at least stable to name whole MySQL-5.1-percona release as RC. Along with previously mentioned patches, …
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… are typically focused on the load eliminating – using Google UserStats patches (included in Percona releases) or Log analyzes as well as PROCESSLIST monitoring…(1); SET @a13:=repeat(“a”,1000000); select sleep(1); … Causes MySQL to “leak” 1MB of memory per second with no apparent…
Comment: Introducing percona-patches for 5.1
May 18, 2010 By 21 Comments
… the following installed: ii libmysqlclient15off 5.0.90-percona-b21.hardy.3 MySQL database client library ii libpercona-xtradb-client-dev 5….hardy.24 Percona SQL database server binaries Is the userstat patch included? mysql> set global userstat_running = ‘ON’; ERROR 1193 (HY000): Unknown system variable ‘userstat_running…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…12.0 RC contains a couple of patches from the Facebook-MySQL tree – https://launchpad.net/mysqlatfacebook . Of…release include: New features Percona Server 5.1.49-rel12.0 is based on MySQL 5.1.49…. Bug #607449 – Fixes a crash during shutdown when userstat_running=1. Bug #612954 – Fixes a problem with…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… ways to measure it: 1) Use “UserStats” functionality from Google patches, which is now available in Percona Server and MariaDB. This is the… in Oracle MySQL Server. set userstat_running=1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G…
Comment: 5.0.77 / 5.0.82 -build16 Percona binaries
June 19, 2009 By 4 Comments
Building MySQL-percona-b16-5.0.82-0.rhel5.src.rpm fails because userstatv2.patch can’t be applied cleanly: patching file sql/mysqld…_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…
