…connection: Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL…TIMEOUT=.*/CMAN_QUORUM_TIMEOUT=0/g” /etc/sysconfig/cman [root@percona2 ~]# sed -i.sed “s/.*CMAN_QUORUM_TIMEOUT=.*/CMAN_QUORUM_TIMEOUT… Starting cman… [ OK ] Waiting for quorum… [ …
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… the bigger value for wait_timeout option on the server to prevent server from closing connections if the global wait_timeout value is set too…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… –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… (https) connection over the web, else it will use a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off … (fixed) back_log = 50 wait_timeout = 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…amazing MySQL manual, especially the option and ….commanual concurrent_insertblogpercona.commanual connect_timeoutblogpercona.commanual Connectionsblogpercona.commanual …wait_no_slaveblogpercona.commanual Rpl_semi_sync_master_wait_pos_backtraverseblogpercona.commanual Rpl_semi_sync_master_wait…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…transactions could block and fail with a lock wait timeout. The problem is, it can be very…port ${port} > /root/tcpdumps/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/… your server to find idle-in-transaction connections that are just sitting there doing nothing,…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… very busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If you have connects timed…. Usually main thread is able to accept connections pretty quickly, however if it stalls waiting on mutex or doing any other work…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… failed or overly full. Too many deadlocks. Deadlocks (and lock wait timeouts, covered in another plugin) are frequent causes of serious errors… error appropriately. The pmp-check-mysql-status plugin can be configured to alert when Threads_connected approaches max_connections too closely, which can…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 23 Comments
…a queue for new connections on operating system size to allow MySQL to handle spikes. Although MySQL connections are quite fast …connections waiting on connection instead of failing quickly and potentially connecting to different server, but that can be fixed by setting the client connect timeout…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… can get piled up waiting for table metadata lock bringing down the MySQL server or causing all the connections to get depleted. There… 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…
