DeNA developer Akira Higuchis’s HandlerSocket plugin adds NoSQL functionality to MySQL for handling tasks such as primary key lookups without caching. HandlerSocket runs as a daemon within MySQL mysqld process to simple CRUD operations on tables.
(Link: Add NoSQL Capabilities to MySQL With the HandlerSocket Plugin – ReadWriteCloud)
Archive | mysql RSS feed for this section
Add NoSQL Capabilities to MySQL With the HandlerSocket Plugin – ReadWriteCloud
December 16, 2010
0 Comments
Yoshinori Matsunobu's blog: Using MySQL as a NoSQL – A story for exceeding 750,000 qps on a commodity server
October 21, 2010
0 Comments
Most of high scale web applications use MySQL + memcached. Many of them use also NoSQL like TokyoCabinet/Tyrant. In some cases people have dropped MySQL and have shifted to NoSQL. One of the biggest reasons for such a movement is that it is said that NoSQL performs better than MySQL for simple access patterns such as primary key lookups. Most of queries from web applications are simple so this seems like a reasonable decision.
(Link: Yoshinori Matsunobu’s blog: Using MySQL as a NoSQL – A story for exceeding 750,000 qps on a commodity server)
MySQL Limitations Part 1: Single-Threaded Replication | MySQL Performance Blog
October 20, 2010
1 Comment
I decided to write a series of blog posts on MySQL’s unsolved severe limitations. I mean limitations that really hobble it for major, important needs — not in areas where it isn’t used, but in areas where it is used and thus is used very wastefully compared to its potential.
(Link: MySQL Limitations Part 1: Single-Threaded Replication | MySQL Performance Blog)
Boosting performance with MySQL partitions (Presentation)
September 20, 2010
0 Comments
Partition pruning
Benchmarking
leveraging replication
tips
hands on
tools
Syntax
Partitioning by date
(Link: Boosting performance with MySQL partitions (Presentation))
Request-log-analyzer – command line tool to analyze request log files in various formats to produce a performance report.
September 11, 2010
0 Comments
Analyzes log files. Currently supports: Amazon S3, Apache, Delayed::Job, Merb, Mysql, PostgreSQL, Rack, Rails and more.
Combines multiple files and decompresses compressed files, which comes in handy if you are using logrotate.
Uses several metrics, including cumulative request time, mean request time, process blockers, database and rendering time, HTTP methods and statuses, Rails action cache statistics, etc.
(Link: Request-log-analyzer – command line tool to analyze request log files in various formats to produce a performance report.)
MySQL Diehard vs. NoSQL Fanboi: The Animated Movie
September 7, 2010
0 Comments
The debate is often charged between MySQL proponents and those who are increasingly excited about NoSQL.
So, it’s good to see a bit of levity enter the discussion. Every once in a while we need to sit back and not take ourselves too seriously.
(Link: MySQL Diehard vs. NoSQL Fanboi: The Animated Movie)
FAQ | MySQLTuner
August 6, 2010
0 Comments
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved.
(Link: FAQ | MySQLTuner)
Nuts & Bolts: Database Servers
July 27, 2010
0 Comments
We only use RAID controllers that have a battery backup for the cache, disable read-ahead caching, and turn on write-back caching. With this setup we’re able to configure MySQL to immediately flush all writes to the disk rather than relying on the operating system to periodically write the data to the drives. In reality, the writes will be staged to the controller’s cache, but with the battery backup we are protected from unexpected power outages which could otherwise cause data loss. In addition, since the controller is caching the writes in memory, it can optimize the order and number of writes that it makes to the physical disks to dramatically improve performance.
(Link: Nuts & Bolts: Database Servers)
Introducing Ambitious Query Indexer – A new way to index your Rails app’s database – Sam’s World Of No by Sam Phillips
June 16, 2010
0 Comments
Ambitious Query Indexer is an index generating plugin by Sam Phillips (@samsworldofno). Like Rails Indexes, it generates a migration containing suggested indexes, but it works by analyzing all of the queries it can find in your app.
(Link: Introducing Ambitious Query Indexer – A new way to index your Rails app’s database – Sam’s World Of No by Sam Phillips)
Percona MySQL XtraBackup Tool
March 25, 2010
0 Comments
Percona XtraBackup is OpenSource online (non-blockable) backup solution for InnoDB and XtraDB engines. It works with MySQL 5.0 and 5.1 versions (InnoDB Plugin and Barracuda format is supported as of release 0.9.5rc) and also can handle MyISAM tables. XtraBackup is distributed under GPL v2 license.
(Link: Percona MySQL XtraBackup Tool)
