hi could anybody give me a hint what a "table is full"-error on an InnoDB-Table means? I had converted some MyISAM-Tables (about 300.000 rows each, 10-23 columns of different integer-types, 3-6 indexes) on a test-system because i hoped for better performance since i have lots of updates and reads (200-300 queries/second) and InnoDB supports row level locking... But after everything having worked fine for 2 days i suddenly got "table full" errors on every simple INSERT or UPDATE on these Tables. There was no diskspace- or RAM-Problem. I had to switch the tables back to MyISAM to be able to continue the development of my webapplication, but i might be able to switch it back to InnoDB for more testing on this weird thing after my application is online on some other production-system. I just wondered if this is a know problem with innodb under heavy load with large tables and if there's anything i should look for. If this is a unknown problem, i might be able to report some useful debug-data in 1 or 2 weeks.
Thanks Richard -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net --------------------------------------------------------------------- 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
