PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 18, 2004 10:38 AM
Subject: Speed of MyISAM vs. InnoDB
Hi all,
I'm using mysql 4.0.17 and I have this problem with speed of innodb
database:
I have simple command like select count(*) from table1, or select field1,
field2
Is it just not the case that InnoDB table have to do more as they have more
functionality and so take more time?
Simon
- Original Message -
From: "Jiří Matějka" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 18, 2004 10:38 AM
Subject: Spee
"Jiri Matejka" <[EMAIL PROTECTED]> wrote:
> Now I found one more "strange" thing - if I use show tables to get table
> properties, then if table is MyISAM the number of rows is correct and if it
> is InnoDB number of rows is around 2000 lower... And the innodb table looks
> 8 times bigger than myis
From: "Jiri Matejka" <[EMAIL PROTECTED]>
> Now I found one more "strange" thing - if I use show tables to get table
> properties, then if table is MyISAM the number of rows is correct and if
it
> is InnoDB number of rows is around 2000 lower... And the innodb table
looks
> 8 times bigger than myisa
Now I found one more "strange" thing - if I use show tables to get table
properties, then if table is MyISAM the number of rows is correct and if it
is InnoDB number of rows is around 2000 lower... And the innodb table looks
8 times bigger than myisam table (field data_length in show table status
q
Unfortunately it persists also for real queries. Eg. query like "select
field1 from table1 where field3=xx" and InnoDB is cca 10times slower than
MyISAM.
I wonder whether there is not some error or problem in my.ini settings, I
use following settings:
innodb_additional_mem_pool_size 1048576
innodb
COUNT(*) is a special case for MyISAM. However, you'll find that
anything that has a WHERE clause that takes advantage of an index is
pretty quick for both MyISAM and InnoDB tables.
For instance:
SELECT COUNT(*) FROM table;
Is slow as all buggery on InnoDB, but:
SELECT COUNT(id) FROM table WH
I think count(*) is a special case: MyISAM holds a record count which it
can access instantly, InnoDB has to count rows. Does the time difference
persist for real queries?
Alec
Jiří Matějka <[EMAIL PROTECTED]> wrote on 18/02/2004 10:38:13:
> Hi all,
> I'm using mysql 4.0.17 and I ha
Hi all,
I'm using mysql 4.0.17 and I have this problem with speed of innodb
database:
I have simple command like select count(*) from table1, or select field1,
field2 from table1. The table1 and has more than cca 10.000 rows (most of
the fields are integer, only several varchars and several memo
