Symptoms: Large wordpress database may have corrupt tables. Every few days or so, the site hangs and has extremely long load times with 'unable to connect to database' on wordpress, and '1040 too many connections' on phpmyadmin. Raising max_connections and turning off persistent connections does not solve this issue. Most likely corrupt database. Repair datatabse does not work.
Task: Pinpoint and fix this problem by cleaning, organizing, optimizing the MySQL database, and deleting all plugin databases for inactive plugins. Backup your work.
Error log in mysql these various errors:
[ERROR] Got error 127 when reading table './database/wp_options'
[ERROR] Got error 126 when reading table './database/wp_options'
[ERROR] /usr/sbin/mysqld: Sort aborted
[ERROR] /usr/sbin/mysqld: Got error 127 from storage engine
And many more.
14 freelancers are bidding on average $117 for this job
Having worked on sql databases such as the backend for [url removed, login to view] i can provide you with the solution as soon as you can provide database connection credentials.
Hi, Our team has solved these kind of database errors, we are very familiar with that, i have mentioned 3 days for this, based on the environmet of your project we will decide the duration...........
Hello Sir, I can fix this issue within 1 day for just 30$ because I have a lot of experience in dealing with this type of issues. I am web hosting support engineer by profession. Thanks Mabin