List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 17 2003 10:14pm
Subject:Re: innodb poor performance
View as plain text  
At 12:53 -0700 5/16/03, Jeremy Zawodny wrote:
>On Fri, May 16, 2003 at 03:43:09PM -0400, Vincent Ferretti wrote:
>>  I have created two identical tables (same structure, same content) but one
>>  is an innodb table and the other is myIsam.
>>
>>  CREATE TABLE my_table (
>>     id INT(10) UNSIGNED NOT NULL,
>>     chromatogramID INT(10) UNSIGNED,
>>     sequence TEXT,
>>     seqQuality TEXT,
>>     UNIQUE (chromatogramID),
>>     PRIMARY KEY (id)
>>  );
>>
>>  I've put with LOAD DATA 388896 records for a total of 1.3 GIG
>>
>>  The same query
>>
>>  SELECT COUNT(id) from my_table
>>
>>  takes 0.17 for the myIsam and 1min 40 sec for the innnodb version. Worst,
>>  when I query again, it could take up to 6 min to give the same result with
>>  innodb.
>
>Have you seen the part of the InnoDB manual that describes why COUNT()
>queries are slow?

I don't understand why that applies, if I'm looking at the same section.
It pertains to COUNT(*), but the question above is for COUNT(col_name).

Vincent, are you actually issuing the query shown above, or are you really
using COUNT(*)?

>--
>Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
><Jeremy@stripped>  |  http://jeremy.zawodny.com/
>
>MySQL 4.0.8: up 102 days, processed 3,193,299,829 queries (361/sec. avg)
>


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
innodb poor performanceVincent Ferretti16 May
  • Re: innodb poor performanceJeremy Zawodny16 May
    • Re: innodb poor performancePaul DuBois18 May
      • Re: innodb poor performanceJeremy Zawodny18 May
        • Re: innodb poor performanceFred van Engen18 May
          • Re: innodb poor performanceJeremy Zawodny18 May
            • Re: innodb poor performanceFred van Engen18 May
  • Re: innodb poor performancegerald_clark16 May
  • Re: innodb poor performanceVincent Ferretti18 May
  • Re: innodb poor performancewalt19 May