…timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout (introduced in MySQL… give pt-upgrade a try. It also reads every type of log now (slow, general, … were several bug fixes. See https://launchpad.net/percona-toolkit/+milestone/2.2.1 …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… referring to the amazing MySQL manual, especially the option and variable reference table….commanual named_pipeblogpercona.commanual net_buffer_lengthblogpercona.commanual net_read_timeoutblogpercona.commanual net_retry_countblogpercona.commanual net_write_timeoutblogpercona.commanual newblogpercona…
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
July 8, 2007 By 1 Comment
… query is being read or result set is being sent back, much shorter net_read_timeout and net_write_timeout are used. net_read_timeout rarely becomes the problem… buffering happening inside MySQL client library so you never know when real network read will happen. As net_write_timeout and net_read_timeout are session level…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…_cache_size=1500M –max-connections=1500 –table-cache=512 –net_read_timeout=30 –net_write_timeout=30 –backlog=128 MyISAM / InnoDB: libexec/mysqld –no-defaults…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=8 innodb-read-io-threads=16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb…-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max-allowed-packet=1M net-buffer-length=16K #we… thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… get errors is when you run mysql_query , mysql_fetch_row simply reads data from memory and so most … errors. Connection can timeout If you do not fetch data for long enough MySQL Server may think client … etc. This can be fixed by increasing net_write_timeout variable on the server so it gives you …
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 256M table_cache = 512M sort_buffer_size = 2M read_buffer_size = 2M read…size=6 net_buffer_length = 8K log-slow-queries=/var/lib/mysql/astdb01…./opt/ key_buffer_size=256M connect_timeout=180 wait_timeout=360 tmp_table_size=851443712…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…/sys/net/ipv4/ip_local_port_range” to get more local ports available and “/proc/sys/net/ipv4/tcp_fin_timeout“…were added to PHP during times of MySQL 3.22/3.23 when MySQL was simple enough so you …variables. Many applications are fine – ie if you have read-only page and everything on your site uses …
Post: Sell-an-Elephant-to-your-Boss-HOWTO
August 28, 2012 By 3 Comments
… they.. (“get very unstable response times”, “get timeout for every 10th request”, “need to… 2s or in 5s, let him read this. In the end you have…unless the problem is fixed, the net result is still a significant waste … hardware, optimizing indexes or queries, tuning MySQL etc. which we can offload 80-…
