Top MySQL Performance Tuning Tips

Wondering around some set of tips to increase our MySQL tables speed and performance.

Found some useful tips at following urls. check out, its really good.

• http://forge.mysql.com/wiki/Top10SQLPerformanceTips
• http://www.ajaxline.com/32-tips-to-speed-up-your-mysql-queries