View Single Post
Old 12-15-2007, 01:01 PM  
tg989
Registered User
 
Join Date: Jun 2007
Posts: 89
Quote:
Originally Posted by Babaganoosh View Post


You're kidding, right? As the demands on my mysql server change, I change my my.cnf file to suit my needs. For those changes to take effect, mysql must be restarted. The restart just takes a few seconds and doesn't affect the traffic at all.

I'd be much more concerned with any host who is willing to just set up mysql and never tweak it again regardless of the servers workload.
not true, you can change almost all the variables from the mysql command line on-the-fly.

SET GLOBAL [varname]=[value]

then edit your my.cnf so it will remain next time the server is restarted.
__________________
there are 10 types of people in the world, those who understand binary, and those who don't.
tg989 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote