Help Center

Common questions and support documentation

We're
by
All CollectionsTroubleshootingRealtime query recorder table is big in size

WPTC will record all the SQL queries in realtime to the wptc_query_recorder table, during the realtime backups and 6 hour backups.

This wptc_query_recorder table contents will get cleared after every successful backups.
But sometimes this table will become big in size due to large number of unwanted SQL queries especially when one of the DB tables of the WordPress site is being updated more frequently like more than 50 times within a minute.
In most of the cases this is caused by other backup plugins, query monitor plugins, or activity log tracking plugins.

How to delete the wptc_query_recorder table?
Kindly stop the backup and then restart the backup manually from the WPTC plugin settings page, which will clear the wptc_query_recorder table.
If the above method fails, then you can delete the contents of the wptc_query_recorder table via PHPmyAdmin.

How to prevent the wptc_query_recorder table from becoming big?
You should find out the table/tables which contains a lot of unwanted data, which might not be required to be backed up, and exclude its contents on the WPTimeCapsule plugin settings page.
Examples of such tables are the log tables, activity data tables, cache tables, etc.

Kindly contact us, if you are not sure which table to exclude. We will get in touch immediately.


Still need help? Contact Us
Did this answer your question?