Best PHP.ini

[Dave Cheney]

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
>>
>>
>>
>