Best PHP.ini

[Olivier B.]

There is 0.0%wa, so I'm not sure this is a IO problem.

Olivier

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.
>
> Cheers
>
> Dave
>
> 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
>>
>> http://www.day32.com/MySQL/tuning-primer.sh
>>
>> 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:
>>> Hello
>>>
>>> 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
>>>
>>>
>>>
>>
>
>