… variation in InnoDB statistics. It is not much the Optimizer can do about that. In MySQL 5.6 you can use InnoDB Persistent Statistics to get stable statistics and plan stability. (See http://oysteing.blogspot.com/2011/05/innodb-persistent…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… races, starvations etc–have a big impact on application’s stability and are at the same time hard to find due… find on MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb_bug53674… not-so-minor. Additionally, I’d consider backporting and using MySQL 5.5 atomic operation primitives with proper memory barriers, so that there…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
… problems with flushing in InnoDB several times, some links: InnoDB Flushing theory and solutions MySQL 5.5.8 in search of stability This was not often…. MySQL version: 5.5.16 Initial benchmark, which InnoDB configured for this hardware innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log… than on disk. InnoDB is not able to catch up with flushing changed data. With widely adoption of MySQL 5.5 and servers with…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… received with MySQL 5.5.8 (with innodb_doublewrite enabled). In summary, my conclusion is: You can try to get stable throughput in MySQL 5.5.8 by playing with innodb_max_dirty_pages_pct and innodb_io_capacity and having innodb_doublewrite enabled. But…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… a short, 5-minute exercise.) Although it takes a decent time for the Percona Server results to stabilize, for MySQL 5.5.8 we have…. This method requires setting innodb_flush_neighbor_pages=0 , to disable flushing of neighborhood pages (not available in MySQL 5.5.8). The problem… request from commenter I put also results with different innodb_io_capacity for MySQL 5.5.8. It is 500 ( which I used in…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
… InnoDB cannot log at all, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log. You can request that InnoDB force its REDO… MySQL 5.5.8 – in search of stability, as seen in his post, Percona Server with XtraDB allows much larger logs beyond the InnoDB…
Post: Percona Server 5.5.18-23.0: Now with Group Commit!
December 19, 2011 By 3 Comments
…). Based on MySQL 5.5.18, including all the bug fixes in it, Percona Server 5.5.18-23…. import operation. This allows queries accessing other InnoDB tables to proceed normally and not be …and fixed. Bug fixed: #878164 (Laurynas Biveinis) Testsuite stability fix for the percona_status_wait_query_…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… = 0 innodb_adaptive_flushing_method = keep_average innodb_log_block_size = 4096 innodb_log_file_size = 4G Versions: MySQL 5.5.20, Percona Server 5.5.19 With… throughput in Percona Server: increase innodb_log_file_size. There are stability timeline for Percona Server with innodb_log_file_size=8GB And…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… –mysql-socket=/tmp/mysql_sandbox5516.sock prepare [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db… loop to see how result stabilizes. [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –num-threads=1 –max-requests… setting innodb_old_blocks_time to non zero value, if not I would strongly suggest changing default from zero in MySQL 5.6…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… MySQL User I should say MySQL stability have not much improved (really going up and down) since MySQL 4.0. This even applies to Innodb tables which were already on par with general MySQL level of stability in MySQL 4.0… within rather short time. MySQL 5.0 with spice of enterprise features is far from being simple and MySQL 5.1+ with wide choice…
