…Userstat patch Different patches to help with day to day usage of MySQL ® Two new features which not available for 5…/5.1.43. Binaries are also on the way, and will be ready soon. We are running…for tpce-like benchmark, where I compare MySQL-5.1.43 vs percona-5.1.43. The results made for TPCE…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… Percona Server 5.1.49-rel12.0 is based on MySQL 5.1.49. New features added: error_pad – Implements error code compatibilities with MySQL 5.5. (Oleg… be purged. Bug #607449 – Fixes a crash during shutdown when userstat_running=1. Bug #612954 – Fixes a problem with SHOW PROCESSLIST displaying an…
Post: Percona Server 5.1.49-rel11.3
September 10, 2010 By 1 Comment
… version 5.1.49-rel11.3 is now available for download. The changes in this release include: New features Percona Server 5.1.49-rel11.3 is based on MySQL 5.1.49. A new variable was introduced: innodb… DimitriK blog Bug #607449 – Fixes a crash during shutdown when userstat_running=1 Bug #612954 – Fixes a problem with SHOW PROCESSLIST displaying an…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | to control gathering of user statistics. With both slow_query_log = OFF and userstat_running = OFF we…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
… 5.5.10-20.1 is now available for download. This is a release candidate for the Percona Server 5.5 series. In addition to MySQL 5.5…_log_use_global_control. (Oleg Tsarev) Old system variable userstat_running was renamed to userstat. (Oleg Tsarev) Old system variable innodb_expand_import…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
…running…userstat…MySQL variables in automated way a lot more convenient would be extending INFORMATION_SCHEMA.GLOBAL_VARIABLES Currently as of MySQL 5.5…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…in fresh our MySQL 5.1 GA or even something major on the roadmap for future MySQL versions. May …typically focused on the load eliminating – using Google UserStats patches (included in Percona releases) or Log …this number) Now remove sleep(1) and you will get mysqld quickly running out of memory and …
Post: New patches, new builds
September 5, 2008 By 24 Comments
… control count of IO threads | 1.0 | Yasufumi Kinoshita | BSD | | | userstats.patch | SHOW USER/TABLE/INDEX statistics | 1.0 | Google | GPL | Added INFORMATION…, install it and run mysql with option –skip-innodb. We think InnoDB plugin is stable enough to use it with MySQL 5.1 RC, at…
Comment: Introducing percona-patches for 5.1
May 18, 2010 By 21 Comments
…-server-5.1 5.1.45-xtradb-1.0.6-10-80.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‘ I am hoping you…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…MySQL Server. set userstat_running=1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1… replication capacity on 5 minute intervals (or…
