… fsyncing every transaction (innodb_flush_log_at_trx_commit != 1), or work around it with by fsyncing to memory (Battery or capacitor… distributed system requires tradeoffs. Most of us are used to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… in InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates memory …memory during the entire connection lifetime and free it at disconnect. If some transactions require a larger amount of memory – we just reallocate memory…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… of MySQL performance that still stands in the way of InnoDB scalability is…matter of copying a relatively small memory block which, depending on many factors,…requires neither read-only server nor rewriting application queries. Furthermore, it can be combined with the read-only optimization in MySQL…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…I received from Virident required the use of the…the available buffer pool memory but still fits into …mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool (thus leading to a…. FlashCache, on the other hand, requires building a separate kernel module in addition to whatever flash memory driver you’ve already had to install, and then further configuration requires modification to assorted sysctls…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… always where – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If… be impractical. Here is why: List of rarely considered MySQL Server Memory Requirements Thread buffers can be allocated more than once for each…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… other problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that crosses…-unix-memory plugin checks for a single process consuming too much memory and/or for too little free memory in general. This plugin requires…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on a…=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs…information is to compare systems with different memory amount having same workload. You will often…time spent. This is because IO handling requires significant number of CPU. With Percona Server,…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… using indexes. In fact even MySQL optimizer currently does not take it into account. For In memory workload index accesses might be… be located sequentially or require radom IO if index ranges are scanned. There are also clustered keys in Innodb which combine index… should mention one more MySQL limitation which requires you to be extra careful working with large data sets. In MySQL single query runs…
