innodb tablespace size
innodb_data_file_path=ibdata1:100M:autoextended:max:200M anyone knows what happen if the above innodb tablespace reach the limit of 200M? Thanks in advance. Natale Babbo sql __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.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
Re: innodb tablespace size
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 25 October 2002 14:50, Natale Babbo wrote: innodb_data_file_path=ibdata1:100M:autoextended:max:200M anyone knows what happen if the above innodb tablespace reach the limit of 200M? I would assume you will get an error: table space full :) Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9uUFeSVDhKrJykfIRAoPfAJ0UZjmT2BBal5mW/jfVgB+vu09TrQCfZbjv vq9XTdj4P5PJUz9Xfm0d61U= =yqLm -END PGP SIGNATURE- - 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
RE: innodb tablespace size
My guess is that you can not operate the db when space is required and you get error message. Like when trying to alter a table it will tell you that the table is full. This is because MySQL will create a temporary table drop the original and rename the new one. HTH JFernando -Original Message- From: Natale Babbo [mailto:natale_babbo75;yahoo.it] Sent: October 25, 2002 08:51 To: [EMAIL PROTECTED] Subject: innodb tablespace size innodb_data_file_path=ibdata1:100M:autoextended:max:200M anyone knows what happen if the above innodb tablespace reach the limit of 200M? Thanks in advance. Natale Babbo sql __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.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 - 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
Re: innodb tablespace size
At 14:50 +0200 10/25/02, Natale Babbo wrote: innodb_data_file_path=ibdata1:100M:autoextended:max:200M anyone knows what happen if the above innodb tablespace reach the limit of 200M? It stops getting bigger. :-) What do you mean by what happen? That is, what are the conditions for which you expect something to happen? If the tablespace fills up and then you run nothing but SELECT queries, nothing unusual will happen. If the tablespace fills up and you try to add more rows to your InnoDB tables, likely you won't be able to. (See http://www.innodb.com/ibman.html#Error_handling for information.) Thanks in advance. Natale Babbo sql - 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