…timeout (or interactive_timeout for applications which specified they are interactive during connection). This value…long enough to trigger default net_write_timeout on the server side….MySQL client library so you never know when real network read will happen. As net_write_timeout and net_read_timeout…
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… –net_read_timeout=30 –net_write_timeout=30 –backlog=128 MyISAM / InnoDB: libexec/mysqld –no-defaults … with only different the values of accessed column is stored…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… plenty of swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result… periodic data flushes, ie with multiple value INSERTs etc. This can be fixed by increasing net_write_timeout variable on the server so it…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=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 value…
