Andrzej,
As I understand it,
MySQL does not have the concept of tablespaces like in Oracle. Databases are
subdirectories underneath the /var/lib/mysql directory and files are tables
within those subdirectories, so you can put an entire database or individual
files on a different disk by creating a folder on the other disk with the
proper permissions and then linking to that folder from /var/lib/mysql as
detailed in the manual:
http://www.mysql.com/doc/S/y/Symbolic_links.html
The InnoDB table type has the concept of tablespaces:
'InnoDB stores its tables and indexes in a tablespace, which may consist of
several files. ' from http://www.mysql.com/doc/I/n/InnoDB_overview.html
for MyISAM tables, in terms of limits, each table consists of three files:
one for the table definition, one for the data, and one for the indexes.
Thus neither the data file nor the index can be larger than your OS
supports, which is 2GB on linux AFAIK.
In my experience working with mysql and oracle, the same table in mysql is
much smaller than it would be on oracle, often by a factor of five or more.
I'm not sure that others see this ratio of table sizes.
braxton
-----Original Message-----
From: Andrzej Janczyszyn [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 22, 2001 11:46 PM
To: [EMAIL PROTECTED]
Subject: Generic questions
Where may I find more detail information about MySQL DBA?
How MySQL handle very large table (>10,000,000 records)?
How can I give direction where store data files?
example:
/var/lib/mysql
|
MYDATABASE
|
---- SPACE1
(/dev/sda3)
|
---- SPACE2
(/dev/sdb1)
|
--- SPACE3
(/dev/sdc2)
Is it possible specify size and location of designated data files for a
specific tables (like
in Oracle create a table space and give a location of datafiles)?
What are MySQL limits?
All the questions relate to MySQL on Linux.
Thanks,
AMJ
---------------------------------------------------------------------
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
