Gary V wrote: > > I was curious about a couple settngs that I heard can affect performance > when using Innodb so I did a few ad hoc tests: > > http://www200.pair.com/mecham/spam/mysqlspeed.txt > > http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ > > http://www.mysql.com/news-and-events/newsletter/2003-11/a0000000269.html >
Thanks Gary, I've always pointed people elsewhere when it comes to SQL tuning, on the theory that other places have much better information. For sure, if you are using SQL in SpamAssassin you're going to want to be doing some additional tuning on your database server. Maybe its time we started up a wiki page that collects a few links and various information about SQL performance tweaks that people are finding that work. If you could get that ball rolling I'm sure others would join in and add to the wiki page with their own data. Thanks Michael
