… set is being sent back, much shorter net_read_timeout and net_write_timeout are used. net_read_timeout rarely becomes the problem unless you have extremely…. 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 issues…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…_limitblogpercona.commanual Key_read_requestsblogpercona.commanual Key_readsblogpercona.commanual Key_write_requestsblogpercona.commanual Key_writesblogpercona.commanual languageblogpercona.commanual large_files_supportblogpercona…_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
…, 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…
Comment: PHP Large result sets and summary tables.
July 8, 2007 By 8 Comments
[...] my previous post I mentioned you might need to increase net_write_timeout to avoid connection being aborted and now [...]
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…-table innodb-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=16K #we…
