David,
Wednesday, September 04, 2002, 9:34:55 AM, you wrote:
>From the online manual I see:
DL> --
DL> innodb_data_file_path
DL> Paths to individual data files and their sizes. The full directory path
DL> to each data file is acquired by concatenating innodb_data_home_dir to
DL> the paths specified here. The file sizes are specified in megabytes,
DL> hence the 'M' after the size specification above. Do not set a file size
DL> bigger than 4000M, and on most operating systems not bigger than 2000M.
DL> InnoDB also understands the abbreviation 'G', 1G meaning 1024M. The sum
DL> of the sizes of the files must be at least 10 MB.
DL> --
DL> This implies that I have to preguess how large each data file will be.
DL> Now, I understand with MyISAM tables that they just "grow" until they
DL> fill up your filesystem or hit some OS limit such as the 2Gb limit in
DL> Linux < 2.4.X.
DL> A few questions:
DL> 1) If I setup InnoDB with a 500Mb data file then suddenly run out of
DL> space could I:
DL> * seemlessly just stack another data file by adjusting my startup
DL> options
Yes.
DL> * seemlessly just make the data file larger by changing the file size
DL> (i.e. don't add another datafile, just increase the file size)
No.
DL> 2) Is there a way to make this more dynamic?
DL> * what if a user wants to add a 10Mb blob into my database, but the
DL> datafile has only 5Mb of space left for data...
DL> (with MyISAM tables they just seem to "grow" as needed)
Since 3.23.50/4.0.2 you can specify datafile as auto-extending:
http://www.mysql.com/doc/en/InnoDB_start.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
