As others have suggested , turn your slow query log on in my.cnf , and set
your long-query_time, and you can view your slow queries in the *.log file
in your data dir, and then try to optimize them, you could also try mytop (
http://jeremy.zawodny.com/mysql/mytop/) , and check your queries in real
Is tat query is the problem ?
Then turn on your slow queies and try optimizing those slow queries ?
Post your queries and table description for further help :)
--Praj
On Wed, 29 Mar 2006 12:33:20 -0500
"Jacob, Raymond A Jr" <[EMAIL PROTECTED]> wrote:
>
> After a 23days of running mysql, I
Jacob, Raymond A Jr wrote:
After a 23days of running mysql, I have a 3GB database. When I use an
application
called base(v.1.2.2) a web based intrusion detection analysis console, the
mysqld utilization
shoots up to over 90% and stays there until the application times out or is
terminated.
Q
After a 23days of running mysql, I have a 3GB database. When I use an
application
called base(v.1.2.2) a web based intrusion detection analysis console, the
mysqld utilization
shoots up to over 90% and stays there until the application times out or is
terminated.
Question: Have I made some err
If you suddenly are spiking in unauthenticated connections, you may
be the target of a network attack. This could be just a random probe,
you may be a random target or someone may be targeting you. Although
if someone were specifically targeting you, you would probably be down.
I would chec
"my.cnf" add this: "skip-name-resolve" under "[mysqld]"
On 8/29/05, Callum McGillivray <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm pretty new to the list, so please be kind :)
>
> I'm having serious problems with our core mysql server.
>
> We are running a Dell Poweredge 2850 with dual Xeon 3
Hi all,
I'm pretty new to the list, so please be kind :)
I'm having serious problems with our core mysql server.
We are running a Dell Poweredge 2850 with dual Xeon 3.0 processors, RAID
5 and 1Gb memory.
There are 3 main databases running on this machine, one is a freeradius
database, one i
