[lug] mysqldump versus snapshot versus..

[dio2002 at indra.com]

> BTW, I just finished load-testing our web app with mysql 5.x and it's
> almost a 2x speed improvement over 4.x with the exact same hardware, data
> and test scenarios.  Almost a no-brainer to switch over to 5.x if you have
> that option.

based upon your experience, care to share any basic optimization
techniques? my.cnf settings, etc? :-)

fwyi, i'm already using mysql 5.