In the last episode (Feb 03), Prasanth Krishna said:
> Is there any concept of Tablespace for MyISAM tables in MySQL? Even
> if it is not present, is there any concept in MySQL which is
> equivalent to Tablespace in Oracle?
MyISAM tables are stored as separate files in the filesystem, so you
could think of each table as having two "tablespaces"; one for the data
(table.MYD), and one for the index (table.MYI).
InnoDB tables are stored in tablespaces just like Oracle, except there
is only one global tablespace and you can't specify that table A and
table B go into different files.
--
Dan Nelson
[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
