May 24, 2012

Comment: MySQL: what read_buffer_size value is optimal ?

… the my.cnf): key_buffer_size 268435456 sort_buffer_size 131064 read_buffer_size 126976 read_rnd_buffer_size 126976 join_buffer_size 126976 myisam_sort_buffer_size 131072 The key_buff shows the proper “268435456″ which is 256

Post: Shard-Query EC2 images available

…=0 innodb-stats-on-metadata=0 innodb-stats-sample-pages=256 innodb-stats-update-need-lock=0 innodb-status-file innodb…-use-sys-stats-table innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log… partition=ON port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT…