… Gearman MySQL UDF interface to apply update transactions to the master (but having the batch job only use the slave connection). You only need to implement a generic Gearman Worker to take update transactions to apply and pace MySQL transactions… DB load increases. And better yet, you could use Percona MySQL Cluster to have a dedicated master for all batch job…

…, key_buffer_size etc, you have reasonable amount of connections but yet MySQL takes much more memory than you would expect, causing… max_packet_size per connection) are all connection buffers and so if you close connection MySQL can clean them up. Killing connections (or stopping related… if you close connection. In Percona Server you can do better as you can query temporary tables too: mysql> select sum(data…

… about 20 tables (thank you ORM by joining all tables connected with foreign keys just in case) which would take 5… further I found the following explanation from Timour Katchaounov in MySQL mailing list archives I have some recollection that there were… plan computation would be more important than backward compatibility. In MySQL 5.6 things are likely to get even better handling…