A problem I have with InnoDB tables, which forced me to use MyISAM tables in
a recent project, is as follows:
(I am running MySQL on Solaris, not that it matters much for this problem.)
With MyISAM tables, I can easily get different databases to reside on
separate physical drives.
The base directory for database files is /var/mysql/
Then I mounted a drive at /var/mysql/db_a
and another at /var/mysql/db_b
for instance. Then databases by the names "db_a" and "db_b" reside on
different physical drives.
But with InnoDB, you specify a tablespace file(s) and then the database you
create go into
those files. I cant figure out any reasonable way to tie specific databases
to specific drives,
except by running a mysqld server for each drive I want a database on.
For large databases, proper planning of disk geometry can have a significant
effect
on performance. I very much like InnoDB, but can't seem to get around this
problem.
Any insight would be greatly appreciated.
sean peters
speters@stripped