Best PHP.ini

[Dave Cheney]

Good point, there is an outside chance you are seeing a lot of sorts  
on small tmp tables that never hit the disk, but unlikely

On 20/05/2009, at 7:49 PM, Olivier B. wrote:

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