… which appeared in MySQL 4.0 Query Cache was designed to work with single core systems and relatively small memory amounts, both…. Query Cache Storage Engines MySQL Query Cache now stores queries in local memory, which is great however memory amount might be limited especially… API which would allow one to use local memory, Memcache or for example local flash storage for storage. Compression You can see…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
… to know how MySQL scales as you add more memory to the server. Vadim recently benchmarked the effects of increasing memory and CPU… Virident, is that as you add CPUs and increase memory size, MySQL doesn’t scale as well as we would like, and…. You can read the full details in our Scaling MySQL With Virident Flash Drives and Multiple Instances of Percona Server white paper…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…. The wear leveling is used for flash memories. I looked up some information on the web about flash memories, and noticed that random writes…, like log flushes. A question is why to use a flash memory at all, when a battery-backed disk controller write-back… these non-mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql server for…
Post: Level 2 Flash cache is there
April 27, 2010 By 5 Comments
… two years already. It is also described in ACM article “Flash storage memory” by Adam Leventhal. So I am exciting to see… Mohan Srinivasan from Facebook released Flashcache, which allows to use Flash as cache in front of regular hard drives. The implementation….google.com/p/david-mysql-tools/wiki/innodb_secondary_buffer_pool, it allows to use a file on Flash partitions as L2…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 7 Comments
…problems and its impact to MySQL Performance. Here are couple of links… : 76 C/ 168 F (Normal) Installed memory : 512 MB Copyback : Disabled Background consistency…) Driver : 1.1-5 (24702) Boot Flash : 5.2-0 (18252) ——————————————————– Controller ZMM Information…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… doing a very good job on systems based on SSD/Flash storage, but it is not so good for regular slow… with all the changes you do in memory. Here is a graph for the tpcc-mysql benchmark (100W ~ 10GB of data, 12G… time (minutes). This comes from the fact that MySQL performs changes in memory at a faster rate than it can write to…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… ? If we’re speaking about purely disk based SAN (no Flash) the drives are same drives you will see in directly… read caching more efficient in its memory while write buffering can too be done by MySQL and local RAID (with BBU) quite… should also evaluate external directly attached storage, SSDs, Increasing system memory as well as sharding and replication as a scaling solutions.
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… a tpcc-mysql workload with 1000W (around 100GB of data). This combination of buffer pool sizes gives us different data/memory ratios… 144G – the data all fits into memory). For the cases when the data fits into memory, it is especially important to have… the difference between different settings of innodb_io_capacity for MySQL 5.5.8. Small innodb_io_capacity values are really…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…CPU X5650 @ 2.67GHz Caches | 24×12288 KB # Memory ##################################################### Total | 23.59G … Locator Size Speed…alignment, not different MySQL configurations, I didn’t try out different MySQL versions or …plan to look at IO alignment on Flash cards to see what benefits …
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 16 Comments
… needs high insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM… better RAID or Flash) which is a very cool number. Of course, mind you this is in memory insertion in the simple…_pool_instances=8 was very important. Second thing – Partitioning. Unfortunately MySQL 5.5 leaves the huge bottleneck for write workloads in…
