…=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… 2). There MyISAM shows bad scalability with increasing count of thread. I think the reason is pread system call MyISAM uses to access…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
…’s blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB‘s scalability as… a reasonably typical commodity machine except for the high core count, which is more than I can remember seeing in the… done great work in the last couple of years making InnoDB scale and perform better on modern hardware.
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… see in the difference of behavior of ANALYZE TABLE for MyISAM vs Innodb. I used the following simple table for tests: CREATE TABLE… for the row count in the table) It is worth to note if you do ALTER TABLE Innodb, same as MyISAM will internally… significantly. This means Innodb and MyISAM have different stats computation method by default. Lets check how stats change for MyISAM if we change…
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 …InnoDB clustering by primary key. InnoDB does not need an extra lookup to access to data. READ_PK_RANGE_INDEX Query: SELECT count…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
June 9, 2009 By 117 Comments
…æˆ‘æ‰¾åˆ°ä¸€ç¯‡æ–‡ç« é‡å° MyIASM, InnoDB å’Œ Falcon 來åšæ¯”較，在酛 是：There MyISAM shows bad scalability with increasing count of thread. I think the reason is pread system call MyISAM uses to access data and retrieving from OS cache is not scaled. InnoDB vs MyISAM vs Falcon benchmarks – part 1…
Comment: T2000 CPU Performance - Watch out
May 2, 2008 By 12 Comments
… as informative as a benchmark of SELECT COUNT(*) from t and benchmarking InnoDB vs MyISAM where MyISAM will beat InnoDB by a large factor. A blog…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…jam packed rows – quite possible scenario for MyISAM tables. Now if we take the …full table scan vs range scan by index: mysql> select count(pad) from large; +————+ | count(pad) | +————+ | 31457280 | …. There are also clustered keys in Innodb which combine index access with data access…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…DRBD. If you’re using MySQL with Innodb (and running MyISAM with DRBD makes little sense anyway) you…network IO we’re speaking about 300 microseconds vs 5000 microseconds and DRBD overhead can be …of amount of synchronous operations required – which we counted to be 4 per transaction commit, or could…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
… or another page was accessed yesterday vs today. Understand specific features and characteristic …list on Benchmark Wiki) SELECT project, sum(page_count) sm FROM pagestat JOIN datesinfo di ON… run queries against available engines: MySQL MyISAM / InnoDB (to have reference results) InfoBright InfiniDB…
