Monthly Archives - March 2013

MySQL 5.6 – InnoDB Memcached Plugin as a caching layer

A common practice to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects.  Some typical use cases include:

Complicated query result set (search results, recent users, recent posts, etc)
Full page output (relatively static pages)
Full objects (user or cart object built from several queries)
Infrequently changing data (configurations, […]

Read more

TokuDB Fast Update Benchmark

Last month my colleague Rich Prohaska covered the technical details of our “Fast Update” feature which we added to TokuDB in version 6.6.  The message based architecture of Fractal Tree Indexes allows us to defer certain operations while still maintaining the semantics that MySQL users require.
In the case of Fast Updates, TokuDB is avoiding the read-before-write […]

Read more

Network at the Percona Live MySQL Conference and Expo

We’re very pleased with the speaker lineup for the Percona Live MySQL Conference and Expo. We have outstanding MySQL experts speaking on a variety of topics during the breakout sessions and tutorials. And the keynote speakers are all top notch, MySQL technology and industry experts who will share their views of the ecosystem.
Beyond the […]

Read more

Why MySQL Performance at Low Concurrency is Important

A few weeks ago I wrote about “MySQL Performance at High Concurrency” and why it is important, which was followed up by Vadim’s post on ThreadPool in Percona Server providing some great illustration on the topic. This time I want to target an opposite question: why MySQL performance at low concurrency is important for […]

Read more

Repair MySQL 5.6 GTID replication by injecting empty transactions

mysql 5.6 gtid replication

In a previous post I explained Injecting empty transactions. Let’s imagine that the replication in slave server is not working because of an error:

Shell

Last_SQL_Error: Error ‘Duplicate entry ‘4’ for key ‘PRIMARY” on query. Default database: ‘test’. Query: ‘insert into t VALUES(NULL,’salazar’)’
Retrieved_Gtid_Set: 7d72f9b4-8577-11e2-a3d7-080027635ef5:1-5
Executed_Gtid_Set: 7d72f9b4-8577-11e2-a3d7-080027635ef5:1-4

123

Last_SQL_Error: Error ‘Duplicate entry ‘4’ for key ‘PRIMARY” on query. Default database: […]

Read more