…the third one features even higher QPI speed (and thus, faster inter-process/node communication…:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT …–percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… must guarantee the logging action happens before the transaction is committed, this is known as write-ahead-logging. This essentially means…, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log. You can… log to disk at commit. By this means you are ensuring that in the event of a MySQL crash the data will…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… MySQL 5.0 broken group commit bug. First I should note I am extremely unhappy how MySQL handled this problem. While working for MySQL… so group commit would trigger in MySQL 4.0 and large number of transactions in total so serializing them would make MySQL unable… with MySQL 4 also because 100% durable transactions are not required anyway and it would allow to get some extra speed. It…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total… default MySQL settings for MyISAM (table_cache=64) and set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit=2… for this server configuration. Going to 10000 tables however insert speed dropped 20 times. This could be because ext3 does not…
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
… two issues here which interleave such funny way Group commit is broken in MySQL 5.0 if binary loging is enabled (as… was implemented in MySQL 5.0 which did not work with former group commit code. The new code for group commit however was… sequential fsync() calls per second depending on your hard drive speed. With fake fsync() call the data is only written to…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…but writes still have to happen at full speed. It also really hurts if you choose replication…use existing solutions you can use memcache + another mysql instance (or simply the database which is not…the chunk in single transaction saving on log commits significantly. I mentioned you can use MyISAM or…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = READ-COMMITTED max… was left in tact. Other important settings: transaction-isolation = READ-COMMITTED – this is indeed good setting for many workloads so unless… option is rarely used so I’m curious how much speed benefit did it really provide in this case. innodb_max…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… on innodb_flush_lot_at_trx_commit setting you may lose few last committed transactions but it is it. … have innodb_file_per_table=1 your recovery speed will depend on number of Innodb tables you have… internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL 4.1 sync_frm …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Memory ##################################################### Total | 23.59G … Locator Size Speed Form Factor Type Type Detail ========= ======== ================= ============= … different MySQL configurations, I didn’t try out different MySQL …innodb_flush_log_at_trx_commit = 2 innodb_flush_method …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the… will unlikely be helpful solving replication delay or speeding up this 3 hours reporting query or 5… recovery if you want to recover to last committed transaction in case your data RAID volume was …
