Need someone to lead product management at your software company? I create software for people that create software and I'm looking for my next opportunity. Check out my resume and get in touch.

count(*) in InnoDB

Freshness Warning
This blog post is over 17 years old. It's possible that the information you read below isn't current and the links no longer work.

1 Dec 2006

I’d always read that an advantage of MySQL’s MyISAM tables over InnoDB tables was the performance of counting rows with count(*). Conventional wisdom says if you do count(*) with InnoDB you’ll see much slower results on large tables than if you use MyISAM.

I hadn’t ever noticed that difference. In places in my apps where I do count(*) InnoDB seems to be just as fast as MyISAM—even on tables with millions of rows. MySQL Performance Blog has an explanation.

It only applies to COUNT(*) queries without WHERE clause. SELECT COUNT(*) FROM USER ... will be much faster for MyISAM. SELECT COUNT(*) FROM IMAGE WHERE USER_ID=5 ... will be executed same way both for MyISAM and Innodb.

Since most real-world usage of count(*) is in determining how many rows are returned by a query, not how many rows exist in a table, most people won’t need to concern themselves with this performance "issue."

Recently Written

Too Big To Fail (Apr 9)
When a company piles resources on a new product idea, it doesn't have room to fail. That keeps it from succeeding.
Go small (Apr 4)
The strengths of a large organization are the opposite of what makes innovation work. Starting something new requires that you start with a small team.
Start with a Belief (Apr 1)
You can't use data to build products unless you start with a hypothesis.
Mastery doesn’t come from perfect planning (Dec 21)
In a ceramics class, one group focused on a single perfect dish, while another made many with no quality focus. The result? A lesson in the value of practice over perfection.
The Dark Side of Input Metrics (Nov 27)
Using input metrics in the wrong way can cause unexpected behaviors, stifled creativity, and micromanagement.
Reframe How You Think About Users of your Internal Platform (Nov 13)
Changing from "Customers" to "Partners" will give you a better perspective on internal product development.
Measuring Feature success (Oct 17)
You're building features to solve problems. If you don't know what success looks like, how did you decide on that feature at all?
How I use OKRs (Oct 13)
A description of how I use OKRs to guide a team, written so I can send to future teams.

Older...

What I'm Reading

Contact

Adam Kalsey

+1 916 600 2497

Resume

Public Key

© 1999-2024 Adam Kalsey.