Hi
Have you done a optomis on the query?
Is there any problmes with the tables?
Did MySQL create lost of temp tables?
Have you got lots of memmory in the sever?
Has MySQL reported Long questones?
Just a few things that I can think of....
I hope this helps?
Simon
-----Original Message-----
From: Robert Dayton [mailto:[EMAIL PROTECTED]]
Sent: 11 September 2001 11:42
To: [EMAIL PROTECTED]
Subject: MySQL Blasting CPU
I had a strange problem with MySQL 3.23.41 eating up my cpu, too.... I had
just done a query to the database and it ate all of the cpu and slowed down
all other processes on the machine for 20 minutes. I had to reboot the
server. It did this 3 times. Database only had 15,000 records in it at the
time so I knew it must be something I was screwing up with the query. It had
two tables in the from clause like:
SELECT whatever the hell I selected FROM table1,table 2 WHERE whatever....
Then I made a slight change to the problematic query:
SELECT whatever the hell I selected FROM table1 LEFT JOIN table2 on
table2.primary key = table1.primary key WHERE whatever....
After that, the query decided to only take a fraction of a second...
Go figure...
Robert Dayton
Unconventional Solutions, Inc.
Creators of DForce
Internet Process Serving Software
88-30 Sutphin blvd
Jamaica, NY 11435
(718) 558-6081
(352) 343-0462
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
