>also try enabling the slow-log and track down any long queries.
just did that, so we'll go through that now, there are some in there...
>Have you tuned any of the cache parameters for the large amount of
>memory you have?
yes, we have done extensive tuning. Is there something I can provide
ot;PR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 19, 2001 2:27 AM
Subject: FreeBSD and multiple daemons
> I'm having a problem with my server getting bogged down once in a
while and
> I'm pretty sure it's due to the mysql daemon getting m
On Sun, Aug 19, 2001 at 10:52:00AM +0100, Mike Clemson wrote:
>
> gcc
> filename.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient
>
> and get the error:
>
> /usr/local/mysql/lib/libmysqlclient.a (my_compress.o): In function
> 'my_compress':
> my_compress.o (.text+0x9a): undefin
Hi Jerry,
The load figure on a machine is the average number of processes needing
to use the CPU on the machine. Since all of the MySQL activity is in
threads under a single process, it only counts as one towards the load
average, so a load of 1.3-1.5 with a maxed out CPU is valid. (Yes, I
kno
Anyone,
I am recently new to mysql, although a have a few years experience in c
programming. I am attempting to build a simple 'connect to database' c-api
prog
on mandrake 7.2.
Using:
gcc
filename.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient
and get the error:
/usr/local
>second delays, did you compile mysql yourself or use a pre-compiled
>binary...
>
>Sid
>
>
>
>> -Original Message-
>> From:PR [SMTP:[EMAIL PROTECTED]]
>> Sent:Sunday, August 19, 2001 4:28 PM
>> To: [EMAIL PROTECTED]
>> Subject:
To: [EMAIL PROTECTED]
> Subject: FreeBSD and multiple daemons
>
> I'm having a problem with my server getting bogged down once in a while
> and
> I'm pretty sure it's due to the mysql daemon getting maxed out with what
> it
> can do... when this happens there migh
I'm having a problem with my server getting bogged down once in a while and
I'm pretty sure it's due to the mysql daemon getting maxed out with what it
can do... when this happens there might be anywhere from 100 to 150
processes in the processlist and it might take as much as 30 seconds to
return
