On Tue, Jun 19, 2001 at 04:49:58AM +0200, Tonu Samuel wrote:
> On Mon, 18 Jun 2001, Jeremy Zawodny wrote:
>
> > I'd use a combination of my.cnf entries and SQL. The my.cnf entry (or
> > entries) woudl list the available directories, like others have
> > suggested. Then, using SQL, you could:
> >
> > * Mark a table to be "spread out" at creation time vis some
> > attribute.
> >
> > * Possibly do it after the fact using ALTER TABLE.
> >
>
> Maybe you are right. I am thinking about security and this is a not
> the best idea if we introduce a way to write data anywhere on the
> disks on user request.
Indeed.
> Meanwhile any change in cnf file requires restart of MySQL which is
> not always possible :(.
A while back (at last year's database summit), Monty made some
rumblings about maybe making it possible to modify many (most?) of the
server variables without an actual restart.
Is that that on the horizon for MySQL 4.x, or did it become more
difficult that originally thought?
If it does happen, I'll start working on the MySQL self-tuning add-on
so that folks don't have to play with their my.cnf files as
much... Really. I think it'd be fun to build and VERY useful.
Then MSSQL wouldn't be the only [advertised] self-tuning database
server in the market. :-)
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 2 days, processed 20,171,403 queries (79/sec. avg)
---------------------------------------------------------------------
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
