I currently have 2,453,623 items in the stream records. I cannot delete these using the ‘Reset Stream Database’ option in the Advanced tab as the request is timing out. Is there a manual way to delete these records safely in the DB?
We’re trying to perform database optimisation, we’re seen the Stream database is taking up a lot of space :
wp_stream_meta 1347.50 (MB)
We’ve tried to optimise this by adjusting the days of records kept from 30 days to 5 days and the database size remains the same.
We’ve confirmed the wp_stream_auto_purge is running and not getting killed.
We’ve also attempted to reset the Stream database via Advanced tools in the plugin and it does not work, the page reloads but all the records prior to the action remain in the DB.
There seems to be a problem with the plugin – please advise.
Site Info:
WP: V6.2.2
php: 8.0.29
mysql: 5.7.42-46-log
Bug Report
https://wordpress.org/support/topic/how-to-manually-delete-records/ https://wordpress.org/support/topic/database-bloat-unable-to-archive-records/
Expected Behavior
Records should be deleted when 'Reset Stream Database' is clicked. Records older than the saved records time should be deleted.
Actual Behavior
from https://wordpress.org/support/topic/how-to-manually-delete-records/
from https://wordpress.org/support/topic/database-bloat-unable-to-archive-records/