Well I probably can tweak the queries, but there are a LOT of them. It
is for http://www.ecommstats.com so we get a TON of requests that have
to processed with probably ~20 queries (selects, inserts, updates), then
there is a maintenance program that runs every few minutes to clean
things up a
On Tue, Oct 21, 2003 at 08:59:31PM -0600, Travis Reeder wrote:
> It seems mostly to be mysql pinned, not the app. like 99% mysql until
> all data is processed and keeps going up when data coming in is more
> than can be processed.
So MySQL is using 99% of the CPU?
Any idea why? Are you doing
Would innodb tables help?
Travis
Daniel Kasak wrote:
Travis Reeder wrote:
It seems mostly to be mysql pinned, not the app. like 99% mysql until
all data is processed and keeps going up when data coming in is more
than can be processed.
What could I change in my.cnf to get better performance
I have several queries that are taking at least a full minute to process...
From a web page, user submits parameters to a perl program which performs
multiple queries, then spits the info out formatted for the web.
Does anyone have a quick & dirty method of locating a bottle neck slowing
these
Travis Reeder wrote:
It seems mostly to be mysql pinned, not the app. like 99% mysql until
all data is processed and keeps going up when data coming in is more
than can be processed.
What could I change in my.cnf to get better performance? I just have
a default mysql install (4.0).
Travis
F
It seems mostly to be mysql pinned, not the app. like 99% mysql until
all data is processed and keeps going up when data coming in is more
than can be processed.
What could I change in my.cnf to get better performance? I just have a
default mysql install (4.0).
Travis
Daniel Kasak wrote:
Travis Reeder wrote:
So I think these are the only options, but if someone has another idea
I'd be glad to hear it. Our current server just isn't handling the
load anymore so, it has single processor
Option 1:
Single server with dual processor and change from IDE to SCSI
Option 2:
One s
