On Mon, Jan 28, 2002 at 09:30:59AM -0600, ryc wrote: > > Hello, > > > > is possible "on the fly" change size of innodb tables ?? > > > > i create table 1G large but is small and i need enlarge it. Can i > > change number in my.cnf or something else ? > > Just add another file entry to my.cnf seperated by commas... You can > add as many seperate files as you like... (within reason of course, > eventually if the line length gets longer than 1024 or so you cant > add anymore). Once you edit the file, restart mysql and innobase > will detect the new file entry and create the file.
In other words, "no". You must restart the server. And the my.cnf line length limit was recently raised to 2KB (2048 bytes). Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 26 days, processed 568,350,627 queries (252/sec. avg) --------------------------------------------------------------------- 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