I have now ReadTheFineManual ;-) and learned that I can use autoextend and create a new innodb-data file by changing my.cnf and restart mysql. I've also done just that with success, now I have an autoextend database file and two static ones.
Is there any simple way to monitor the free space of my databases? I can allways monitor the size of my autoextend database, if it grows to big I need to create more files. There must be some way to monitor this with mysql commands, I haven't find any. If I do a show table status now it does only show the free size in my current file, not the size it would have if it had grown to it maximum size. /Lars On Fri, 18 Oct 2002, Lars Andersson wrote: > I have a question about innodb, some of my users get an error code 1114 > saying that a table on an innodb database is full. > > When I do a show table status i get the following size comments (all > tables display one or another of these two). > Comment: InnoDB free: 5849088 kB; InnoDB free: 3072 kB > Comment: InnoDB free: 3072 kB > > How come it says InnoDB free: 3072 kB when I seem to have 5849088 kB > free? And why does the other comment say something diffrent? I use two > 2gb innodb data files. > > If I make another database file will it solve the problem? > > Can I use the autoextend option under MySQL-Max-3.23.53a? > > > - lars > > > > --------------------------------------------------------------------- > 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