> > What are some typical queires for a given schema? > I have no idee thats the whole problem, its a propretaire product.
Nothing is proprietary when it comes to mysql, you can turn on the slow query log which is the first thing, do you have it turned on? What is the slow query set to? Are any showing up? If so, then it must be time to add some indexes until they go away. The next thing you can always do is turn on the general query log, and that will pretty much log everything, and then you can see everything that is being done. I've use a similar product that worked with snort in the past, it worked fine for us, but snort is boring. You need to pull the data right from the switch, using something like netflow and logging like 600mb/s of netflow logs to mysql is much more fun! Donny > -----Original Message----- > From: Patrick Marquetecken [mailto:[EMAIL PROTECTED] > Sent: Friday, December 10, 2004 3:03 AM > To: [EMAIL PROTECTED] > Subject: Re: MYSQL is getting slow > > On Thu, 9 Dec 2004 12:34:36 -0800 > "Dathan Pattishall" <[EMAIL PROTECTED]> wrote: > > > This is a very broad question, I sometimes do this myself. But to answer > I know, but where must i begin ... > > > the question to the best of my ability I have to ask a few. > > > > > > Are you using RAID? If so what RAID level? > no raid > > > > What are you're my.cnf settings? > standaard execpt for the bind address > > > > What type of Indexes are you using? > On the larged table that has only 2 fields there are primary indexes on > both fields. And each table has its ons primary index, and some other > "normal" indexes. > > > > > What does vmstat and iostat say? > NIDS-console distfiles # free > total used free shared buffers cached > Mem: 507508 497872 9636 0 2232 399024 > -/+ buffers/cache: 96616 410892 > Swap: 506036 62384 443652 > > procs -----------memory---------- ---swap-- -----io---- --system-- ---- > cpu---- > r b swpd free buff cache si so bi bo in cs us sy > id wa > 0 2 62384 5044 2380 401636 1 1 251 18 7 522 15 6 > 79 0 > 1 0 62384 4412 2392 402296 0 0 4511 13 1272 1859 17 5 > 79 0 > 0 2 62384 4504 1840 402744 0 0 4556 72 1325 1977 16 8 > 76 0 > 2 0 62412 4960 1808 401408 0 0 3959 0 1170 1866 35 13 > 52 0 > > > > What Filesystem are you using? > ext3 > > > > What are some typical queires for a given schema? > I have no idee thats the whole problem, its a propretaire product. > > > > > > Typically for most orginizations mysql dedicated on the box below is > > wicked fast, even when not optimized because of system cache etc. But if > > your running out of diskspace then that's a problem in itself. > I got a lot of disk space left. > > > > > > -----Original Message----- > > From: Patrick Marquetecken [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 09, 2004 7:49 AM > > To: [EMAIL PROTECTED] > > Subject: MYSQL is getting slow > > > > Hi, > > > > I have 3 snort sensors logging to a central mySQL database after two > > weeks the size of the database is about 3.3GB and the machine is getting > > slow, as i'm not used to be working with mySQL is my question how far > > can i go before the machine stop responding ? > > > > HP Pentium4 - 2.2mhz - 512 mb, 99% used and no swap, HD of 40GB. > > > > TIA > > Patrick > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
