Contact Lifestream



MySQL situation

Excessive Nucleus plugins kill. Top ten database tables by size.

nucleus_plugin_referrer_cache			6.2 MB
nucleus_item					5.2 MB
videodata					2.9 MB
nucleus_plugin_referrer				1.7 MB
nucleus_plugin_querylog				1.4 MB
cpg11d_exif					1.2 MB

nucleus_comment					713 KB
nucleus_plug_seo				418 KB
cpg11d_pictures					243 KB
amipsql						172 KB

The “amipsql” table is obviously the data being uploaded from Winamp. The total database in over 20 MB now. Half of that being plugins. Referrer and Querylog are nice but are they essential? Hardly. They can of course be set to TRUNCATE from time to time. Just as I do with AMIP. I should get on that right away …
And as for EXIF data in Coppermine. Fancy. But out of the few people who visit the Gallery how many really care about EXIF? Something has got to go. It just feels wrong to waste resources somehow. Actually, the big problem is still the VideoDB as it also taxes the bandwidth heavily.