>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
Hi Jerry,
Someone has already answered why the load stays at 1.3 to 1.5.
Sounds like one query may be slowing down the others, mytop
(/usr/ports/databases/mytop) might help identify that query also try
enabling the slow-log and track down any long queries. Have you tuned
any of the cache param
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
I don't know, I would have to check with my progammer on that one to be
sure... does this help
mysql -V
Ver 11.15 Distrib 3.23.40, for unknown-freebsdelf4.2 (i386)
[EMAIL PROTECTED] writes:
>Jerry,
>
>Thats a reasonably serious hardware platform, you should not encounter 30
>second delays, did
Jerry,
Thats a reasonably serious hardware platform, you should not encounter 30
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
