…timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout…, give pt-upgrade a try. It also reads every type of log now (slow, general, binary…there were several bug fixes. See https://launchpad.net/percona-toolkit/+milestone/2.2.1 for …
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… library so you never know when real network read will happen. As net_write_timeout and net_read_timeout are session level variables you can simply…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… Handler_read_firstblogpercona.commanual Handler_read_keyblogpercona.commanual Handler_read_lastblogpercona.commanual Handler_read_nextblogpercona.commanual Handler_read_prevblogpercona.commanual Handler_read_rndblogpercona.commanual Handler_read_rnd…_use_mmapblogpercona.commanual named_pipeblogpercona.commanual net_buffer_lengthblogpercona.commanual net_read_timeoutblogpercona.commanual net_retry_countblogpercona.commanual net_write_timeoutblogpercona.commanual newblogpercona.commanual no…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…_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…-thread-concurrency=8 –max-connections=1500 –table-cache=512 –net_read_timeout=30 –net_write_timeout=30 –back_log=128 Method of benchmark: 1. Prepare…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… cleared until you fetch whole result set if you’re reading from tables directly (if you do not have “using temporary…, which can cause rather hard to catch errors. Connection can timeout If you do not fetch data for long enough MySQL… value INSERTs etc. This can be fixed by increasing net_write_timeout variable on the server so it gives you more time…
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…-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…_cache = 512M sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 1M myisam_sort_buffer_… thread_stack=256K myisam_data_pointer_size=6 net_buffer_length = 8K log-slow-queries=/var/…tmpdir = /opt/ key_buffer_size=256M connect_timeout=180 wait_timeout=360 tmp_table_size=851443712 Can …
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… “/proc/sys/net/ipv4/ip_local_port_range” to get more local ports available and “/proc/sys/net/ipv4/tcp_fin_timeout” to… session variables. Many applications are fine – ie if you have read-only page and everything on your site uses same charset…
Post: Sell-an-Elephant-to-your-Boss-HOWTO
August 28, 2012 By 3 Comments
… month] because they.. (“get very unstable response times”, “get timeout for every 10th request”, “need to wait 10s for…website loads in 2s or in 5s, let him read this. In the end you have to come up…the obsticles and unless the problem is fixed, the net result is still a significant waste of money, …
