Percona just announced that they’re going to include HandlerSocket in the latest Percona build. This is huge news. In case you aren’t aware, HandlerSocket is a raw protocol interface that is similar to a dictionary lookup (kind of like memcached, or a hashtable) and does NOT go through the SQL parser. The performance implications are [...]
Categories: mysql
Tagged: mysql
I spend the last couple days playing with InnoDB page compression on the latest Percona build. I’m pretty happy so far with Percona and the latest InnoDB changes. Compression wasn’t living up to my expectations though. I think the biggest problem is that the compression can only use one core in replication and ALTER TABLE [...]
It seems to be impossible to perform client-side paging full table scans within MySQL. For example, say you want to take a 1GB file and page through it 10MB at a time. With a flat file I could just read 10MB off disk, read the next 10MB, etc. This would be amazingly efficient as you [...]
Categories: mysql
Spinn3r will be hosting an Open MySQL meetup at Oracle Open World (which is right down the street). This would be on Wed 10/14 2009 at 7pm … at 580 Howard Suite 301 (Spinn3r HQ) Oracle owns MySQL, InnoDB, etc so I suspect a lot of Oracle people and MySQL hackers will be interested in [...]
Categories: mysql
Has anyone done any more work on recompiling InnoDB with 4k pages and benchmarking under SSD? We’re building out a new DB that uses very small records (around 32-64 bytes) so reading a whole 16k for this record should have a performance difference. I haven’t seen any benchmarks on 16k random read IOPS on the [...]
We’re looking to hire a Senior MySQL DBA over at Spinn3r. You should obviously have MySQL experience. Love SQL, hate data corruption and slow queries, and preferably live in San Francisco. Linux experience would be nice as well but not required. Extra points if you are excited about SSD, *huge* amounts of data, have hacked [...]
Categories: mysql
Here’s the problem I currently have. We’re looking at deploying the Intel X-25M MLC SSD in production. The problem being that this drive has a lower number of erase cycles but is much cheaper. Than the Intel X-25E SLC drive. However, in our situation we’re write once, read many. I’m 99% certain that we will [...]
Spinn3r is growing fast. Time to hire another engineer. Actually, we’re hiring for like four people right now so I’ll probably be blogging more on this topic. My older post on this subject still applies for requirements. If you’re a Linux or MySQL geek we’d love to have your help. Did I mention we just [...]
One of the things that has always bothered me about replication is that the binary logs are written to disk and then read from disk. There is are two threads which are for the most part, unaware of each other. One thread reads the remote binary logs, and the other writes them to disk. While [...]
This might be a bit cutting edge, but the new fallocate() call in > Linux 2.6.23 might be able to improve InnoDB performance. When InnoDB needs more space it auto-extends the current data file by 8MB. If this is writing out zeros to the new data (to initialize it) then using fallocate() would certainly be [...]