Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Collaboration Suite > Administrators

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-23-2009, 12:27 AM
Active Member
 
Posts: 45
Default [SOLVED] Reset the stats message count in administration

Is there a way to reset all stats in the Zimbra Admin Stats page?

I messed up the logger service last week and the number of receved message was X times more thatn normal.
I fixed the problem but now the graphs just shows the peak of 60k msg per hour :-P

Thx
AleX
Reply With Quote
  #2 (permalink)  
Old 02-23-2009, 01:07 AM
Moderator
 
Posts: 7,928
Default

Code:
su - zimbra
logmysql
use zimbra_logger;
show tables;
you could then delete the spurious entries from the tables.
__________________
Reply With Quote
  #3 (permalink)  
Old 02-23-2009, 02:25 AM
Active Member
 
Posts: 45
Smile

Quote:
Originally Posted by uxbod View Post
Code:
su - zimbra
logmysql
use zimbra_logger;
show tables;
you could then delete the spurious entries from the tables.
For further reference
I deleted the bad aggregated data from

delete from mta_aggregate where period_start <= '2009-02-21 00:00:00';

I then update the graph with
/opt/zimbra/libexec/zmgengraphs >> /tmp/gengraphs.out 2>&1

Thx
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com




 

SEO by vBSEO ©2011, Crawlability, Inc.