elsandkls
Forum Replies Created
-
I’ve decided to rebuild the database and site and see if I can fix it myself. Thank you for the offer. I was just checking to see if anyone had suggestions that might clue me into what I’ve missed. I have several other sites on that server, that run fine until mysql crashes because of this site. I’ll sort it. Thank you!
Also “truncate command will cause a foreign key constraint violation” I checked there aren’t any on any of the tables the truncate command is being run on .
Based on your suggestion, To test the privileges I gave that account all privileges. It’s still crashing MySQL when I run truncate both manually and through WordPress. It’s a dedicated box, running Ubuntu. I believe the issue was occurring a few months ago but I hadn’t noticed. I upgraded to the most recent version of MySQL and PHP about two or three months ago to fix some other issues. I checked all of the tables in that database to see if they need to be repaired. I only posted the results of wfhits above but I actually checked all the tables. It’s a dedicated box, the host provides the IP and the hardware. I’m responsible for the software and os. Anything else I can check. If not I’ll start rebuilding it. I have 8 sites on that server all running WordPress, and this is the only one that seems to be having this issue. The others are running smooth. They are even smaller sites though, so if it’s related to file size of the database at all, they are much smaller.