Title: db error  cannot optimize database
Last modified: August 22, 2016

---

# db error cannot optimize database

 *  Resolved [conservativeread](https://wordpress.org/support/users/conservativeread/)
 * (@conservativeread)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/db-error-cannot-optimize-database-1/)
 * error db wp_links.TMM’ getting this error, in wp term taxonomy and wp links, 
   I get this error when trying to optimize data base using phpmyadmin latest MySQL/
   mariadb anyone have any clues it repairs ok but when I go to optimize after repairing
   it says it cant. this isn’t a problem with your plugin, though that is how I 
   found this error this is a db issue please point me in the right direction or
   forward to proper place.
 * [https://wordpress.org/plugins/rvg-optimize-database/](https://wordpress.org/plugins/rvg-optimize-database/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/db-error-cannot-optimize-database-1/#post-5837959)
 * Hey,
 * Maybe this is a useful link for you:
    [http://bugs.mysql.com/bug.php?id=54828](http://bugs.mysql.com/bug.php?id=54828)
 * It looks like it has something to do with the write permission for the temporary
   files (*.TMM). Or maybe these files are read-only or locked.
    I suggest: find
   those .TMM files (wp_links.TMM and the taxonomy temp file) and manually delete
   or rename them and then try again.
 * Good luck!
    Rolf
 *  Thread Starter [conservativeread](https://wordpress.org/support/users/conservativeread/)
 * (@conservativeread)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/db-error-cannot-optimize-database-1/#post-5837999)
 * thank you will try and respond back here. I forgot to mention this started when
   I moved from plain mysql to mysql/mariadb however I have had database issues 
   for some time…

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘db error cannot optimize database’ is closed to new replies.

 * ![](https://ps.w.org/rvg-optimize-database/assets/icon-256x256.png?rev=3350597)
 * [Optimize Database after Deleting Revisions](https://wordpress.org/plugins/rvg-optimize-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/rvg-optimize-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/rvg-optimize-database/)
 * [Active Topics](https://wordpress.org/support/plugin/rvg-optimize-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/rvg-optimize-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/rvg-optimize-database/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * 2 replies
 * 2 participants
 * Last reply from: [conservativeread](https://wordpress.org/support/users/conservativeread/)
 * Last activity: [11 years, 2 months ago](https://wordpress.org/support/topic/db-error-cannot-optimize-database-1/#post-5837999)
 * Status: resolved