Optimizing MySQL and Apache - Help

[Lock Down]

Well it cut down our list.

It is suggesting these changes:
Variables to adjust:
query_cache_size = 40M
join_buffer_size = 4.0M
tmp_table_size = 64M
max_heap_table_size = 64M
table_cache = 6192

Lock Down Reviewed by Lock Down on 3rd May 2010. Optimizing MySQL and Apache - Help Hello, I have been having some load issues with my server due to the response time in the MySQL server (I suspect that it is due to that). The load hits to 15/20 at peak hours (like just about 2 hours) and is below 1 most of the time. I have been tracking down the process on what is causing it and it seems it is the ajax chat on about 3 websites on the server. I would like to optimize the server in such a way that the ajax chat does not cause any issue to the server and slow down the other Rating: 5

[optimushunk]

Well it cut down our list.

It is suggesting these changes:
Variables to adjust:
query_cache_size = 40M
join_buffer_size = 4.0M
tmp_table_size = 64M
max_heap_table_size = 64M
table_cache = 6192

Alright, I'll do that. Although I'll wait for others input for a day and then implement it so everything can be done together and I do not have to wait for 48 hours every time.

I just have a doubt,
I don't suppose the join_buffer_size would be 4.0M, it .0 at the end makes mysql fail to restart in a few variables. Are you sure this would work out?

Were you using MySQL 5.0 before? I am wondering about upgrading sql to 5.1 about stability, but does it cut down on resource/optimization ?

I already use 5.1 since past 2 months. It has given quite a significant impact from processor to processors.