tc_server_performance MySQL table is too large

To decrease the size of the tc_server_performance MySQL table:

1) System Settings >> Plugins >> System Monitor

Change the auto purge variable from -1. The default -1 means TCAdmin will never delete any information from this table.

2) Make sure you have MySQL GUI Administration Tools installed. The next day after changing the number of days to store, log in to mysql administrator. Right click on the table and select Maintenance > Optimize. This will reduce the table size.

  • 171 Users Found This Useful
Was this answer helpful?

Related Articles

How to convert your database from Microsoft Access to MySQL

- Install MySQL Server from http://dev.mysql.com/downloads/ and MySQL GUI Tools from...

Getting faster page loads with a MySQL server

1) Use the ODBC drivers instead of .NET drivers. 2) Use the MySQL GUI Tools and go to Startup...