…layer. While very fast, one major potential shortcoming of memcached is that it is not persistent. …MySQL 5.6 GA distribution, there is a memcached plugin included in the base plugin directory (/usr/lib64/mysql…use of HandlerSocket would require coding changes (which is why it was also left out …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… some different sets of MySQL configuration parameters. For example, given that the front-end device is a very fast PCIe SSD, would it make more sense to configure MySQL as if it were… flushing that we see some nice, predictable, constant performance. So why is it the case that vCache with time-based flushing appears…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…: TokuDB results are not quite stable, that is why I also show 5-minute moving averages …where `id` is sequential, and `hid`,`mid` is low selectivity is not good for fast inserts, but it is suitable …_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… and that will be better than HDD RAID, but why spend money to store all my data on SSD…using to write this comment on. It’s pretty fast. But it’s still significantly slower (and more CPU…a comparison in TPCC-MySQL performance between that card and a traditional SSD – the PCIe card is about 3x faster….
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…, 3). This post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with… a cache). This is generally so fast that there isn’t really the need for connection pools as there is with other databases… certain kinds of them. That’s why I listed those as major limitations. And because MySQL is a multi-threaded database for Web…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…MySQL is probably a good place to look for performance problems. Everything I’ve done up till now is… | Why is something running an admin command constantly? This is generally a Ping command, which is useless. Something is…of queries matter. Some may be extremely fast, but run very often; others may …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… what MySQL Query Cache is – I’ve seen number of people being confused, thinking MySQL Query Cache is… it is mostly read only scenario. Why Look for alternatives ? There are few reasons why Query Cache…It is not that fast Query Cache is fast compared to running the queries but it is still not as fast…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… property is different from completely transparent cache and you’ll see why below. So what I think could be done with MySQL Query Cache so it once again is appealing to improve performance for MySQL… Storage would benefit a lot from fast compression, such as QuickLZ. Results sets for most queries is highly compressible and light compression…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… plugins. Two aspects why I’m especially interested about it is Sphinx which is currently implemented as storage engine for MySQL but this role… MySQL Cluster would ever be that thing as it provides too strong guarantees. It is same as with MySQL Replication – the reason it is fast and has low performance overhead on the master is at large extent because it is…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…) Repeated runs test a buffer pool which is smaller than the data but underlying IO is fast (a warm FS cache reduces IO… you can see above, MySQL 5.6 outperformed MySQL 5.5.30 with the big buffer pool. Why is the MySQL 5.6.10 with default settings test significantly slower than MySQL…
