IL 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
You are probably a little short of RAM for that size db. Lack of swap may
bite you as well. How big are your keys?
Pat...
- Original Message -
From: "mos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 10, 2004 10:48 AM
Subject: Re: MYSQL is get
At 09:49 AM 12/9/2004, Patrick Marquetecken wrote:
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 s
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
On Thu, 9 Dec 2004 13:13:10 -0600
Jeff Smelser <[EMAIL PROTECTED]> wrote:
> On Thursday 09 December 2004 01:06 pm, Patrick Marquetecken wrote:
>
> > and for ansewring Jeff Smelser i have installed mysql 4.x on linux and then
> > dit from the commandline create database and then run the create tab
This is a very broad question, I sometimes do this myself. But to answer
the question to the best of my ability I have to ask a few.
Are you using RAID? If so what RAID level?
What are you're my.cnf settings?
What type of Indexes are you using?
What does vmstat and iostat say?
What Filesystem
On Thursday 09 December 2004 01:06 pm, Patrick Marquetecken wrote:
> and for ansewring Jeff Smelser i have installed mysql 4.x on linux and then
> dit from the commandline create database and then run the create table
> commands from snort.
No idea.. you can do a show create table db.table to fin
On Thu, 09 Dec 2004 16:17:17 +
Darryl Waterhouse <[EMAIL PROTECTED]> wrote:
> On Thu, 2004-12-09 at 10:08 -0600, gerald_clark wrote:
>
> >
> > Patrick Marquetecken wrote:
> >
> > >Hi,
> > >
> > >I have 3 snort sensors logging to a central mySQL database after two weeks
> > >the size of the
On Thu, 2004-12-09 at 10:08 -0600, gerald_clark wrote:
>
> Patrick Marquetecken wrote:
>
> >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 my
It can be a service that this running and you this saturating the yield of the
CPU. top in a terminal like root uses the command to be able to see that
service this consuming.
greetings
--
Ing.. Bismarck J. Rojas M.
El Jueves, 9 de Diciembre de 2004 09:49, Patrick Marquetecken escribió:
>
Patrick Marquetecken wrote:
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 Pe
On Thursday 09 December 2004 09:49 am, Patrick Marquetecken wrote:
> 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
> be
12 matches
Mail list logo