slservice33
Forum Replies Created
-
Much appreciated. I’ll look into this, see if I can track it down.
There is 2 sites on my server one is always slow and one is always fast and the last site to receive an update is always the fast one !
Forum: Everything else WordPress
In reply to: 2 wordpress sites on 1 server issueThanks. According to ‘top’ there is only ever one mariadb process running.
Site health looks good.
Nothing in syslog or PHP error log but I might try enabling mariadb slow log.
I’ve asked a question on Query Monitor Plugin to see how the number of Database Queries can stay the same but the Peak Memory Use is 100mb higher for the same page load ? That might lead somewhere …
Forum: Everything else WordPress
In reply to: 2 wordpress sites on 1 server issueHi, its my own apache server that serves only these 2 wordpress sites.
The issue immediately switches between the 2 sites after updates, and only effects wp-admin pages with everything else working well.
So I thought maybe an issue when the admin pages connect to external sites ?
Forum: Plugins
In reply to: [WooCommerce] Increase in Woocommerce Database Queriessorry please ignore that those queries are due to different settings. My woocommerce plugin queries are not high any more.
My current slow page load and high peak memory use are coming from something else. I’ll have to try other avenues.
Forum: Plugins
In reply to: [WooCommerce] Increase in Woocommerce Database Queriessadly it worked really well for a few hours now its back to slow admin pages with lots of extra queries.
(The additonal queries below are recorded with redis object caching, without redis there is hundreds)
Additional queries recorded by query monitor loading the woocommerce orders overview page:
caller – Automattic\W\A\N\DataStore->read()
normally 2 queries
when slow 11 queriescaller – Automattic\W\A\N\DataStore->read_actions()
normally 2 queries
when slow 11 queriescaller – Automattic\W\I\D\O\OrdersTableDataStore->get_order_data_for_ids()
normally 40 queries
when slow 100 queriesAny ideas what might cause those callers to make the extra queries ?
Forum: Plugins
In reply to: [WooCommerce] Increase in Woocommerce Database QueriesAlso I should note that my leaving the query monitor plugin running constantly also placed even more load on my already struggling server.
Forum: Plugins
In reply to: [WooCommerce] Increase in Woocommerce Database Queriesi have installed both fast woo order lookup and index wp mysql for speed plugins and wow what an immediate improvement.
The number of queries is back to normal and I cant remember my woocommerce admin pages ever being so fast for loading and also fast for searching.
Thanks for you help, my server CPU is working much less hard !
Forum: Plugins
In reply to: [WooCommerce] Increase in Woocommerce Database QueriesInteresting, though it is extra woocommerce plugin queries on every admin page all the time.
I’ve actually not yet tried https://wordpress.org/plugins/fast-woo-order-lookup/ or https://wordpress.org/plugins/index-wp-mysql-for-speed/
I will try some more things and see if I get any improvements.
Forum: Plugins
In reply to: [WooCommerce] Increase in Woocommerce Database QueriesI’ve already tried all the things above.
The database queries are logged by the query monitor plugin which is I believe is reliable and accurate.
And with such sudden and significant changes in the number of queries logged by query monitor as coming from the woocommerce plugin I am not mistaken in finding this issue.
This problem significantly affects the performance of my server when I am working on wp-admin pages. (I would estimate around twice as many queries with twice the cpu load per page)
You dont seem to have any realistic ideas as to the cause and I will keep monitoring it to see if I can spot what all the extra queries are related to. Though as there are hundreds of queries its not easy.
Maybe you can suggest something to look out for in these extra queries that could indicate what is causing them ?
Forum: Plugins
In reply to: [Reviews and Rating – Google Reviews] wp-options table entriesThanks for your reply.
The wp-options data can really accumulate over time.
I’m trouble shooting why my wp-admin pages are sometimes much bigger and slower to load but I dont think this is the cause.
Forum: Plugins
In reply to: [AAA Option Optimizer] AutoLoad SignificanceThank you very much, very useful plugin. I will unload all the unused ones.
Just need to work out why my apache processes are so huge now !
Forum: Plugins
In reply to: [WP Fastest Cache] apache2 process size 300mbThanks.
I appreciate your plugin and its simple no nonsense interface.
Forum: Plugins
In reply to: [Error Log Monitor] Newest errors firstWow, I’ve been using this for years and never found the configure menu.
Thanks for your help !
Forum: Plugins
In reply to: [WooCommerce] Update causes fatal PHP errorThanks I’ll look into that.
Had me a stressful couple of hours working out how to start my server in a way that the update would not immediately break it !
Forum: Plugins
In reply to: [WooCommerce] Update causes fatal PHP errorThe woocommerce update which started the fatal error is now not available on my site so I cant try the fix.
Hopefully the next update will go better ..
