Log Size

已查看 1 次
跳至第一个未读帖子

Trent Adams

未读,
2008年1月20日 00:10:442008/1/20
收件人 habari-dev
I was just looking in my server admin and noticed that my Habari
install database was getting massive which caught my attention as it
only has 8 posts, 0 comments and 0 spam :) After looking at the
database, it seems that with just under a 1000 entries in the log, it
was taking up 50 megs of database space! While the log was primary
with errors from a theme I was using, that is not Habari's fault!

I was thinking that having a limit on the size of the log or a warning
message if it gets up to say "x megs" might be a nice feature.

Thoughts?

Trent

Robin Adrianse

未读,
2008年1月20日 00:36:572008/1/20
收件人 habar...@googlegroups.com
Removing old log entries as new ones get added seems like a good option to have. I can't say log messages from 2 months ago would be that useful.

Scott Merrill

未读,
2008年1月20日 11:22:492008/1/20
收件人 habar...@googlegroups.com
On 1/20/08, Robin Adrianse <robi...@gmail.com> wrote:
> Removing old log entries as new ones get added seems like a good option to
> have. I can't say log messages from 2 months ago would be that useful.

We do have a cron system. It ought not be too hard to construct a
cron job to expire old log entries.

Stanley FONG

未读,
2008年1月21日 02:24:522008/1/21
收件人 habar...@googlegroups.com
I would suggest that this is included in the core then user just enter number of days, in the option page of dashboard, that log should be kept in the database.

Robin Adrianse

未读,
2008年1月21日 02:28:312008/1/21
收件人 habar...@googlegroups.com
Yeah, it makes sense to me as a built-in option. After all, logs can quickly build up.

Christian Mohn (h0bbel)

未读,
2008年1月22日 06:10:202008/1/22
收件人 habari-dev
Yes, they can. Mine is 2.1GB right now.

On Jan 21, 8:28 am, "Robin Adrianse" <robin....@gmail.com> wrote:
> Yeah, it makes sense to me as a built-in option. After all, logs can quickly
> build up.
>
> On Jan 20, 2008 11:24 PM, Stanley FONG <sfon...@gmail.com> wrote:> I would suggest that this is included in the core then user just enter
> > number of days, in the option page of dashboard, that log should be kept in
> > the database.
>
> > On Jan 21, 2008 12:22 AM, Scott Merrill <ski...@skippy.net> wrote:
>

Trent Adams

未读,
2008年1月22日 09:46:192008/1/22
收件人 habari-dev
I was a little startled with a simple 50 meg log file. 2.1GB....
wow!

On Jan 22, 4:10 am, "Christian Mohn (h0bbel)" <h0b...@gmail.com>
wrote:

Matthias Bauer

未读,
2008年1月22日 10:25:462008/1/22
收件人 habar...@googlegroups.com
Trent Adams wrote:

The latest SVN revision adds a cronjob to truncate the log file size
every day, keeping only the logs of the last 13 days. This is not
configurable and it's only a short term fix anyway, but I figure it's
better than having a log table exhaust your memory.

Users of the 0.3.3 release might want to TRUNCATE TABLE habari__logs;
OPTIMIZE TABLE habari__logs; for now.

-Matt

Christian Mohn

未读,
2008年1月22日 15:53:482008/1/22
收件人 habar...@googlegroups.com
Yeah. I win! ;-)

Robin Adrianse

未读,
2008年1月23日 10:48:392008/1/23
收件人 habar...@googlegroups.com
Insane... here I was, thinking about 500 MB at the most... well, I guess that just proves the point even more ;).
回复全部
回复作者
转发
0 个新帖子