Server version: 5.1.63-0ubuntu0.10.04.1-log (Ubuntu) On Fri, Oct 12, 2012 at 3:22 PM, Jeff Wolkove wrote: > What build & version of mySQL are you running now? How much memory is set > aside for cache, etc? It may help to post your my.cnf (edited for privacy) > > Jeff Wolkove > > > ----- Reply message ----- > From: "Vimal Shah" > To: , " Main PLUG discussion list" < > plug-discuss@lists.plug.phoenix.az.us> > Subject: [AzPHP] Tuning MySQL DB server > Date: Fri, Oct 12, 2012 1:44 pm > > > Hello all, > > I recently had many teachers and students logging into my site, this is a > good thing. The server infrastructure (Linode VPS = 1 load balancer => 2 > webservers and 1 database (DB) server) started to show CPUs that were > railing at peaks times on the Munin graphs. This was not so good. The > bandaid (which I need to fix) was to add more servers, I now have 5 > webservers each have 2GB of RAM and have 2.2.7 GHz CPU (4 of them on each > box). This has to be overkill.. Later, realized that MySQL's system > variables were not optimized for the DB server. Ran Percona's > configuration tool along with the mysqltunner > perl script . This led > to the discovery that 32-bit version of Ubuntu will not allow MySQL to use > any more that 2GB. > > NEW DB server = After upgrading the DB server to 8GB and along with going > to 64-bit Ubuntu 10.04, I am *still unable to get to the box to use all > the memory*. The process I've been using is (1) use apache bench or > jmeter to fling large connections (and long queries) at the DB server (2) > run the tuner script to see it's recommendations to the system variables > (2) update the variables, restart mysql and start over.. > > This has led to unsatisfactory results. I know that fixing the slow > queries (which is in process) is a place to start, but I feel that the DB > server should be using more RAM. Can someone point out the flaws in my > process or maybe even suggest a better way to do this? > > Thank you very much for you time. > > First day DBA, > -Vimal > > PS Thanks Eric C., for starting me down the right direction. > > _______________________________________________ > azPHP mailing list > azPHP@list.azphp.org > http://list.azphp.org/mailman/listinfo/azphp_list.azphp.org > > -- Vimal (rhymes with Kimmel) Shah VP of Engineering Sokikom Mobile: (480) 752-9269 Email: vimals@sokikom.com Web: www.sokikom.com Follow us: twitter.com/sokikom Like us: facebook.com/sokikom