… get for for Index Stats created by ANALYZE TABLE for MyISAM and Innodb. But before we go into that I wanted to… see in the difference of behavior of ANALYZE TABLE for MyISAM vs Innodb. I used the following simple table for tests: CREATE TABLE… significantly. This means Innodb and MyISAM have different stats computation method by default. Lets check how stats change for MyISAM if we change…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB is…=128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread…
Comment: High-Performance Click Analysis with MySQL
December 23, 2008 By 13 Comments
… or causes table locks if you happen to use MyISAM. 2) Real time vs delayed. I think for many applications semi-real… data compact. 4) MyISAM vs Innodb – if you have read only data you can often get data clustering with MyISAM too by ALTER TABLE … ORDER BY X. It is not same as with Innodb (data is never…
Comment: Choosing innodb_buffer_pool_size
November 4, 2007 By 38 Comments
… this becomes rather tricky question – it depends on sizes of MyISAM vs Innodb as well as workload. Generally you ever have to use… use 2:1 split towards giving more memory to Innodb ans then for MyISAM part use about 1/3-1/2 for Key buffer and just use other part as extra OS cache as MyISAM…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
May 24, 2007 By 117 Comments
Nice test, nice results. This results have influence on my conclusion MyISAM vs InnoDB. InnoDB win 
.
Comment: Solving INFORMATION_SCHEMA slowness
December 23, 2011 By 16 Comments
Shlomi, Thanks. Good to know. I do not use a lot of complicated IS stuff my main needs are to query tables to find how much space table take, how many are MyISAM vs Innodb and similar things. Changing this option changes it from very painful to quite easy
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
April 8, 2008 By 117 Comments
Results are interesting, especialy MyISAM vs InnoDB.
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 9, 2007 By 117 Comments
Results are interesting, especialy MyISAM vs InnoDB.
Comment: Quick look at Ubuntu 6.06
June 13, 2006 By 3 Comments
… colud be? /* original idea was to check the performance of myisam vs innodb /*
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The difference… for MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method…
