Buy Percona ServicesBuy Now!

Introducing tcprstat, a TCP response time tool

 | August 31, 2010 |  Posted In: MySQL, Percona Software

Ignacio Nin and I (mostly Ignacio) have worked together to create tcprstat[1], a new tool that times TCP requests and prints out statistics on them. The output looks somewhat like vmstat or iostat, but we’ve chosen the statistics carefully so you can compute meaningful things about your TCP traffic. What is this good for? In […]

Read More

Loading Air Traffic Control Data with TokuDB 4.1.1

 | August 27, 2010 |  Posted In: Tokutek, TokuView

TokuDB has a big advantage over B-trees when trickle loading data into existing tables. However, it is possible to preprocess the data when bulk loading into empty tables or when new indexes are created. TokuDB release 4 now uses a parallel algorithm to speed up these types of bulk insertions. How does the parallel loader […]

Read More

InnoDB memory allocation, ulimit, and OpenSUSE

 | August 23, 2010 |  Posted In: Insight for DBAs, MySQL

I recently encountered an interesting case. A customer reported that mysqld crashed on start on OpenSUSE 11.2 kernel x86_64   with 96 GB RAM when the innodb_buffer_pool_size was set to anything more than 62 GB. I decided to try it with 76 GB. The error message was an assert due to a failed malloc() […]

Read More

Announcing TokuDB v4.1.1

 | August 19, 2010 |  Posted In: Tokutek, TokuView

Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 4.1.1. It is ideally suited for delivering fast response times for complex / high-volume Web applications that must simultaneously store and query large volumes of rapidly arriving data: Social Networking Real-time clickstream analysis Logfile Analysis eCommerce Personalization High-speed Webcrawling TokuDB v4.1.1 replaces TokuDB […]

Read More

Percona talks at OpenSQL Camp this weekend

 | August 19, 2010 |  Posted In: Events and Announcements, MySQL

Four Perconians (perconites?) will be at OpenSQL Camp in Sankt Augustin, Germany this weekend presenting talks on: Recovery of Lost or Corrupted InnoDB Tables Keep your MySQL backend online no matter what XtraDB — InnoDB on steroids Xtrabackup for MySQL If you would like to stop by and say hello, we are Aleksandr, Istvan, Morgan […]

Read More

Testing MySQL column stores

 | August 16, 2010 |  Posted In: MySQL

Recently I had the opportunity to do some testing on a large data set against two MySQL column-store storage engines. I’d like to note that this effort was sponsored by Infobright, but this analysis reflects my independent testing from an objective viewpoint. I performed two different types of testing. The first focused on core functionality […]

Read More

Announcing TokuDB v4.1

 | August 15, 2010 |  Posted In: Tokutek, TokuView

Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 4.1. It is designed for continuous querying and analysis of large volumes of rapidly arriving and changing data, while maintaining full ACID properties. New in TokuDB v4.1 includes important improvements, most notably support for SAVEPOINT and improved Fast Loader performance (introduced in v4.0). […]

Read More

On “Replace Into”, “Insert Ignore”, Triggers, and Row Based Replication

 | August 11, 2010 |  Posted In: Tokutek, TokuView

In posts on June 30 and July 6, I explained how implementing the commands “replace into” and “insert ignore” with TokuDB’s fractal trees data structures can be two orders of magnitude faster than implementing them with B-trees. Towards the end of each post, I hinted at that there are some caveats that complicate the story […]

Read More