Hello
I have a client with a 1 gb MySQL DB and in the midst of running a repair on her database, the page just went blank (white) and the /tmp partition filled up, grinding a couple of other sites on server to a standstill.
Problem is, when it timed out, it was fixing a table on her database which is now locked saying "in use" and I'm not sure I want to run another "repair" on it for the fear of affecting other clients or further ruining this table/database.
Any guidance on how I can increase the size of the /tmp folder or what would be a potential fix.
FYI when I click on the table in question, I see this error
I have a client with a 1 gb MySQL DB and in the midst of running a repair on her database, the page just went blank (white) and the /tmp partition filled up, grinding a couple of other sites on server to a standstill.
Problem is, when it timed out, it was fixing a table on her database which is now locked saying "in use" and I'm not sure I want to run another "repair" on it for the fear of affecting other clients or further ruining this table/database.
Any guidance on how I can increase the size of the /tmp folder or what would be a potential fix.
FYI when I click on the table in question, I see this error
Will appreciate any help you can provide.#1016 - Can't open file: 'post.MYI' (errno: 144)