On Thu, Feb 01, 2001 at 01:34:03PM +0000, Basil Hussain wrote:
>
> In the light of my recent experiences with tuning my MySQL server, I
> had a few ideas about how getting optimum performance from your
> MySQL server could be made a little easier for everyone.
Agreed. Better documentation and examples will help, but so will what
you discuss below.
> My idea is to have some kind of facility to 'auto-tune' the server
> configuration variables for you. Although tuning manually seems to
> be more trial-and-error than deduction and formulation, I'm sure
> that it's possible to work out rules for what needs to be configured
> and how from information that is usually readily available about the
> environment that the server is running in.
I talked with Monty and David about this briefly last year at the open
source database summit (several months ago).
Monty mentioned that they're looking at making virtually all of the
run-time variables changeable WITHOUT a server restart. Once that
happens, it's just a matter of programming and benchmarking to have a
self-tuning system (to some degree).
> I'd like to know what people think - whether it's just crazy and
> would never be feasible or if it could genuinely be something
> possible and something useful.
It's certainly useful. As soon as I heard about the tunable parameters
without a restart, the first thing that jumped to mind was a database
tuning application.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
