How to optimize wp_option table?

Question

My WordPress website is often going down with the error message “error establishing a database connection” and when I contacted my hosting server, they replied that the query takes a long time(more than 25 sec) and killed the database connection. So that they asked to optimize the wp_option table. Kindly guide me to optimize wp_option table and improve the site performance.

    Killed queries for the database(s):-
----------------------------
vn_wp3

Also, the following error message regarding the database(s):-

------
2018-04-18 12:34:01 +0000 [info] killed_thread_id:30117883 user:vn_wp3 host:localhost db:vn_wp3 command:Query time:25 query:SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_srcmnt_notices' LIMIT 1
2018-04-18 12:34:11 +0000 [info] killed_thread_id:30118047 user:vn_wp3 host:localhost db:vn_wp3 command:Query time:25 query:SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_srcmnt_notices' LIMIT 1
------
------

I checked the wp_option table size, it’s around 21 MB.

--------------------------------------------------

>>> Share a link to this question, just copy and paste the code bellow on your web page <<<

<a href="https://www.wptricks.com/question/how-to-optimize-wp_option-table/">

How to optimize wp_option table?</a>
0
, Bruce Lee 2 months 0 Answers 58 views 0

Leave an answer