EmergencyEMERGENCY? Get 24/7 Help Now!

read_buffer_size can break your replication

 | June 6, 2012 |  Posted In: MySQL

There are some variables that can affect the replication behavior and sometimes cause some big troubles. In this post I’m going to talk about read_buffer_size and how this variable together with max_allowed_packet can break your replication. The setup is a master-master replication with the following values: max_allowed_packet = 32M read_buffer_size = 100M To break the […]

Read More

Open Database Camp at SouthEast LinuxFest 2012

 | June 5, 2012 |  Posted In: Tokutek, TokuView

I’ll be attending this year’s US based Open Database Camp from June 8-10 in Charlotte, NC. The conference is co-located with SouthEast LinuxFest 2012. It appears that OpenSQL Camp was renamed Open Database Camp since I see many database technologies listed on their site that do not use SQL as an access method. The final […]

Read More

The Sound and the NoSQL Fury

 | June 4, 2012 |  Posted In: Tokutek, TokuView

The signal-to-noise ratio in the NoSQL world has made it hard to figure out what’s going on, or even who has something new. For all the talk of performance in the NoSQL world, much of the most exciting part of what’s new is really not about performance at all. Take for example, MongoDB, which has […]

Read More

thread_concurrency doesn’t do what you expect

 | June 4, 2012 |  Posted In: MySQL

Over the last months I’ve seen lots of customers trying to tune the thread concurrency inside MySQL with the variable thread_concurrency. Our advice is: stop wasting your time, it does nothing on GNU/Linux 🙂 Some of the biggest GNU/Linux distributions includes the variable thread_concurrency in their my.cnf file by default. One example is Debian and […]

Read More

How expensive is USER_STATISTICS?

 | June 2, 2012 |  Posted In: Benchmarks, Insight for DBAs, MySQL, Percona Software

One of our customers asked me whether it’s safe to enable the so-called USER_STATISTICS features of Percona Server in a heavy-use production server with many tens of thousands of tables. If you’re not familiar with this feature, it creates some new INFORMATION_SCHEMA tables that add counters for activity on users, hosts, tables, indexes, and more. […]

Read More

Review of the Tutorial on Algorithms for Memory Sensitive Computing at STOC

 | June 1, 2012 |  Posted In: Tokutek, TokuView

Martin Farach-Colton and I ran a Tutorial on Algorithms for Memory Sensitive Computing on May 18th at the 44th ACM Symposium on Theory of Computing (STOC) at NYU. Here is the program for the tutorial. Erik Demaine (MIT) spoke on the History of I/O Models. Throughout the years, a remarkable variety of computational models have been proposed to explain the effects of caching, […]

Read More

Announcing Percona Server 5.5.24-26.0

 | June 1, 2012 |  Posted In: MySQL, Percona Software

Percona is glad to announce the release of Percona Server 5.5.24-26.0 on June 1st, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.24, including all the bug fixes in it, Percona Server 5.5.24-26.0 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can […]

Read More