Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 48

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...]
    HoneyMonitor v.1.0.16-beta released!
    +0 Vote Up -0Vote Down

    We are pleased to announce the release 1.0.16 of HoneyMonitor, our GUI for MySQL™ administration and monitoring.

    In this release, available for immediate download, we have fixed many bugs and included several improvements.

    We are working to release a RC version as soon as possible.

    The following is the list of changes:

    • New Features:
      • new Tab “Defaults Folders” in the “HoneyMonitor Options” Window to set the default
      [Read more...]
    Step by Step Guide on How to Create a Customized Performance Report using HoneyMonitor
    +0 Vote Up -0Vote Down

    Reading this article you will learn how to create a Customized Performance Report for one of your MySQL™ Servers using HoneyMonitor, a GUI for MySQL™ Server Administration, Monitoring & Performance Tuning.

    Contents

    • Introduction
    • Step 1 - Choosing a File Name and Opening the Report Designer
    • Step 2 - Editing the SQL Queries used by the Report
    • Step 3 - Editing the Charts contained in the Report
      • Axis
      [Read more...]
    The Awkward Stage of Scaling
    +0 Vote Up -0Vote Down
    A lot of my clients are in a position where their database performance is deteriorating but they are not “big enough” (or not willing/able to) explore sharding all of their data structures. They’re too big for the solution to be adding another read slave, but too small to justify the resources for re-designing their [...]
    Case Sensitive Fields
    +0 Vote Up -0Vote Down
    Yes, it has been too long since I last posted on this blog (3 months) - that's my apology; let's move forward.There's too many interesting MySQL bits and pieces that I still come across my desk that I cannot help but post these fantastic learning opportunities to my blog. Obviously, you can read about all things interesting from PlanetMySql.org, but I hope that my blog will help sift people
    The Dangers of Having status fields
    +0 Vote Up -0Vote Down
    Having a status column is very common in databases today. It can be used to denote a user status: CREATE TABLE IF NOT EXISTS `user` ( `user_id` int(10) unsigned NOT NULL auto_increment, `email` varchar(32) NOT NULL, `pw_hash` char(40) NOT NULL COLLATE latin1_general_cs, `status` enum('PENDING', 'ACTIVE', 'DISABLED') default 'PENDING', `date_created` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`user_id`), UNIQUE KEY `idx_email` (`email`) ); or user-uploaded [...]
    Must we always escape values?
    +0 Vote Up -0Vote Down
    One of the cardinal rules of writing web applications is to escape user-generated input with functions like PHP’s real_escape_string. This is a great rule, but one that can have a negative impact on your application’s performance if used unnecessarily. For instance, when querying data with an integer parameter that is passed internally (not [...]
    The Query Performance Improvement Process
    +0 Vote Up -0Vote Down
    The purpose of this post is to outline a general flow-chart for improving the performance of queryies in MySQL. Much has been written on using EXPLAIN to optimize queries, but there is a whole process that should be followed in order to maximize the effectiveness of query performance tuning. Following is a visual [...]
    Using Nagios as a MySQL Performance Profiler
    +0 Vote Up -0Vote Down
    Everybody knows than Nagios can be used as a service monitor to monitor things like Load Averages, MySQL Replication Status, RAID Array States, etc… Fewer know that there are plug-ins to monitor MySQL Performance Status, such as check_mysql_perf. Fewer still utilize Nagios’ built-in triggering mechanism to execute an additional script on the event of [...]
    Previous 30 Newer Entries Showing entries 31 to 48

    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.