SQL error

[Todd Holley]

My database is over 1gb now and I think that is the cause of this error. Never the less I need this fixed.

 

StandardPlugins.Database.ManagerMySQLNet.New: Connection must be opened. SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC3445566018732584068441', '2007-09-08 20:31:04', '0')

 

Thanks!

[adamnp]

1gb database? holy ba-jesus.!!! clear that thing!! hehe, most likely your 'logs' for the server info is being stored for way to long, decrease the time it is being stored and should reduce your sql length. As far as the error, where are you getting that error?

What are you trying to do? does the rest of the system work?

[ECF]

That is exactly the reason. If you are collecting every single stat availible it will grow very quickly.

 

Set you system collector to a max of 7 days and let it run. That will purge any data over that age.