Hello.
> records) takes a long time and drains memory to the point I have to
> reboot the system. Here is the status after a single large query is
What version of MySQL do you use? I'm not familiar with msyslog, so
what queries takes such long time? In what state does the weird queries
t = '$host' AND
> date LIKE '%$date%' AND message LIKE '%$message%' ORDER BY date
> DESC,time DESC LIMIT " . $start . ", " . $numresults . "");
>
>
>
> Thanks
> Jenn
> -----Original Message-----
> From: [EMAIL PROTECT
mresults . "");
Thanks
Jenn
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 21, 2005 1:56 PM
To: Jennifer Fountain
Cc: mysql@lists.mysql.com
Subject: Re: Query Issue on Large DB
Hi,
have you a query sample + show create table + show in
Hi,
have you a query sample + show create table + show indexes from ?
Mathias
Selon Jennifer Fountain <[EMAIL PROTECTED]>:
> Hi,
> I am new to the list and mysql for that matter. I am trying to
> configure a centralized syslog server using mysql, msyslog and php.
> Works great until the DB gr
Hi,
I am new to the list and mysql for that matter. I am trying to
configure a centralized syslog server using mysql, msyslog and php.
Works great until the DB grows to about 2GB. After the database gets
over 2GB, running queries on a particular hostname (that has a lot of
records) takes a long t
