Re: [logs] syslog/mysql/webGUI.

From: Chris Adams (cadamsat_private)
Date: Wed Jan 30 2002 - 11:37:34 PST

  • Next message: Tina Bird: "[logs] list archive rediscovered" 

    On Wed, Jan 30, 2002 at 09:22:26AM -0500, Marcus J. Ranum wrote:
> Mike Lee wrote:
> >I'm looking for ways to send multiple devices' syslog messages to a mysql
> >database and be able to analyze logs via some sort of web gui.
> 
> 
> Which nicely raises the next thing I wanted to ask:
> Does anyone have any statistics for how many records/second you can
> insert into a MySql database for a reasonable set of assumptions? I.e.:
> assuming one primary index and a reasonably fast machine (say 1Ghz
> with 1GB RAM)*

On decent hardware with a sane schema and tuned mysql, on the order of
thousands.

This includes things like: 
	tuning your mysqld server (esp. throwing some memory at it)

	persistent connections

	using MySQL's optimized insert syntax to batch all available items in a
		single statement (instead of looping 1 INSERT per item) and
		using insert delayed 

	using MyISAM (which is now default) because it allows simultaneous
		selects and inserts but not deletes, which is ideal for
		logging. 

	using the software RAID support to stripe data across multiple devices

	using the MERGE table support so that you insert to, say, a smaller
		daily table and run your aggregate queries across the merge
		table, which avoids touching tables which aren't supposed to
		change.	

---------------------------------------------------------------------
To unsubscribe, e-mail: loganalysis-unsubscribeat_private
For additional commands, e-mail: loganalysis-helpat_private

    This archive was generated by hypermail 2b30 : Wed Jan 30 2002 - 11:42:37 PST