CAcert Code Development list.

["Greg Stark" <gstark AT cacert.org>]

-----Original Message-----
From: Solomon K. Chang 
[mailto:skevin521 AT yahoo.com]
 
Sent: Tuesday, June 30, 2009 5:45 PM
To: Greg Stark
Cc: 'Wytze van der Raay'
Subject: Re: CAcert - Monitoring


For monitoring, I definitely recommend Zabbix.  It's easy to set up, and if
you have an SMTP server on the same network, you can have it email you
alerts if anything exceeds a certain threshold.  Everything is also stored
as historical data, so if you want want to watch things like CPU and memory
usage over the course of the day/week (usually to see when your peak hours
are), you can do so easily.  Almost anything that you can capture a number
for, you can render as a graph.

As for schema, well, it doesn't look like you're too buried in data yet.
Yeah, "locations" is big, so for starters, if this table requires concurrent
access, change the storage engine to InnoDB.  You might want to consider it
for your users table too.

"notary" has redundant indexes, "from_2" and "to_2".

Do you have your Slow Log set?  I like to keep mine at 1 second.  Especially
for a user heavy database.  Any query that takes up more than a single
second to run is way too much, unless you're doing BI, which should only
take place on a slave that has nothing to do with production.

If either of you have a specific question, please, ask away.

Solomon Chang

--- On Thu, 6/25/09, Greg Stark 
<gstark AT cacert.org>
 wrote:

> From: Greg Stark 
> <gstark AT cacert.org>
> Subject: CAcert - Monitoring
> To: "'Solomon K. Chang'" 
> <skevin521 AT yahoo.com>
> Cc: "'Wytze van der Raay'" 
> <wytze AT cacert.org>
> Date: Thursday, June 25, 2009, 9:11 PM
> Solomon,
> I don't think we have a MySQL DBA. Hence my contacting you.
> In your
> response, you mention:
> 
> > Get a good monitoring package, but every sysadmin
> already knows that.
> > You'll want to set alerts on CPU usage of the mysql
> process, number of
> > tables open, number of current deadlocked queries,
> etc.
> 
> What would you recommend for a monitoring tool(s)?
> 
> You may find quicker answers to questions if I step out of
> the middle and
> talk directly to Wytze van der 
> Raay<wytze AT cacert.org>. 
> There are some
> questions I think you have great expertise, about live
> updating of two or
> more MySQL DBs switching between the them, and
> backups.  Send him your
> presentation handouts you had at CalTech - SGVLUG would be
> helpful.  Scaling
> needs?  Wytze may be able to tell you more.
> 
> The web server runs mysql-server-5.0 (version
> 5.0.32-7etch).
> The current table layout of the database can be obtained
> through
> the regular web interface at http://www.cacert.org/sqldump.php
> 
> Oh, there is also the https://lists.cacert.org/wws/lists and ;
> cacert-devel AT lists.cacert.org 
> CAcert Code Development list to monitor.
> 
> Regards,
> Greg
> 
>