… net_write_timeout to avoid connection being aborted and now I think I should have better explained that. MySQL uses a lot of different timeout… 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…
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: 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: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… of swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result… to catch errors. Connection can timeout If you do not fetch data for long enough MySQL Server may think client is dead… 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
…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…table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now…
