… means MySQL can employ many other optimizations like for example if columns other then the secondary key columns are required to be… other possibilities like InnoDB doing read_ahead by noticing the sequential access pattern. BKA is available in both MySQL 5.6 and… when the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 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 8 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: 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: 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: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 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…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…more efficient in its memory while write buffering can too be done by MySQL and local RAID (with…latency critical. Now what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable …to that backup – no data copy will be required which can be significant concern to 1TB+ databases…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb… unsigned int*) (sp_head.cc:2913) ==9090== Required order was established by acquisition of lock… backporting and using MySQL 5.5 atomic operation primitives with proper memory barriers, so that …
Post: How much memory Innodb Dictionary can take ?
May 6, 2010 By 3 Comments
…memory Innodb will require for its data dictionary depends on amount of tables you have as well as number of fields and indexes. Innodb…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… of the MySQL Query Cache – it is great. The transparent cache which does not require any … “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances …Storage Engines MySQL Query Cache now stores queries in local memory, which is great however memory amount might …
