Yes there is, that's what Paul was referring to regarding InnoDB...it has a
table space made up of multiple files on the disk and the tables reside
within the tablespace. Thus the tables are not bound by the file system's
maximum file size.
Details are in the MySQL manual in the table types secti
Hi,
Thanks for the fast response. I wonder there is a
'tablespace' notion in mysql just like the one in
Oracle. One can keep adding datafile from different
disk to the same tablespace and don't have to worry
about how the data is stored in the files.
Thanks again.
--- Paul DuBois <[EMAIL PROTE
Hi,
Thanks for the fast response. I wonder there is a
'tablespace' notion in mysql just like the one in
Oracle. One can keep adding datafile from different
disk to the same tablespace and don't have to worry
about how the data is stored in the files.
Thanks again.
--- Paul DuBois <[EMAI
At 18:05 -0500 6/6/03, Paul DuBois wrote:
At 15:59 -0700 6/6/03, Titu Kim wrote:
2. How can i add another file to a table if the .MYD
file grows too large?
Once the file size reaches its maximum, that's as far as you can go.
I should add to this that one way to obtain an effective larger
"file" siz
At 15:59 -0700 6/6/03, Titu Kim wrote:
Hi I am new to Mysql. I have the following newbie
questions.
1. How can i find/set the file size of for my .MYI and
.MYD file?
You can find the sizes using ls on Unix or dir on Windows.
You don't set the sizes. Let the server manage the files.
2. How can i ad
Hi I am new to Mysql. I have the following newbie
questions.
1. How can i find/set the file size of for my .MYI and
.MYD file?
2. How can i add another file to a table if the .MYD
file grows too large?
3. How to configure mysql client to access two mysql
database on two machines with each datab
