On Mon, Jun 18, 2001 at 03:56:32AM -0700, Jamie Krasnoo wrote:
>
> [mysqld]
> datadir=/data1;/data2;/data3
>
> - or -
>
> datadir=/data1:/data2:/data3
>
> As it stands now, both will produce an error and MySQL will not start.
>
> Other ways could be like: RAID_DIRS=/data1:/data2:/data3
Well, I'll throw my thoughts in as well...
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.
As for the exact syntax, I don't know what might be best.
Jeremy
--
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 2 days, processed 16,991,404 queries (79/sec. avg)
