Changing tmpdir causes InnoDB to break
Hi All
I have been having some issues with my installation of MySql (server version 5.0.67 running on Ubuntu).
I have some databases where one table is ~1.5Gb in size and this has been causing me no end of problems, with kernel "Out of memory" errors occuring.
I recently realised that by increasing the swap space to about 3X the size of the maximum table I was getting rid of some of these problems on a slightly smaller database. Now I have a MySQL problem rather than a kernel one!
Trying to run my rather large select and sort query on the huge table tells me I have an Error 3 unable to write /tmp/.... My research suggested that this could be fixed by editing the my.cnf file so that tmpdir points to a much larger space. I tried this, restarted the server and found that all the InnoDB tables broke, I got an error: ERROR 1033 (HY000): Incorrect information in file.
I can fix this by putting the tmpdir back to /tmp but it doesn't help me as there isn't enough spce in /tmp! How can I increase this without breaking the InnoDB tables?
Furthermore, I've noticed that my ibdata1 is ~23GB in size, is this normal?! I have no ibdata2 and the ib_logfiles are both 5120KB in size.
My my.cnf contains the following:
[client]
port
Subject
Written By
Posted
Changing tmpdir causes InnoDB to break
November 05, 2009 10:16AM
November 05, 2009 10:26AM
November 06, 2009 09:15PM
November 06, 2009 09:19PM
November 09, 2009 04:28AM
November 09, 2009 04:52AM
November 09, 2009 09:07AM
November 11, 2009 03:19AM
November 11, 2009 03:37AM
November 11, 2009 08:59PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.