Need Help With MYSQL InnoDB

Mark Phillips mark at phillipsmarketing.biz
Tue May 4 18:35:01 MST 2010


I have a very small mysql database that uses innodb tables. I just started
getting the following error when I try to access the tables:

ERROR 1033 (HY000): Incorrect information in file:
'./mailserver/virtual_users.frm'

I google the error and it seems to have something to do with either the
error logs being too large or the database being too large. When I 'show
VARIABLES' at the mysql prompt I found:

 innodb_data_file_path            ibdata1:10M:autoextend
 innodb_log_file_size               5242880
 innodb_log_files_in_group      2

I looked in /var/lib/mysql and found

li84-151:/home/mark# ls -al /var/lib/mysql
total 10276
drwxr-xr-x  4 mysql mysql     4096 2010-05-04 17:15 .
drwxr-xr-x 26 root  root      4096 2009-10-26 08:28 ..
-rw-r--r--  1 mysql mysql        0 2009-10-14 15:40 debian-5.0.flag
-rw-rw----  1 mysql mysql 10485760 2010-04-15 09:00 ibdata1
drwx------  2 mysql mysql     4096 2009-08-31 07:09 mailserver
drwxr-xr-x  2 mysql mysql     4096 2009-10-14 15:40 mysql
-rw-------  1 mysql mysql        7 2009-06-26 13:13 mysql_upgrade_info
-rw-rw----  1 mysql mysql   5242880 2010-04-15 09:00 ib_logfile0
-rw-rw----  1 mysql mysql   5242880 2009-07-12 09:25 ib_logfile1
Based on some reading on the mysql site (version 5.0 on Debian Lenny) I
removed the two ib_logfile and restarted mysql. I still get the same error.
Based on the mysql docs, I thought the autoextend for the
innodb_data_file_path would automatically take care of the data file growing
beyond the file size limit. Is this correct? Do I have to increase the size
of the innodb_data_file to make this error go away? How do I do that? Also,
these tables have not changed since they were created, so I am pondering how
the data file has grown. Any suggestions?

Thanks!

Mark
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20100504/12ea9b06/attachment.htm>


More information about the PLUG-discuss mailing list