Question 107194 in Wordpress Question posted in
The official Wordpress documentation can be found here.

WordPress – The database has been overloading due to a plugin which I am not able to identify which caused my account to be suspended with a huge postmeta

The system suspending your hosting due to:
The u621963338_jyqqx database is overloading the MySQL server with queries like
SELECT COUNT(P.ID)ntttFROM wp_posts AS PntttWHERE P.post_type IN ('post', 'page', 'attachment', 'e-l

The only error I could find.

The postmeta is huge in size with consuming over 2.8gb.

Tags:

2

Answers


  1. 0

    You could try to clean unnecessary post metadata with this kind of query :

    SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;
DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;

    Don’t forget to do a backup before running it. Does it help ?

    Login or Signup to reply.
  2. 0

    Post meta is used by most plugins out there. Mostly SEO plugins or forum plugins like bbpress etc could store large meta. ACF plugin also stores custom fields in metadata, so you have to check if you are storing very large custom fields data in database? It could be due to lots of things, pin-pointing which without access to the system is very difficult. Best would be to recreate similar environment on local server and debug.

    One plugin that can help you is the Query monitor plugin. It can help you monitor and debug DB queries, and also shows DB calls plugin wise which will help you pin-point the problem.

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search