…. If 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… read will happen. As net_write_timeout and net_read_timeout are session level variables you can simply change them per connections for connections which could have timeout…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual key_cache_division_limitblogpercona.commanual Key_read_requestsblogpercona.commanual Key_readsblogpercona.commanual Key_write_requestsblogpercona.commanual Key_writesblogpercona.commanual languageblogpercona.commanual…_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_defaultsblogpercona…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…_page_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 table…
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… multiple 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
…innodb-purge-threads=1 innodb-read-ahead=linear innodb-read-ahead-threshold=8 innodb-read-io-threads=16 …write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max-allowed-packet=1M net-buffer-length=…
