Hi,
> 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 hadn't really thought about the concept in terms of dynamic configuration
changes without taking the server down. Sounds great!
However, I think if the MySQL developers are thinking about adding some kind
of self-tuning on top of dynamic configuration changing, then some heavy
thought needs to go into any implementation. Having the server automatically
adapt to usage patterns and change it's own config without any kind of
control, notice or restarting of the daemon could get sticky. If not
implemented right, you might have a situation where MySQL adapts its config
wrongly to a prolonged freak period of heavy (or very light) usage which
would have trailing repercussions as normal usage is resumed.
But, as always, these are problems that can simply (or not so simply) be
overcome by good design and programming.
> 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.
I'm glad I'm not the only one who's thought of this... :)
With dynamic configuration, I now envisage some kind of secondary tuning
daemon that runs in parallel to MySQL that continuously tails log files to
gather and store commonly used queries as well as regularly taking snapshots
of status statistics. It would then periodically analyse the data it's
recorded and dynamically make changes it thinks (or rather, to be on the
safe side, knows) would make an improvement to common usage. After it has
made changes, it would (for while, at least) go into 'sit-back-and-watch'
mode, in order to compare performance after the event to what it was before.
If it's worse, it dynamically restores the previous config - this might
partially avoid the scenario I described earlier.
Regards,
------------------------------------------------
Basil Hussain ([EMAIL PROTECTED])
---------------------------------------------------------------------
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
