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

Displaying posts with tag: mysql performance (reset)

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 here for" this free webinar taking place on Thursday November 25th at 13.00 CET.

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), Carrier, dayofweek from ontime_2010
where dayofweek =7 group by Carrier, dayofweek\G
*************************** 1. row ***************************
           id: 1
  select_type:
  [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.


MySQL Query Engine Scalability Issues
+3 Vote Up -0Vote Down
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[...]
Dell MD1120 Storage Array Performance
+2 Vote Up -0Vote Down
Here is some file IO performance numbers from DELL MD1120 SAS storage array. Last year I did the same test with HP P800 storage array and numbers were impressive. But when it comes to this high end storage array, few surprises.  Before getting into actual details; lets see the test stats and configuration details. System Configuration: DELL [...]
Looking just at the data
+1 Vote Up -0Vote Down

There are many areas you need to review when addressing MySQL performance such as current database load, executed SQL statements, connections, configuration parameters, memory usage, disk to memory ratio, hardware performance & bottlenecks just to name a few.

If you were to just look at the data that is held in the database, what would you consider?
Here are my tips, when looking just at the data.

  • What is the current database size?
  • What is the growth of data over time, say daily, weekly?
  • Which are the 2 largest tables now?
  • What 2 tables are growing the fastest?
  • What tables have greatest churn, specifically DELETE’s?
  • How often do you optimize your tables?
  • What is your archiving/purging strategy? Do you even have one?
  • Review data types? I average 25% reduction in footprints, just by

  •   [Read more...]
    10 Newer Entries Showing entries 31 to 40 of 48 8 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.