nginx.list at daevel.fr
Wed May 20 13:49:51 MSD 2009
There is 0.0%wa, so I'm not sure this is a IO problem.
Dave Cheney a écrit :
> 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:
More information about the nginx