dave at cheney.net
Wed May 20 13:16:55 MSD 2009
Seconded, I would bet that your mysql instance is doing a lot of IO,
mainly because your innodb buffer size is set to low. Given your
sharing that machine with a bunch of php processes you'll have to
tread carefully to avoid swapping.
I would enable the slow query log (don't forget to set the reporting
interval to 1 second, the default is 10) and also log queries that
don't use indexes. Some schema tweaking may be in order.
On 20/05/2009, at 7:04 AM, Kiril Angov wrote:
> Also, take a look at optimizing you MySQL config, there is not much
> you can do about the php.
> Upgrade your PHP and MySQL as per my previous email. let MySQL run for
> at least 48 hours and run this on the server
> It will give you advice on what to optimize in MySQL, you have 2GB of
> memory and MySQL is not using much of it, that seems like a problem.
> On Tue, May 19, 2009 at 11:06 PM, Wicked <nginx-forum at nginx.us> wrote:
>> I have this question postet on vbulletin.com but i have only a
>> anwser for mysql and not for php or php5-cgi
>> top says this
>> Cpu(s): 63.2%us, 14.8%sy, 0.2%ni, 21.6%id, 0.0%wa, 0.0%hi,
>> 0.2%si, 0.0%st
>> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
>> 2261 mysql 15 -5 218m 94m 5364 S 61 4.7 119:27.98 mysqld
>> 7529 www-data 20 0 169m 24m 11m R 25 1.2 0:17.98 php5-cgi
>> 7533 www-data 20 0 164m 15m 7808 S 25 0.8 0:14.86 php5-cgi
>> 7528 www-data 20 0 166m 20m 10m S 23 1.0 0:18.72 php5-cgi
>> 7525 www-data 20 0 166m 20m 10m S 22 1.0 0:21.54 php5-cgi
>> and i think this is high server load for 50 user logged into
>> vbulletin board..
>> i will upgrade my mysql and php..
>> Posted at Nginx Forum: http://forum.nginx.org/read.php?2,2188,2205#msg-2205
More information about the nginx