Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › Slow Log shows Plugin problems
This topic contains 3 replies, has 2 voices, and was last updated by Ernest Marcinko 2 years, 10 months ago.
- AuthorPosts
- July 16, 2020 at 11:59 pm #28531
We’ve just learned that the Search Pro plugins is responsible for a lot of load requests and slowing down our site. This is from the Flywheel hosting support….
“I’ve dug into the site’s Slow Log, where we track when individual requests take longer than 5+ seconds to complete loading, I do see that the “/plugins/pdf-print-pro” is spewing a loooot of entries. This means that this plugin is a likely culprit which contributes to ongoing site slowness since it has over 230 unique instance of it directly causing over 5 seconds of delay when loading a page. For the Print PDF Pro plugin, we’re seeing references to the following function: file_get_contents() /www/wp-content/plugins/pdf-print-pro/mpdf/mpdf.php:11810 This basically says “I took a while to retrieve the contents of a remote file”. Since your site is in a Cloud environment, any sort of “file” based PHP function is going to take longer, which is why file-based functions are not recommended for Cloud environments, so the slowness here is a known issue that the plugin developer should avoid for cloud-based clients where possible.”
What can you tell us about this issue? Can you help with this?
July 17, 2020 at 8:13 am #28533Hi,
The flywheel support is referring to
Best,plugins/pdf-print-pro
directory and a file in there, which is not this plugin. From the directory name and a google search I got this plugin name: PDF & Print Pro by BestWebSoft
Please contact their support with this issue.
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
July 17, 2020 at 3:51 pm #28547Oh my gosh – this is what happens when you become sleep deprived. I’m so sorry. The message we received from Flywheel regarding your plugin is this part of the report:
As for other slowness, we’re seeing about equal amounts of slow intstances stemming from “ajax-search-pro” plugin. This is likely the direct culprit behind the server-wide slowness since this plugin is hitting your database quite hard and fast, resulting in your database being strained immensely, often resulting in it maxing out the database and leaving it exhausted. This is bad because it means that ANY interaction to the database, whether that be someone searching, or someone making adjustments to the WordPress Admin Dashboard. This sort of slowness can be seen here:
https://i.getf.ly/lluJpbp1
and here
https://i.getf.ly/bLujP290I’m so sorry for the confusion. I’ll reach out to them with the other text I originally sent to you.. It was a very long hard day – my apologies.
July 18, 2020 at 9:24 am #28554No problem 🙂 That makes sense now. I recommend checking the Fine tuning the search configuration guide. Especially the suggestions in chapter 1, as well as the index table engine. I believe Tthe index table engine in your case will make a huge difference – at it uses much faster, more optimized queries.
Best,
There is also a possibility to use a file/database cache – this can be useful for common repetitive queries.
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
- AuthorPosts
You must be logged in to reply to this topic.