Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 51 10 Older Entries

Displaying posts with tag: mysql performance (reset)

Top 20 Design Tips for MySQL Data Architects
+0 Vote Up -0Vote Down

Check out this SlideShare Presentation: Top 20 Design Tips for MySQL Data ArchitectsView more presentations from Ronald Bradford.



  [Read more...]
How to Kill Mysql Performance
+0 Vote Up -0Vote Down

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



  [Read more...]
European Lunchtime Webinar: MySQL - Top 5 Performance Sins
Employee_Team +2 Vote Up -0Vote Down

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 …

  [Read more...]
European Lunchtime Webinar: MySQL - Top 5 Performance Sins
Employee_Team +0 Vote Up -0Vote Down

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 …

  [Read more...]
Loose index scan vs. covered indexes in MySQL
+2 Vote Up -0Vote Down

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), …
  [Read more...]
MySQL Performance Tuning - GNUnify 2010
+0 Vote Up -0Vote Down

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



  [Read more...]
MySQL Query And Index Tuning
+0 Vote Up -0Vote Down

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



  [Read more...]
Mysql Explain Explained
+0 Vote Up -0Vote Down

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


Explain
+0 Vote Up -0Vote Down

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


Real World Scalability MySQL
+0 Vote Up -0Vote Down

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


10 Newer Entries Showing entries 31 to 40 of 51 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.