I am having a similar sort of problem, 88k+ records (syslog entrys) doing a
select * from db group by host takes 2.5seconds select * where with a host
with 87k records takes 5.7seconds. CPU useage jumps up to to between 10 and
99.9% With a single proc linux box the exact same happened but with less
records 35k
This is on a Sun e250 dual ultrasparc II 400 with 760+meg ram, running
Solaris so i dont think its a problem with not enough hardware.
Any ideas?
Thanks
Dan
-----Original Message-----
From: Rodney Broom [mailto:[EMAIL PROTECTED]]
Sent: 18 September 2001 19:22
To: [EMAIL PROTECTED]
Subject: Re: MySQL is hogging my box
From: Stefan Pinkert <[EMAIL PROTECTED]>
> There are some others with a similar problem(including me).
Hi guys. I'd be really interested in knowing things like how many requests,
and of what type, are being made of your database(s). If you're making a
couple of dozen SELECTs per day, then I'd say that you have a problem, but
if you're doing 500,000,000 INSERTs and 1 Bil. SELECTs, then I could see
some call for your systems to slow down.
---
Rodney Broom
Programmer: Desert.Net
---------------------------------------------------------------------
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
