f022y
Forum Replies Created
-
Me too after last update!
On CPanel and phpMyAdmin I can monitor some other interesting issue. The number of ‘aborted clients’ increase during the plugin fetching items. The number of connections that were aborted because the client died without closing the connection properly till the DB restart with a timeout about 5 to 10 min and everything starts again.
Of course I’ve deactivated all other plugins! Seems to be a RSS Multi Importer issue.
Forum: Plugins
In reply to: [WP RSS Multi Importer] CPU usage up to 100% when feed is feching@battlemas
Yes, sometimes I get duplicate posts too! I guess at the time the AutoPost looks for new feed items and the DB wasn’t actualized because of busy connection.Will start a new threat as I think this isn’t a CPU problem even more an overload of the MySQL DB.
https://www.ads-software.com/support/topic/%E2%80%98error-establishing-a-database-connection%E2%80%99-because-of-db-overloadForum: Plugins
In reply to: [WP RSS Multi Importer] CPU usage up to 100% when feed is fechingSame problem here I’m overloading several times a day the MySql DB when fetching feeds into wp_posts table and to the heavy load closed the connection to my DB with ‘Error establishing a database connection’.
I’m using the plugin since beginning of the year just for posting news, till now about 4,000 post published and the problem started since 3.0 and the new DB feature. I’m only pulling 20 feeds, but about 400 feed items every day from whom I filter thru category filter only 20 to my news page. As I can see feed items and posts are located in the same DB wp_post table. The problem so far is not the import of the items of each feed into the DB. I guess because of the volume in my wp_post table (10,809 records with 16MB size) the AutoPost feature needs to long time to search the whole wp_post table for new entries and filter to publish them finally. BTW I have enabled the option to delete all feeds older 1 day and bring in only feeds not older than 1 day.
Would be great if WP RSS Multi Importer would fetch the feeds into a different wp_table and the AutoPost later into the wp_post table, as there is no plugin or solution available to archive older post in a different table as wp_post. Won’t like to delete older post as Google and Co. finding them still and brings me a lot of visitors to my page https://www.tzukan.com/.