Monitoring MySQL on a Small Server
Posted by waverate on October 24, 2011 at 1:11pm
I have a Drupal multisite installation with one RackSpace Cloud Server for the web server and another Cloud Server for the database. The web server has Varnish, APC, Memcache and Apache while the database server is running MySQL. Internetworking between the web server and database server is via the RackSpace private network.
I have been adding Drupal multisites to the web server and creating the corresponding database tables.
The Cloud Server for the database has 256MB RAM with no swap. $top shows 23MB free on restart and goes down to about 5MB free on prolonged use.
Read more