Boston Linux & UNIX was originally founded in 1994 as part of The Boston Computer Society. We meet on the third Wednesday of each month at the Massachusetts Institute of Technology, in Building E51.

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Discuss] issue with mysql in a VM on Ubuntu 14.04.4 LTS

Jerry Feldman <gaf at> writes:

> My friend got back with some information.
> This is a dedicated web server VM (virtual machine) running Ubuntu 14.04
> LTS.  This is only running a single site, yet CPU usage reaches 100%
> with only a few simultaneous users viewing the site.  Looking deeper it
> appears that MySQL is using the majority of the CPU resources.  When
> this happens, the hosted website is extremely slow or unavailable. 
> Restarting the Apache and MySQL services temporarily helps, but a reboot
> seems to have a longer effect. 
> In troubleshooting the issue we have made several changes to various
> conf files to increase buffers, caches, memory limitations, etc.

What about DB level stuff?  Can you narrow it to a particular query?
Have indexes changed?  Does MySQL have some concept of statistics that
help the query optimizer and can get stale?

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /