… rows. Note this limit is not controlled by memory_limit PHP config variable because that only controls memory which passes via…, 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
… 20 shards (adjust to your number of nodes) php genconfig 20 > shards.ini Running the test For …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…

