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.