Buy Percona ServicesBuy Now!

Sharing an auto_increment value across multiple MySQL tables

 | October 4, 2010 |  Posted In: Benchmarks, Insight for Developers, MySQL

The title is SEO bait – you can’t do it. We’ve seen a few recurring patterns trying to achieve similar – and I thought I would share with you my favorite two: Option #1: Use a table to insert into, and grab the insert_id:

Option #2: Use a table with one just row:

Read More

Loading Tables with TokuDB 4.0

 | September 2, 2010 |  Posted In: Tokutek, TokuView

Often, the first step in evaluating and deploying a database is to load an existing dataset into the database. In the latest version, TokuDB makes use of multi-core parallelism to speed up loading (and new index creation). Using the loader, MySQL tables using TokuDB load 5x-8x faster than with previous versions of TokuDB. Measuring Load […]

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

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

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

TokuDB speeds up “replace” and “insert ignore” operations by relaxing the affected rows constraint

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

In posts on June 30 and July 6, we 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, we hinted at that there are some caveats that complicate the story […]

Read More

MariaDB and the MySQL Sandbox

 | July 26, 2010 |  Posted In: Tokutek, TokuView

Tokutek tests its TokuDB Fractal Tree storage engine with multiple MySQL distributions. We make extensive use of the MySQL Sandbox in our test automation. We tweaked the regular expressions that match binary tarball names in the MySQL Sandbox so that MariaDB releases can be easily loaded by the MySQL Sandbox. These changes can be found […]

Read More