WordPress 'wp_posts' high cpu usage

Support and Discussion Database Server
1

I have a problem with wp_posts table It’s getting too big so I decided to download an extension to clean the table but the CPU draw starts to reach 100%

i try:

mysql -u root -p -e 'show processlist'

3333333
33333331920×1080 369 KB

Does anyone have any idea how to solve it?

2

What plugin and what does it do?

3

Can you set up the query monitor plugin and give us the output? So basically we can see if there is any duplicate queries or heavy one.

4

try disable the plugin then recheck :slight_smile:
sometimes it coming from plugin and you should report to the developer

sometimes the themes can make highload
and some of “backend” tune

5

WP-Optimize – Cache, Clean, Compress.

it clean the meta and temp stuff that WordPress didn’t use anymore

i also disable all plugin, but CPU still very high and get to 100%

6

there is 9 duplicate queries, but I have no idea how to solve the problem

1
11588×685 145 KB

2
21562×653 109 KB

3
31566×663 139 KB

4
41560×653 124 KB

i use Jannah theme, It is a very large theme and I also have a lot of posts, Maybe i should upgrade my VPS hosting?

The hosting I am currently using by Vultr

5
51146×303 48.2 KB

7

i think its by the theme, i disable all the plugin and the amount of consumption has decreased a little, but the problem still exists…

thank you for replying & helping :smile:

8

thats is wordpress

try to enable wp optimize only if you need it…
and try to stop compress image all the time

i was faced problem just same like you then i realize, about plugin and themes glitch…
if you comfort with your current themes and plugin. then you should learn how to decrease the “query”

this cpu usage is just about plugin themes and too much background process. tuning is not always good if you dont know what you doing or just watch youtube :slight_smile:

9

the problem has been resolved after disabling some plugins for the theme and also activating the lscache plugin (I disabled all the add-ons before, as I said, but I had to wait for a while and delete the cache to see the changes)

also there is functions in theme setting help a lot

Untitled
Untitled832×904 106 KB

Thank you very much @MyIDKaTePe :heart:

1 Like
10

forgot to tell you this :smiley:
more strong your cache… more resources your VPS needed
just use this:

WP Cloudflare Super Page Cache – WordPress plugin | WordPress.org
then combine with your CF
enable minify both on the plugin and at your Cloudflare

install any database cleaner but do not run it with cron
after you optimize the database you should disable it.

then go to gtmetrix (if you use it as the metrix for your site… me? i dont trust gtmetrik lol) test it :slight_smile:
that is enough

glad can help you
i was in your position few months ago… but then i learn, why i must use cache if the cache have big impact to my website resources :slight_smile:
even i now use tagdiv newspaper… the most heavy themes in the world… i got “A” score :smiley:

1 Like
11

This topic was automatically closed 3 hours after the last reply. New replies are no longer allowed.