Profiling Zarafa Usage with Munin

I wanted to share with you the way Operator Groep Delft monitors and profiles Zarafa, the best Open Source Groupware available today. We have about a thousand users in LDAP, of which approximately 200 are internal employees (the ones in the branch offices) compared to approximately 800 external users (consultants, part-timers, etc.). We use Nagios for monitoring, and Munin for profiling. Munin integrates with Nagios in that given a set of thresholds, when a profiled resourse is out-of-bounds, it can let Nagios trigger the alerting.

Anyway, let's see some Munin graphs (who doesn't like colored graphs?):

The number of Connections to the Zarafa server

The number of connections to the Zarafa server is a simple `netstat | grep <process-name> | wc -l`. Some users will have more then one connection (Outlook users for example), and so the number of users (see below) is a different number. Also mind that, contrary to the Outlook and/or IMAP (persistent) connections, the webmail connections are polled once per 5 minutes, and thus the number of webmail (non-persistent) connections is probably off by a factor X. We chose to not choose X and instead derive statistics based on the actual numbers in the graph.

You can find our version of the zarafa_connections Munin plugin here.

The number of Unique Source IP addresses

Like I said, the number of actual users is something different then the amount of connections. Some users may have more then one connection so how do we derive the number of users from the number of connections? While Zarafa comes with a neat utility called zarafa-stats, it is not what we were looking for and so we chose to pick unique IP addresses for Outlook, IMAP and webmail users, and pick unique users for ActiveSync connections (also through the webserver, like webmail access, so we parse the webserver logs here). There's one more cheat in the number of webmail and ActiveSync connections I need to tell you about:

Instead of examining the webserver access_log files per hour, we take into account the hour before the current hour too. In a way, we examine the access_log files (of combined format by the way) in a range of 60 to 120 minutes. The reasoning is as follows; If we don't, at the start of every hour the number of users is zero. Then, as the hour passes, the number of users would increase and increase a little more until the hour passes and the next hour starts. This would have caused the graph to look like the teeth of a saw, which would misrepresent the number of users entirely.

You can find our version of the zarafa_users Munin plugin here.

The number of Queries per Second on the dedicated MySQL Database server

These users cause Zarafa to put some load on your database server, of course, and since we have a dedicated MySQL server just for Zarafa, the number of queries per second is interesting as well. This is a standard Munin plugin -or at least it's shipped in the version of Munin for Extra Packages for Enterprise Linux 5 as well as Fedora.

Note how the number of queries per second turns out to have > 50% cache hits at average (for the week). Over a longer period of time, I can tell you, the number of cache hits averages about 50% overall, and anywhere between about 30-40% during office hours.


CNAUKN nDZagI

CNAUKN nDZagI

An excellent training

An excellent training program, a healthy diet, and Sport Supplement can help you be in shape and stay in shape so you could constantly give a stand-out performance.
How to Use Supplements Effectively | Three Key Of Sports Supplements | Choosing Sports Supplements | Share your content

Share your content to the

Share your content to the world; let’s people easy to find you. Social Bookmarking make it easy for you. Submit your breaking news and let’s we do the rest. If you want an easier way, Submit RSS feed to Directory so the people can follow your update automatically.

We know, at this time ‘Social bookmarking’ is increasing popular besides search engine where we can find the latest update of news. Almost all kinds of information we can get from them such as Celebrity News, Sport, Business, etc; or a specific information like Cartoon World or Manga Update

For Used Stationary Bikes information, please visit the site was I founded.

by Christian Audigier, one of

by Christian Audigier, one of the hottest brands worn by celebrities and by the world. Stepping up the pace, he rolled out his eponymous street wear line, Christian Audigier, reflecting Christian抯 French-California
wholesale Nike Shox Shoes
Christian Audigier shirts
True Religion Jeans
wholesale Puma shoes
wholesale Coogi Jeans
wholesale Air Jordan Shoes
wholesale Tiffany Rings
wholesale Coach Bags
wholesale Gucci Shoes
Christian Audigier Jeans perspective and drawing inspiration from his everyday lifestyle influenced by rock & roll and glam on the streets of Los Angeles. Christian Audigier continues to dress the best of film, TV, sports and music. His

