[...] problem in both cases was MySQL 5.0 broken group commit [...]
Comment: Group commit and real fsync
[...] Of course I would not say it is normal and nothing can be done in all cases. There are performance bugs, some of them as Innodb Scalability were known long before MySQL 5.0 was stable but were not fixed, others, such as broken group commit could have been handled better. [...]
Post: Watch out for Marketing benchmarks
….0 was stable but were not fixed, others, such as broken group commit could have been handled better. Same applies to comparing MySQL…
Post: Using Flexviews - part one, introduction to materialized views
… SQL is built. All SQL can be broken down into relational algebra, which is convenient… the computation is likely expensive. Views containing grouping, aggregation, sorting, distinct or other conditions must…consistent point in time, with respect to committed transactions The processing can be done on…

