… several times, i.e. http://www.mysqlperformanceblog.com/2011/09/18/disaster-mysql-5-5-flushing/ http://www.mysqlperformanceblog.com/2011/03/31/innodb-flushing-a-lot-of-memory-and-slow-disk/ http://www.mysqlperformanceblog.com/2011/01/03/mysql… improved flushing, but I’d like to see more stable results, so there is a room for improvement. Relevant MySQL options…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
… fairly superficial though. While both store results in a table, the MV represents the results of a SQL statement at a specific… those changes to compute the differences between the old results and the new results Delta application – How Flexviews uses the deltas to…). You can find part 2 of the series here: http://www.mysqlperformanceblog.com/2011/03/25/using-flexviews-part-two-change-data-capture/
Comment: Intel 320 SSD read performance
July 30, 2011 By 11 Comments
…, you can find some results there http://www.ssdperformanceblog.com/2011/06/fusionio-320gb-mlc-random-write-performance/ http://www.ssdperformanceblog.com/2011/06/intel-320-ssd…
Post: Drop table performance
April 20, 2011 By 22 Comments
… post http://www.mysqlperformanceblog.com/2011/02/03/performance-problem-with-innodb-and-drop-table/ and these bug reports: http://bugs.mysql.com/bug…_table”, and in MySQL 5.6.2. Here are my results (results in seconds; fewer is better): Allocated pages, GBMySQL 5.1….56, but Percona Server 5.1.56 has a better result. The relative comparison for the 104GB case: Pecona Server is…
Post: FusionIO 320GB MLC random write performance
June 23, 2011 By Leave a Comment
I have posted results for FusionIO 320GB MLC on our ssdperformanceblog.com blog. To not duplicate content, there is link on original post:http://www.ssdperformanceblog.com/2011/06/fusionio-320gb-mlc-random-write-performance/ Follow my twitter Follow @VadimTk for further results.
Post: Intel 320 SSD random write performance
June 23, 2011 By 1 Comment
I have posted results for Intel 320 SSD on our ssdperformanceblog.com blog. To not duplicate content, there is link on original post:http://www.ssdperformanceblog.com/2011/06/intel-320-ssd-random-write-performance/ Follow my twitter @VadimTk for further results.
Comment: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… would not expect encouraging results in write-intensive tasks. Or you may try galera replication http://www.mysqlperformanceblog.com/2011/07/14/percona-server…
