List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:May 9 2001 12:40pm
Subject:Re[2]: Wrong COUNT(*) with Innobase !?
View as plain text  
Heikki,

HT> can you print the EXPLAIN SELECT ... for the count(*) and the other query?


mysql> explain select count(*) from mybuffer where bourse='NAS';
+----------+------+---------------+-----------+---------+-------+------+-------------------------+
| table    | type | possible_keys | key       | key_len | ref   | rows | Extra            
      |
+----------+------+---------------+-----------+---------+-------+------+-------------------------+
| mybuffer | ref  | id_bourse     | id_bourse |       3 | const |  730 | where used; Using
index |
+----------+------+---------------+-----------+---------+-------+------+-------------------------+
1 row in set (0.00 sec)

mysql> explain select * from mybuffer where bourse='NAS';
+----------+------+---------------+-----------+---------+-------+------+------------+
| table    | type | possible_keys | key       | key_len | ref   | rows | Extra      |
+----------+------+---------------+-----------+---------+-------+------+------------+
| mybuffer | ref  | id_bourse     | id_bourse |       3 | const |  730 | where used |
+----------+------+---------------+-----------+---------+-------+------+------------+
1 row in set (0.00 sec)

  Alex.

Thread
weird indexing behavior in presense of LIMITAndrey Gubarev20 Apr
Re:weird indexing behavior in presense of LIMITHeikki Tuuri20 Apr
  • Wrong COUNT(*) with Innobase !?BAUMEISTER Alexandre9 May
Re: Wrong COUNT(*) with Innobase !?Heikki Tuuri9 May
  • Re[2]: Wrong COUNT(*) with Innobase !?BAUMEISTER Alexandre9 May