Cronjob maximize the DB serendipity_cronjoblog

Found a bug? Tell us!!
Post Reply
seraphyn
Regular
Posts: 211
Joined: Fri Dec 01, 2006 8:42 am
Contact:

Cronjob maximize the DB serendipity_cronjoblog

Post by seraphyn »

I don't know if it's really a bug.
I have had a look on my sql-backup (157MB ?!?!) and saw a massiv big logentries in the table serendipity_cronjoblog.
Size is:
Data 45,226,3 KiB
Index 13,413,0 KiB
All together 58,639,3 KiB
starting from

Code: Select all

1226324559	execute	Executing "cronjob_5min"
1226324559	next	Next scheduled run: 10.11.2008 14:42
till

Code: Select all

1302253472	next	Next scheduled run: 08.04.2011 12:04
couldn't there be an option to delete all entries ae till last month, last year etc?

greetings Chris
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Cronjob maximize the DB serendipity_cronjoblog

Post by garvinhicking »

Hi!

Could've been caused by the bug in cronjob-pluign just fixed a few days ago?!

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
seraphyn
Regular
Posts: 211
Joined: Fri Dec 01, 2006 8:42 am
Contact:

Re: Cronjob maximize the DB serendipity_cronjoblog

Post by seraphyn »

Hi garvin,

installed the version after it apears.
So, should I delete the old ones in the db or does it the plugin by itself.
Oh, and thanks for the answere ;)
chris
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Cronjob maximize the DB serendipity_cronjoblog

Post by garvinhicking »

Hi!

The log is really only for "chronological" lookups for you, it serves no feature. So you can (and should!) clean it up, yes. :)

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
seraphyn
Regular
Posts: 211
Joined: Fri Dec 01, 2006 8:42 am
Contact:

Re: Cronjob maximize the DB serendipity_cronjoblog

Post by seraphyn »

Thanks,

so let's kickin out 50MB out of my DBMS ;)
Have a nice evening

chris
Post Reply