Hi alejandror,
Thanks for your reply - Sorry for the late response on this as i was flying and i did not have good connectivity to check the status.
Currently i have 21 Active plugins - i optimized it. Some of the ones that i have is listed below :-
Booking Calendar,CMS2CMS Connector,Contact Form 7,Elementor,Featured Images in RSS for Mailchimp & Other Email,
Instagram Slider Widget,Mailchimp for WordPress,oAuth Twitter Feed for Developers,Penci Portfolio,Penci Recipe,
Penci Review,Penci Shortcodes,Penci Slider,Penci Soledad Demo Importer,Popup Builder,rewardStyle Widget,
Smush,Vafpress Post Formats UI,WordPress Users & WooCommerce Customers Import Export(BASIC,
WP Mail SMTP,Yoast SEO
Also, I suspect this could also be caused by the load balancers' health check mechanism, as would be continuously polling the WordPress site, and creating new sessions and/or transient data, which would be indeed recorded in the wpoptions table of the database. You can check the number of transient fields with some DB queries like:_
Copy
SELECT count(*) FROM wpoptions WHERE option_name LIKE '%transient%';_
- I looked into this and i didnt see tthat the space was that large - but i may be reading the data wrong.
- Database changed
- mysql> SELECT count(*) FROM wp_options WHERE option_name LIKE '%transient%';
- +----------+
- | count(*) |
- +----------+
- | 17 |
- +----------+
- 1 row in set (0.01 sec)
the only way i could get the space back again - was to again run the following command :-
PURGE BINARY LOGS BEFORE NOW() - INTERVAL 8 HOUR
I ended up gaining almost 250GB!!
which seems odd - I agree with you that the load balancer is probably the problem since i added it, the rate of space consumption has been very high!
I am going to work to set the expire_logs_days, so that the log rotation is consistent.