Check out this SlideShare Presentation: How to Kill Mysql PerformanceView more presentations from techdude.

…

Next Thursday Oracle University will be hosting a lunchtime webinar, between 13.00 and 14.00 CET, to help you better understand the common MySQL mistakes impacting performance that you should avoid.

Oracle's senior MySQL instructor and consultant Kai Voigt will review the MySQL "no no's" and advise on what simple solutions should be used instead. Kai will also provide an introduction to indexing, rewriting of queries, monitoring the use of temporary tables, and other things you should know about.

You can register here for this free webinar taking place on Thursday November 25th at 13.00 CET.

Next Thursday Oracle University will be hosting a lunchtime webinar, between 13.00 and 14.00 CET, to help you better understand the common MySQL mistakes impacting performance that you should avoid.

Oracle's senior MySQL instructor and consultant Kai Voigt will review the MySQL "no no's" and advise on what simple solutions should be used instead. Kai will also provide an introduction to indexing, rewriting of queries, monitoring the use of temporary tables, and other things you should know about.

You can register here for" this free webinar taking place on Thursday November 25th at 13.00 CET.

Loose index scan in MySQL can really help optimizing “group by” queries in some cases (for example, if you have only min() and/or max() as your aggregate functions). For example, if you have this query (to find maximum delay for all US flights with departure on Sundays in 2010):

select max(DepDelayMinutes),       carrier, dayofweek 
from ontime_2010 
where dayofweek = 7 
group by Carrier,  dayofweek

the usual case will be adding a covered index on (dayofweek, Carrier, DepDelayMinutes). And MySQL will use this index fine (using index mean it will use the covered index):

mysql> explain select max(DepDelayMinutes), Carrier, dayofweek from ontime_2010 
where dayofweek =7 group by Carrier, dayofweek\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: ontime_2010
         type: ref
possible_keys: covered
          key: covered
      key_len: 2
          ref: const …

Check out this SlideShare Presentation: MySQL Performance Tuning - GNUnify 2010View more presentations from OSSCube LLC A Global Open Source Enterprise for Open Source Solutions.

…

Check out this SlideShare Presentation: MySQL Query And Index TuningView more presentations from Manikanda kumar.

…

Check out this SlideShare Presentation: Mysql Explain ExplainedView more presentations from Jeremy Coates.

Check out this SlideShare Presentation: ExplainView more presentations from Ligaya Turmelle.

Check out this SlideShare Presentation: Real World Scalability MySQLView more presentations from techdude.

Lately in the MySQL community, we only hear about scalability or performance improvements of storage engines, but nothing about query engine itself. For example, one classic example being InnoDB; if[...]