> I am currently using MySQL 5.0.16 on a dual pentium 4-2G system with
> 9G of ram. I have a number of machines that connect to the MySQL
> server, doing INSERTS, SELECTS, and UPDATES on 1 table, and generating
> about 1500-3000 queries/sec.
> Now, when the table it's writing to is empty, things are fine....very
> fast, the DB is able to handle all of the queries. Also, when the
> table starts and it's empty, most of the things it's doing are SELECTS
> and INSERTS. As this table fills up, that will change to SELECTS and
> Also, typically there are about 10 threads open at any given time.
> Somewhere around 60 million rows, the # of queries/sec goes down to
> about 500-1500, and the number of threads starts to grow until it
> reaches the server max. (which is set to 90)
> Here is my my.cnf file:
> does anybody have any suggestions or know why the mysql server is
> exhibiting this behavior?
It cannot perform magic. You are most likely exceeding the capabilities of
your hardware. You will need faster hardware or multiple machines with