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
- Subject: [Discuss] issue with mysql in a VM on Ubuntu 14.04.4 LTS
- From: gaf at blu.org (Jerry Feldman)
- Date: Fri, 1 Apr 2016 07:37:08 -0400
- In-reply-to: <CAEvgogG6vO6jyAA6o5-+jTEWjEiPi=FXV4dr+9nGsYLFNCie6g@mail.gmail.com>
- References: <CAEvgogHtgXeVNOhuu3zw=vSuHcJr=onAnnXCSb0jYQh9JxW=fg@mail.gmail.com> <20160329133143.GS3387@randomstring.org> <CAEvgogG6vO6jyAA6o5-+jTEWjEiPi=FXV4dr+9nGsYLFNCie6g@mail.gmail.com>
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. The VM has 6 virtual processors assigned and 6 GB of RAM (statically assigned). The website is running WordPress with a MySQL back-end. The MySQL database is about 1 GB in size (see image below gaf:images remove for listserv). The host is a Windows Server 2012 R2 server with the Hyper-V role. It has two Xeon E5-2640 CPUs and 128 GB of RAM (46 GB free). The host is performing nicely as are all other VMs hosted on it. gaf: I have a few ideas, such as giving mysql more memory, and maybe fewer vCPUs. On 03/29/2016 11:58 AM, Jerry Feldman wrote: > Thanks Dan, > yes I know. Looks to me that there might be a deadlock. But, with that > short description there is no way to really diagnose. > > On Tue, Mar 29, 2016 at 9:31 AM, Dan Ritter <dsr at randomstring.org> wrote: > >> On Tue, Mar 29, 2016 at 08:51:40AM -0400, Jerry Feldman wrote: >>> Essentially this is in a virtual machine (probably Microsoft) He has 6 >> CPUs >>> assigned to the Ubuntu VM. Not sure of the memory. On occasion all the >> CPUs >>> are pegged at 100%. I've asked him for some additional details, such as >>> memory configuration, physical server configuration, and if he can run >> top >>> or some other tools. >>> >> Without any further diagnostics, the problem is insoluble. >> >> However, I would bet a shiny nickel it has to do with I/O more >> than CPU. >> >> -dsr- >> > > -- Jerry Feldman <gaf at blu.org> Boston Linux and Unix PGP key id:B7F14F2F PGP Key fingerprint: D937 A424 4836 E052 2E1B 8DC6 24D7 000F B7F1 4F2F
- Follow-Ups:
- [Discuss] issue with mysql in a VM on Ubuntu 14.04.4 LTS
- From: smallm at sdf.org (Mike Small)
- [Discuss] issue with mysql in a VM on Ubuntu 14.04.4 LTS
- Prev by Date: [Discuss] blu dns misconfiguration ?
- Next by Date: [Discuss] issue with mysql in a VM on Ubuntu 14.04.4 LTS
- Previous by thread: [Discuss] blu dns misconfiguration ?
- Next by thread: [Discuss] issue with mysql in a VM on Ubuntu 14.04.4 LTS
- Index(es):