Check out this great article on mysql server performance tuning. It focuses on the MySQL daemon settings, and shows you how to analyze the stats on your running database server and tune the configuration parameters to tweak performance. It's pretty easy to follow and provides good, practical advice. You can also read this blog entry showing how some of these tips were used in a Sguil environment.
Archving the Sguil Database
Here is an excerpt from the sguil-users sourceforge list:
Re: archive script Subject: Re: archive script List-id: <sguil-users.lists.sourceforge.net> There won't (can't) be an archive script that works the way we have things now due to the changes in the DB. I've been pushing around different ideas to make sguild handle the archiving itself. The easiest way to do that right now is something similar to: 1) Stop sguild 2) Stop mysqld 3) cd /path/to/db/sguildb 4) rm *YYYYMMDD* OR mv *YYYYMMDD* /path/to/archive 5) rm event.* tcphdr.* udphdr.* icmphdr.* data.* sancp.* 6) start mysqld 7) start sguild That should be relatively quick (faster than the archive script for those w/big DBs) And to put archived data back online, just change step 3 to 'cp /path/to/archive/*YYYYMMDD* /path/to/db/sguildb/' Bammkkkk Bammkkkk On 1/9/06, Guy Bruneau <seeker-gy7JKNnsfafD1m2VYDcomQ@xxxxxxxxxxxxxxxx> wrote: > Are you planning to update it to make it compatible with 0.6.0? It is very > useful to cleanup the database > > Guy > > Bamm Visscher <bamm.visscher-Re5JQEeQqe8AvxtiuMwx3w@xxxxxxxxxxxxxxxx> wrote: > The archive script is for 0.5.3 and below, sorry about that. > > > > On 1/9/06, Guy Bruneau wrote: > > I was wondering if anyone tried the archive script with Sguil 0.6.0. Is it > > supposed to delete all daily tables it create when you run the script? I > ran > > the script and was left with all of the old tables and the archive file. > > > > Guy