…MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while as these are a bit from different…DRBD – besides the well understood overhead of committing on both nodes instead of one …(check required) so you need to have processes to ensure your application does not …
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… wrote about it, other people from MySQL Community too. The situation did not … when it is going through the process. Second. Schedule it. Most systems would…where it can be done on different servers at different times with team informed about… from innodb_flush_log_at_trx_commit=1 and sync_binlog=1 to…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…complications and performance overhead. MySQL has to do several fsync() calls per transaction commit to be on … being run for different storage engines, but really this is not enough as MySQL allows you …CPU cycles by having storage format same as processing format. We could tune Optimizer to handle …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important part in your system performance or it may not be. Different… you want to recover to last committed transaction in case your data RAID volume… at least basic understanding of the processes to be able to reliably identify problems…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…MySQL settings for MyISAM (table_cache=64) and set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit…” even though loadavg was about 1. In the process list I could see some single value …: 5157.1389149296sec. Insert performance is close, the difference is perhaps explained by the fact files …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… just starting find bits of time from processing accumulated backlog. The Theme of this Users …while data pages and pages for different indexes may well have very different compression ratio. As Innodb … for READ-COMMITED isolation mode which will start offering more performance benefits in MySQL 5.1 …
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…customer utillizes the database. Having many different users running their queries on …of data for the hardware to process from even small tables. Therefore …: 254 Other_commands: 85 Commit_transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… network you need to come up with different consistence guaranty and semantics… and believe me …released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit still …of work to do to straighten up this process so good patches can quickly appear in community…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…TRANSACTION 0 0, not started, process no 3396, OS thread id 1152440672 MySQL thread id 8080, …may block purge process eating up resources. By looking at transaction counter difference between current and… as transactions which have done updates are commited and decreased as purge runs. Total number…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… out not buffer pool but some other important parts of MySQL process. Q20: We’ve migrated to using INNODB so that it…, group commit being broken in 5.1 makes no difference. If you have a battery-backed disk controller cache, then the commit returns… using couple of MySQL Servers on single node. You can make them to use different hard drives and bind to different CPUs. Q25…
