Solved

Database Engine Tuning Advisor for mysql

Posted on 2010-09-03
3
1,449 Views
Last Modified: 2012-05-10
Can someone refer Database Engine Tuning Advisor tool like MS SQL?

I need to optimize automatically mysql tables based on queries load, like Profiler in MS SQL.

Thanks.
0
Comment
Question by:NickHoward
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
AndyEastham earned 250 total points
ID: 33609867
0
 

Author Comment

by:NickHoward
ID: 33611574
Andy,

Thanks for the link.

I am looking for some specialized tool which can do fine tunning like indexing based on queries load captured.

Hope someone know such tool(s).
0
 

Author Closing Comment

by:NickHoward
ID: 33735326
Bit helpful.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question