List:General Discussion« Previous MessageNext Message »
From:Donny Simonton Date:December 11 2004 5:11am
Subject:RE: MYSQL is getting slow
View as plain text  
> > 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:patrick.marquetecken@stripped]
> Sent: Friday, December 10, 2004 3:03 AM
> To: mysql@stripped
> Subject: Re: MYSQL is getting slow
> 
> On Thu, 9 Dec 2004 12:34:36 -0800
> "Dathan Pattishall" <dathan@stripped> 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:patrick.marquetecken@stripped]
> > Sent: Thursday, December 09, 2004 7:49 AM
> > To: mysql@stripped
> > 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/mysql?unsub=1
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> >
> >
> >
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1


Thread
MYSQL is getting slowPatrick Marquetecken9 Dec
  • Re: MYSQL is getting slowJeff Smelser9 Dec
  • Re: MYSQL is getting slowgerald_clark9 Dec
    • Re: MYSQL is getting slowDarryl Waterhouse9 Dec
      • Re: MYSQL is getting slowPatrick Marquetecken9 Dec
        • Re: MYSQL is getting slowJeff Smelser9 Dec
          • Re: MYSQL is getting slowPatrick Marquetecken10 Dec
  • Re: MYSQL is getting slowIng. Bismarck J. Rojas M.9 Dec
  • Re: MYSQL is getting slowmos10 Dec
  • Re: MYSQL is getting slowPatrick10 Dec
RE: MYSQL is getting slowDathan Pattishall9 Dec
  • Re: MYSQL is getting slowPatrick Marquetecken10 Dec
    • How to rebuild indexes in InnoDBAnil Doppalapudi10 Dec
    • RE: MYSQL is getting slowDonny Simonton11 Dec
RE: How to rebuild indexes in InnoDBDathan Pattishall10 Dec