…_limit PHP config variable because that only controls memory which passes via PHP memory management which does not apply to MySQL 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
… cd shard-query #generate a config for 20 shards (adjust to…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…transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be …
