Quote Originally Posted by Lock Down View Post
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?

Quote Originally Posted by deelow66 View Post
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.