…join_buffer_size? I saw a my.cnf with a 128M join_buffer_size the other day and needed to…to the question about how the buffer is allocated. Its meaning is actually “minimum join buffer size.” Here’s the code, in…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…to start on a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to…join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…max_connections was the best proxy we had for expected high connection rates when dynamically configuring it at startup. join_buffer_size…to be optimal until full benchmarking to determine perfect size can be done. It’s vital not to set…in the server defaults but in the default my.cnf…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…to see how result stabilizes. [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –num-threads=1 –max…size)/1024/1024 as data_size_mb from innodb_sys_tables as t inner join…to do it in this case. I’m not sure if there are any bad side effects from setting innodb_old_blocks_time to…