MukAGhJ SPCfyc

MukAGhJ SPCfyc

pQZRBIvQ RjImmQtO

pQZRBIvQ RjImmQtO

Christian Louboutin shoes

Christian Louboutin shoes new-style?
Welcome to our site,All Best Replica Chloe Handbags and fashion Chloe are here.
As its convenient and roomy design, Gucci Purses is very suitable for daily usage or for office using.
Stylish 2009 Famous Silver Tiffany & Co. Earrings 001 $36.99.
men's watches USA is an online store providing consumers with great prices for quality mens watches.
Cheap Replica Patek Philippe Watcheshere.
Philip Stein Watches at Watch Click.
The latest in Bottega Veneta Handbags, purses and accessories at the Purse Blog
UGG Classic Short Boots New Style.
Worldwide Free shipping,Cheap Nike Dunk SB Shoes.
Buy cheap polo Shirts,polo shirt,lacoste polo shirts,ralph lauren polo shirts,wholesale polo shirts.
Shop for Lacoste Womens Polos Shirts in Clothing.

xEaAWFCz IBZToPeW

xEaAWFCz IBZToPeW

fashion christian

fashion christian louboutin,all latest styles cheap Christian Louboutin on hot sale.

xieOOM HIBGvC

xieOOM HIBGvC

christianan louboutin shoes

WIvQBf WyjbMpSy

WIvQBf WyjbMpSy

LIFlkzXg UcbLABt

LIFlkzXg UcbLABt

pPCHNlF gLOdrAJS

pPCHNlF gLOdrAJS

Hello! ekfeeca interesting

Hello! ekfeeca interesting ekfeeca site!

kQjXKaZZ WWZQwXO

kQjXKaZZ WWZQwXO

Hello! viagra , viagra ,

Hello!
viagra , viagra , cialis , cialis , ,

Hello! viagra , viagra ,

Hello!
viagra , viagra , cialis , cialis , ,

Hello! viagra ,

Hello!
viagra ,

Hello! viagra ,

Hello!
viagra ,

Hello! viagra ,

Hello!
viagra ,

Hello! viagra ,

Hello!
viagra ,

Hello! viagra ,

Hello!
viagra ,

HAhTkk Phentermine Cheap

Hello! viagra , cialis ,

Hello!
viagra , cialis , viagra , viagra , cialis ,

Hello! viagra , viagra ,

Hello!
viagra , viagra , cialis , viagra , viagra ,

Hello! viagra ,

Hello!
viagra ,

Hello! cialis ,

Hello!
cialis ,

Hello! viagra ,

Hello!
viagra ,

Hello! viagra ,

Hello!
viagra ,

Hello! cialis ,

Hello!
cialis ,

Hello! cialis , viagra ,

Hello!
cialis , viagra , viagra , viagra , cialis ,

Hello! cialis ,

Hello!
cialis ,

Hello! viagra ,

Hello!
viagra ,

Hello! viagra ,

Hello!
viagra ,

Hello! viagra ,

Hello!
viagra ,

Hello! viagra ,

Hello!
viagra ,

EMTxWjZ Valium Ambien

EMTxWjZ Valium Ambien

Hello! cialis , viagra ,

Hello!
cialis , viagra , viagra , viagra , cialis ,

Hello! cialis , cialis ,

Hello!
cialis , cialis , viagra , viagra , viagra ,

Hello! viagra ,

Hello!
viagra ,

Hello! cialis ,

Hello!
cialis ,

Hello! viagra ,

Hello!
viagra ,

Hello! viagra ,

Hello!
viagra ,

Hello! viagra ,

Hello!
viagra ,

Hello! viagra , cialis ,

Hello!
viagra , cialis , cialis , viagra , cialis ,

Hello! viagra ,

Hello!
viagra ,

Hello! cialis ,

Hello!
cialis ,