On Thu, Jun 07, 2001 at 06:43:01PM +0000, [EMAIL PROTECTED] wrote:
> Dear Sirs,
>
> We have a very large database (badge_history has > 4,000,000 rows)
> and the explain for our query looks like this:
Like what?
> By using indexes for a query, the product of the row estimates from
> an explain statement are less than 200,000. The problem is that this
> query times out. There is only one table being scanned, the primary
> keys are being used on the rest of the tables. This is running on a
> machine with 2 8XX processors and almost a gigibyte of ram. Can
> anyone explain why this query is not working?
How big is your key_buffer? Can we see the output of SHOW VARIABLES
and SHOW STATUS? Have you tweaked your my.cnf file to make use of that
RAM you've got?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 13 days, processed 82,076,999 queries (71/sec. avg)
---------------------------------------------------------------------
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
