On Tuesday 21 May 2002 12:24 am, Jeremy Zawodny wrote: > On Mon, May 20, 2002 at 12:25:26PM -0400, walt wrote: > > Does anyone know where rollbacks are stored for innodb tables? I > > assume memory since I keep getting a table full error when trying to > > drop an index. sql,query > > I'm not exactly sure what you're asking, but the rollback information > needs to be stored on disk. Otherwise it cannot recover form a crash. > > Anyway, I suspect that your problem is that your tablespace is full. > Can you try added another file and see if that makes the problem go > away? > > Jeremy
Thanks for your reply Jeremy! I'm an Oracle person, so I tend to think of things being in multiple files/tablespaces. Do you know if there is a way to view the rollback stats? I've got 6GB of datafiles and only 1 table loaded with 46 rows, 14 indexes, and approx 1.6million records. I'm trying now to load all the data again in a seperate table to see what it takes to fill up the datafiles. Thanks again! -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 "If it's not broke....tweak it" --------------------------------------------------------------------- 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
