…) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2 ] Now we can upgrade all servers to 6.4 [root@percona2.../.*CMAN_QUORUM_TIMEOUT=.*/CMAN_QUORUM_TIMEOUT=0/g" /etc/sysconfig/cman [root@percona2 ~]# sed -i.sed “s/.*CMAN_QUORUM_TIMEOUT=.*/CMAN_QUORUM_TIMEOUT=0…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout (introduced in MySQL… structure. Version check is on by default In 2.1.4, released September/October 2012, we introduced a feature called “version… a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 -u…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre…requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp…not innodb options (fixed) back_log = 50 wait_timeout = 120 max_connections = 5000 max_prepared_…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…(11) DEFAULT NULL, `Distance` int(11) DEFAULT NULL, `DistanceGroup` tinyint(4) DEFAULT NULL, `CarrierDelay` int(11) DEFAULT NULL, `WeatherDelay` int(11… innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error…=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… glad to announce the release of Percona XtraBackup 1.6.4 on 19 December, 2011 (Downloads are available here and from…. Bug Fixed: #892393 (Stewart Smith) innobackupex reaches the server wait_timeout. This bug meant that for backups that would take a…_timeout and be disconnected, leading to a failed backup. With this bug fixed, instead of setting a large wait_timeout for the MySQL…
Post: Announcing Percona XtraBackup 2.0.4
December 4, 2012 By 2 Comments
… glad to announce the release of Percona XtraBackup 2.0.4 on December 4th, 2012. Downloads are available from our download…. Bug fixed #887803 (Alexey Kopytov). In case safe-slave-backup-timeout was reached when using the safe-slave-backup option, SQL… SQL_THREAD state and starting it before terminating with a timeout error and starting the SQL_THREAD only if it was…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL… msandbox | localhost | test | Sleep | 37 | | NULL | +—-+———-+———–+——+———+——+———————————+—————————–+ 4 rows in set (0… to set lock_wait_timeout variable to a …
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… block and fail with a lock wait timeout. The problem is, it can be very …avail=$(df -m -P /root/tcpdumps/ | awk ‘/^\//{print $4}’); full=$(df -m -P /root/tcpdumps/ | awk ‘/^\//{print $… port ${port} > /root/tcpdumps/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… documented (sometimes) limitations. I’m saying about Prepared Statements in MySQL 4.1 which came without query cache support but even worse… MySQL 4.1 but you still could not run (and still can’t) most of your Oracle/DB2/MS SQL Queries on MySQL… for query timeouts, parallel query execution, CONNECT BY support and various performance related features. I’m not sure if MySQL got back…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
….13-20.4 on July 1st, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.13, Percona Server Percona Server 5.5.13-20.4 is now the current stable…. 350G) using the Expand Table Import feature due to a timeout. Bug Fix: #684829 (Y. Kinoshita). Partitioning adaptive hash index may…
