…TIMEOUT=.*/CMAN_QUORUM_TIMEOUT=0/g” /etc/sysconfig/cman [root@percona2 ~]# sed -i.sed “s/.*CMAN_QUORUM_TIMEOUT=.*/CMAN_QUORUM_TIMEOUT…
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
…. Bugs Fixed: Using Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client introduced a regression… in such a case. Bug fixed #1180662. Low values for wait_timeout on the server could cause server to close the connection… the bigger value for wait_timeout option on the server to prevent server from closing connections if the global wait_timeout value is set…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… tries and wait time between tries for all operations are configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout (introduced in MySQL 5.5…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off …fast_shutdown = 1 #not innodb options (fixed) back_log = 50 wait_timeout = 120 max_connections = 5000 max_prepared_stmt_count=500000 max…
Post: MySQL 5.5 lock_wait_timeout: patience is a virtue, and a locked server
February 28, 2013 By 5 Comments
…caption id=”attachment_13286″ align=”alignright” width=”200″] MySQL 5.5 lock_wait_timeout: patience is a virtue, and a locked server[/caption… something about lock_wait_timeout that shocked me. From the MySQL 5.5 docs for lock_wait_timeout: This variable specifies the timeout in seconds for…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just …_semi_sync_master_wait_no_slaveblogpercona.commanual Rpl_semi_sync_master_wait_pos_backtraverseblogpercona.commanual Rpl_semi_sync_master_wait_sessionsblogpercona.commanual Rpl…
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
July 8, 2007 By 1 Comment
…that. MySQL uses a lot of different timeout variables at different stages. For example when connection is just being established connect_timeout is used. When server waits for another query to be sent to it wait_timeout (or interactive_timeout for applications which…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… to a table that has a DDL operation waiting, will block. Why? Because MySQL sees that the old entries in the Table… unintended consequences. A workaround here would be to set lock_wait_timeout variable to a very low value and then execute the… (however due to a different reason): session2 > set session lock_wait_timeout=1;CREATE TABLE t1(i int(11) not null auto…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-rollback-segments=16 innodb-stats-auto-update=0 innodb…-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max-allowed…=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…, then other transactions could block and fail with a lock wait timeout. The problem is, it can be very difficult to find… port 3306 and port ${port} > /root/tcpdumps/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/tcpdumps/`date +%s… problems bringing everything on the system to a grinding “lock wait timeout” halt.
