javaj

You could copy and past to try it, just back up the original and restart mysql and see if you any complaints or it fails than go with the original my.conf format and change all the lines like this,

[mysqld]
set-variable = max_connections = 400
set-variable = key_buffer = 16M
set-variable = myisam_sort_buffer_size = 32M
set-variable = join_buffer_size = 1M

etc,

I am going to try this myself in a few days...

pizzicar

Be sure to post the results of your changes when you have a chance to check them out - be nice to have some hard data on performance tweeking.

__________________
"Argue for your limitations, and sure enough, they are yours"

Skipdawg

Yes indeed it would. I've heard some say it's worth while and others say it's not so data support one way or the other would be cool.

__________________

javaj

For whatever reason mysql just pukes out on me on anything but the original, I tried copy and paste and going with the original format in my config ie, "set-variable" but niether works, could be depreciated settings in this version of mysql or whatever, I'm no mysql expert, but to get it to work it would have to be tested line by line to see what does and doesnt work and testing from there.

I may play around with this again later but I thought I would post to let ya know I had no luck with the mysql tweaks so far.