… this apply to the MySQL innodb memcache? i.e. will the cache being delete off innodb table after 12hours or they remain… you also do a comparison between performance of 5.6 memcached innodb write/read vs 5.6 innodb write/read with no memcached layer? Currently…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… (innodb_flush_log_at_trx_commit != 1), or work around it with by fsyncing to memory (Battery or capacitor-backed write cache… does NOT set an lower bound on performance, only a upper bound. The best performance you can expect is modifying a given… in the cluster the writes are coming from: From the same node: This will behave just like standard Innodb. The first transaction…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table…which could unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey Kopytov). Ported back from…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table…which could unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey Kopytov). Ported back from…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…the cluster. Also, at the time of this writing, from async stream, MyISAM is not being …, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay… PK imposes an additional overhead, and because cluster performance is somewhat dependent on the slowest node – this…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 2, 2013 By 10 Comments
…: innodb_only r/w_batch_size = 1 I don’t have the full numbers off hand, but definitely saw major performance improvements (more on the write side, but it was on read as well) increasing the batch sizes and changing to “caching” from “innodb_only…
Post: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
Choosing a good InnoDB log file size is key to InnoDB write performance. This can be done by measuring the amount of writes in the… 1 writes 100 bytes to the log buffer At commit, InnoDB writes a 512-byte block at offset xxx and increments Innodb_os_log_written by 512 bytes Transaction 2 writes 200 bytes…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… RAM from 8Gig to 16Gig help the write performance of Innodb on Solaris? HT: Yes, if your ‘write working set’ fits in 16 GB… memory for write buffering efficiently. Q30: Question about using solid state disks for storing ib_log* files; I know that innodb writes files in the log file group in a round robin fashion. I also know that there is some writing that…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file… cause read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Post: Innodb Double Write
August 4, 2006 By 24 Comments
… very interesting techniques Innodb uses is technique called “doublewrite” It means Innodb will write data twice when it performs table space writes – writes to log files… case Innodb will perform update. If page is inconsistent recovery can’t proceed. Now lets talk a bit about partial page writes – what…
