[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.

fyi, i just read your memcahced suggestion now in another post...