…_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | to control gathering of… and userstat_running = OFF we have no performance penalties of using of patches. Also we fixed potential memory leaks in microslow and userstats patches…
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…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…PATCHES command, which is based on Jeremy Cole’s patch mysql> show patches; …| | | userstats.patch | SHOW USER/TABLE/INDEX statistics | 1.0 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… ways to do the same. This is huge hole in MySQL design, thinking little about users isolations and resource quotas and… implementing are typically focused on the load eliminating – using Google UserStats patches (included in Percona releases) or Log analyzes as well as…(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
… installed: ii libmysqlclient15off 5.0.90-percona-b21.hardy.3 MySQL database client library ii libpercona-xtradb-client-dev 5.1… database server binaries Is the userstat patch included? mysql> set global userstat_running = ‘ON’; ERROR 1193 (HY000): Unknown system variable ‘userstat_running’ I am hoping…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… in Percona Server (and others) using the User Statistics patch. By enabling ‘userstat_running’, we start to get information in the INFORMATION… droppable_indexes view to use that information: mysql> drop view if exists droppable_indexes; mysql> create view droppable_indexes as select all…
Post: Announcing Percona Server 5.5.25a-27.1
July 21, 2012 By Leave a Comment
… the profiling information. Bugs Fixed: Percona Server would crash if userstats were enabled with any replication configured. This was a regression…). Removed some patch-based source code management leftovers from the bzr branch migration. Bug fixed #988383 (Stewart Smith). Fixed upstream mysql bug…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… of the ways to measure it: 1) Use “UserStats” functionality from Google patches, which is now available in Percona Server and MariaDB… 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…_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…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
….1.49-12.0 RC contains a couple of patches from the Facebook-MySQL tree – https://launchpad.net/mysqlatfacebook . Of particular note…. New features added: error_pad – Implements error code compatibilities with MySQL 5.5. (Oleg Tsarev) query_cache_totally_disable – Allows the… be purged. Bug #607449 – Fixes a crash during shutdown when userstat_running=1. Bug #612954 – Fixes a problem with SHOW PROCESSLIST…
