Let's Grow Your Business




Advanced Mysql Query And Schema Tuning By Alexander Rubin Or Percona


Last week I participated in a terrific webinar on MySql performance. Lots of pertinent information on B-TREE indexing, group by and order by queries, and creating keys.

Using the left most key to create really fast database search queries was an eye opener. Covered indexes were also covered.

I use MySql everyday and did not realize how simple changes to the structure of your queries makes a big difference in the number of rows searched and the speed at which queries are executed.

Loose index scan verses tight index scan were also covered. File sort, temporary tables and other regularly overlooked query optimization information.

The webina was conducted by Percona, who host the MySql performance blog


Using Great Content To Increase Links To Your Huntsville Website
Let's Talk: (256) 429-8145