Bug #4431 Intelligent MySQL Server
Submitted: 7 Jul 2004 9:22 Modified: 21 Dec 2005 14:06
Reporter: Mickael Besson Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Optimizer Severity:S4 (Feature request)
Version:4.1.3 OS:Windows (Windows NT 4 and others maybe)
Assigned to: CPU Architecture:Any

[7 Jul 2004 9:22] Mickael Besson
It will be too practical that server analyse itself, depending to its logs and variables (utilization of server), the points to increase and for example tells to user the modifications to realize (or automaticly). Example :
- set the InnoDB buffer lager and index buffer smaller
- adjust variables more useful for consulting request (when there's a lot of select)
- adjust query cach size and give comments
- indicate when table should be MyIsam instead of InnoDB (and conversely).
- generally, indicate all informations to optimize server depending to its utilization

It will be mervelous !

How to repeat:

Look at server variables and logs to optimize server performances

Suggested fix:

Weekly, server analyse and propose to make automatically modifications or manually.
[27 Jul 2004 9:58] Heikki Tuuri

yes, this would be a really nice feature, if possible to implement in practice.

Microsoft SQL Server has made some steps towards a 'self-tuning' database server. For example, it adjusts the size of the buffer pool on its own.


[21 Dec 2005 14:06] Valeriy Kravchuk
Thank you for a useful feature request. Looks like some steps towards the implementation of that idea (adding intelligence somehow) are already done.