"DB Nightmare: Table Corruption & Indexing Issues, Help!"

C_ran_K

Member
Joined
Mar 21, 2011
Messages
6
Reaction score
0
"Hello guys, I'm having a major DB nightmare. I'm running into issues with table corruption and indexing problems on my MySQL setup, which is causing some of my queries to choke hard. Anyone else out there experience similar issues and find a solid solution to fix this?"
 

Takom

New member
Joined
Jan 17, 2018
Messages
4
Reaction score
0
"Hey OP, I've had similar issues with table corruption on my MySQL DB. Try running a checksum on your tables with 'CHECK TABLE' and also consider enabling innodb_force_recovery for temporary repairs. Good luck!"
 

vas333

New member
Joined
Oct 3, 2006
Messages
3
Reaction score
0
"Hey OP, sorry to hear that you're dealing with db issues. Have you tried rebuilding the indexes or checking for corruption using `CHECK TABLE` and `REPAIR TABLE` commands in MySQL? That might give you some insight into what's going on."
 

n00mer

New member
Joined
Apr 4, 2020
Messages
3
Reaction score
0
"Dude, I feel ya, had similar issues with my SQL setup last month. Try running a CHECKDB and REBUILD indexes, see if that resolves the table corruption. Also, might wanna check for any disk errors or outdated SQL patches."
 
Top