…sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL will allocate a lot of memory …connection) are all connection buffers and so if you close connection MySQL can clean them up. Killing connections (or stopping related applications) and observing whenever memory usage…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…mysql tables in use 1, locked 0 MySQL…connection, or ACTIVE if transaction is active. Note transaction can be active even if connection is in “Sleep…memory usage. You can see total memory allocated by Innodb (sometimes it is higher than you anticipated), amount of memory allocated in additional memory…
Post: Living with backups
November 6, 2008 By 28 Comments
…by the system in memory and kept there for a long time. Since memory access is way faster…-tools/tar … Please cosult ionice man page for usage details, it’s really very simple to grasp…last; } sleep(1); } What this script does is to check MySQL status every second and in case the number of connected…
