Changes between Version 41 and Version 42 of Czartool

Timestamp:

Nov 26, 2010, 12:32:07 PM (16 years ago)

Author:

rhenders

Comment:

--

Czartool

@@ -81 +81 @@
 
 Czartool is written in Object Perl using a MySQL database. The code currently lives in {{{trunk/tools}}}. Classes are in {{{czartool}}} folder, and scripts (like {{{czarplot}}}).
+
+=== Database maintenance ===
+
+To curb the growth of the database, each night at midnight, {{{czarpoll}}} goes back to the previous day and trims the contents of all tables. For the current day, 'readings' are taken by {{{czarpoll}}} every few minutes. After trimming, there exists one reading per 30 minutes in all tables (this is configurable, and may need to be reduced to hourly at some point).
+
+All database tables are also optimized at this time, since heavy deletion like that described above can cause fragmentation and, consequently, performance issues.