Quote:
Originally Posted by tiger
That's fine and good, its a good starting point but one size doesn't fit all. You have to adjust my.cnf according to what you are doing. One script doing 100k maybe fine with that config and another site doing 10k could crash hourly.
|
yes i was going to say the same thing, there's a couple of scripts about that advise on modifying my.cnf.
here's one
http://blog.mysqltuner.com/ you need to run it for 24-48 hours before it can give suggestions.