MySQL Performance: MySQL => InnoDB and COUNT(*)

Members

Help

Home

Home » Performance » MySQL » InnoDB and COUNT(*)

Show: Today's Messages :: Show Polls :: Message Navigator

InnoDB and COUNT(*) [message #153]

Thu, 07 September 2006 14:14

dinky
Messages: 4
Registered: September 2006
Location: Toronto, ON

Junior Member

It is probably well-known feature/bug but still is a somewhat mystery for me - why exactly a simple "SELECT COUNT(*) FROM table" can take hours to complete on a relatively small dataset (~50M records), not depending on isolation level, no different in 4/4.1/5 ?

Thank you!
--
Dmitry

Report message to a moderator

[Message index]

Read Message InnoDB and COUNT(*)
By: dinky on Thu, 07 September 2006 14:14

Re: InnoDB and COUNT(*)
By: Peter on Thu, 07 September 2006 14:30

Re: InnoDB and COUNT(*)
By: dinky on Thu, 07 September 2006 14:36

Re: InnoDB and COUNT(*)
By: Peter on Thu, 07 September 2006 15:01

Previous Topic: MySQL vs MSSQL

Next Topic: SQL_CALC_FOUND_ROWS

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 9 21:13:33 EDT 2009

Total time taken to generate the page: 0.02179 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.