Title: MySQL database high usage
Last modified: October 16, 2025

---

# MySQL database high usage

 *  Resolved [jimon07](https://wordpress.org/support/users/jimon07/)
 * (@jimon07)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/mysql-database-high-usage/)
 * From time to time i find that my Db shows very high usage and the query responsible
   is the one bellow which will run for many minutes:
   SELECT meta_value FROM wp_trp_dictionary_el_en_gbCan
   you please help me find what is the issue and what is causing this?

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

 *  Thread Starter [jimon07](https://wordpress.org/support/users/jimon07/)
 * (@jimon07)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/mysql-database-high-usage/#post-18685197)
 * Hello, i would appreciate any resolution or help on that because it is creating
   a massive issue that brings the whose e-shop down. Any more information you need
   i can provide.
 *  Plugin Support [Alex](https://wordpress.org/support/users/alexcozmoslabs/)
 * (@alexcozmoslabs)
 * [7 months, 1 week ago](https://wordpress.org/support/topic/mysql-database-high-usage/#post-18688502)
 * Hi,
   Could you please check the size of this table?Also, try the [Optimize TranslatePress database tables](https://translatepress.com/docs/settings/advanced-settings/#optimizedatabase)
   tool from TP Settings –> Advanced tab –> Debug section. See if that helps.
 *  Thread Starter [jimon07](https://wordpress.org/support/users/jimon07/)
 * (@jimon07)
 * [7 months, 1 week ago](https://wordpress.org/support/topic/mysql-database-high-usage/#post-18690567)
 * Yes the size of this table is 176 MB. It has 985.000 rows. I have tried the Optimize
   option many times. The problem keeps on happening once in a while. 
   The main 
   issue here is that this table does not contain a column for meta_value. Only 
   original, translated, status, block_type and original_id.So how is this query
   supposed to find what it needs?
 *     ```wp-block-code
       SELECT meta_value FROM wp_trp_dictionary_el_en_gb LIMIT 0, 25
       ```
   
 * **MySQL said: **[](https://host.michalisntounetas.com:2031/pma/url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fserver-error-reference.html)`#
   1054 - Unknown column 'meta_value' in 'field list'`
   Could this be an old query
   forgotten in the translatepress plugin code somewhere? Or is meta_value some 
   kind of alias?Either way it is creating a big mess when this query is invoked.
 *  Plugin Support [Alex](https://wordpress.org/support/users/alexcozmoslabs/)
 * (@alexcozmoslabs)
 * [6 months, 3 weeks ago](https://wordpress.org/support/topic/mysql-database-high-usage/#post-18707745)
 * The `meta_value` column you’re seeing in that query is not part of the current
   TranslatePress table structure. It looks like an old query or leftover reference
   from a previous version, or possibly from a generic WP convention (WordPress 
   stores post meta in `meta_value`, but our `_trp_*` tables have a different structure).
 * In the current TranslatePress database, the dictionary tables contain only these
   columns: `original`, `translated`, `status`, `block_type`, and `original_id`.
   There is **no `meta_value` column**, so any query referencing it will fail.
 * This is not part of normal TranslatePress operations, and it may be coming from
   a custom script, outdated plugin code, or a leftover cache/tool trying to access
   translations in a WordPress-standard way. You can safely ignore queries that 
   reference `meta_value` in `_trp_*` tables, but if they are being triggered automatically,
   it’s worth checking for old code snippets or plugins that might be making these
   calls.

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

The topic ‘MySQL database high usage’ is closed to new replies.

 * ![](https://ps.w.org/translatepress-multilingual/assets/icon.svg?rev=3166541)
 * [TranslatePress - Translate Multilingual sites with AI Translation](https://wordpress.org/plugins/translatepress-multilingual/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/translatepress-multilingual/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/translatepress-multilingual/)
 * [Active Topics](https://wordpress.org/support/plugin/translatepress-multilingual/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/translatepress-multilingual/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/translatepress-multilingual/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [Alex](https://wordpress.org/support/users/alexcozmoslabs/)
 * Last activity: [6 months, 3 weeks ago](https://wordpress.org/support/topic/mysql-database-high-usage/#post-18707745)
 * Status: resolved