Solved

Database Engine Tuning Advisor for mysql

Posted on 2010-09-03
3
1,473 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySqlDump not dumping triggers 1 52
Excel - SQL export question 3 53
Inserting data into database 10 46
Where on a calculated field 1 29
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

679 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