…to determine when an in-memory temporary table will be converted to an on-disk table…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… order to keep data entirely in memory. This frees disk to use on-disk …to select all text on the page and then CTRL-C to copy it. Paste this into a text file on shard1 called “/tmp…TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…memory of 1G-2G where the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to…to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname tmpdir =/mysql_tmp/:/tmp/ # Uncomment the following if you are using BDB tables…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…to delete snapshots after finishing, sometimes due to the backup script failing before completion. Additionally, LVM snapshots that don’t have enough copy-on…memory and cause the server to swap until it is unresponsive and has to…
