by Rich.Prohaska | Apr 8, 2014 | MySQL
The ‘uint3korr’ function inside of the mysqld server extracts a 3 byte unsigned integer from a memory buffer. One use is for ‘mediumint’ columns which encode their value in 3 bytes. MySQL 5.6 and MariaDB 10.0 claims to have optimized this...
by Tim.Callaghan | Apr 4, 2014 | MySQL
The MySQL community continues to amaze me, everyone is friendly and always willing to answer questions and help others. It’s always nice to meet people in-person that I’ve met virtually in the last 12 months. Percona Live 2014 MySQL Conference and Expo in Santa Clara...
by Rich.Prohaska | Apr 3, 2014 | MySQL
A TokuDB MySQL test run with valgrind reported an uninitialized data error when writing into the TokuDB recovery log. ==1032== Syscall param write(buf) points to uninitialised byte(s) ==1032== at 0x3EFA60E4ED: ??? (in /lib64/libpthread-2.12.so) ==1032== by 0xB894038:...
by Rich.Prohaska | Mar 27, 2014 | MySQL
We have seen TokuDB lock escalation stall the execution of SQL operations for tens of seconds. To address this problem, we changed the lock escalation algorithm used by TokuDB and TokuMX so that the cost of lock escalation only affects big transactions. We also...
by Zardosht.Kasheff | Mar 18, 2014 | MySQL
At an extremely high level, replication in MongoDB and MySQL are similar. Both databases have exactly one machine, the primary (or master), that accepts writes from clients. With a single transaction (or atomic operation, in MongoDB’s case), the tables and oplog (or...
by Rich.Prohaska | Mar 17, 2014 | MySQL
What good is a zero-length character column in a MySQL table? A zero-length character column has type of ‘char(0)’. If it is nullable, then it can at least store one bit. If it is not nullable, then the value for this column in all rows is a null string....
by Dave Rosenlund | Mar 13, 2014 | MySQL
You may think that you have to buy, install, and get up to speed on a new database if you want to work with large amounts of data, but you can do more than you think with the MySQL you already have. Register Now! SPEAKER: Jon Tobin, Tokutek DATE: Thursday, March 20th...
by Tim.Callaghan | Mar 12, 2014 | MySQL
Yesterday we released TokuDB v7.1.5, which includes the following important features and fixes: Upgraded MySQL and MariaDB to version 5.5.36. Six months of performance improvements to our underlying Fractal Tree indexing. Fixes for bugs, stalls, and behavioral issues...
by Bill Karwin | Mar 7, 2014 | Insight for Developers, MySQL, Webinars
On Wednesday I gave a presentation on “How to Avoid Common (but Deadly) MySQL Development Mistakes” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who...
by Tim.Callaghan | Mar 5, 2014 | MySQL
I’ve been a little behind in recent blogging efforts, and realized that in less than a month we’ll be back at Percona Live: MySQL Conference and Expo 2014, aka PLMCE. Last year’s PLMCE was my first, as well as the event where Tokutek announced the...
by Raghavendra | Feb 21, 2014 | MySQL, Percona Software
I spoke last month at linux.conf.au 2014 in Perth, Australia, and one of my sessions focused on the “Continuous Integration (CI) testing of Percona XtraDB Cluster (PXC)” at the Developer,Testing, Release and CI miniconf. Here is the video of the...
by Bill Karwin | Feb 12, 2014 | Insight for DBAs, Webinars
January 22 I gave a presentation on “How to Avoid Common (but Deadly) MySQL Operations Mistakes” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to...
by Zardosht.Kasheff | Feb 3, 2014 | MySQL
William Zola over at MongoDB gave a great talk called “The (Only) Three Reasons for Slow MongoDB Performance”. It reminded me of an interesting characteristic of updates in MongoDB. Because MongoDB’s main data store is a flat file and secondary indexes store offsets...
by Dave Rosenlund | Jan 21, 2014 | MySQL
You love MySQL and MariaDB for its ease of deployment, but what if you could increase performance and save significant time and money when your application starts to scale without having to change your applications? Register Now! SPEAKER: Tim Callaghan, VP of...
by Yves Trudeau | Jan 20, 2014 | Insight for DBAs, MySQL
Over the last few days, I integrated the MySQL 5.6 GTID version of the Percona Replication Manager (PRM) work of Frédéric Descamps, a colleague at Percona. The agent supports the GTID replication mode of MySQL 5.6 and if the master suffers a hard crash, it picks the...
by Bill Karwin | Jan 13, 2014 | Insight for DBAs, Insight for Developers, Webinars
On January 22 I’ll be presenting the first of a series of two new webinars focusing on avoiding common MySQL mistakes: How to Avoid Common (but Deadly) MySQL Operations Mistakes. “Don’t bother me with DBA ‘best practices,’ we have real work to get done.” So go...
by Yves Trudeau | Jan 10, 2014 | Insight for DBAs, MySQL, Percona Software
Most technologies achieving high-availability for MySQL need a load-balancer to spread the client connections to a valid database host, even the Tungsten special connector can be seen as a sophisticated load-balancer. People often use hardware load balancer or...
by Akshay Suryawanshi | Dec 24, 2013 | Insight for DBAs, MySQL
One of the routine tasks for a DBA is MySQL renaming database schemas, and as such MySQL added a command to carry out that purpose called “RENAME DATABASE <database_name>”. However, this command just made it through a few minor releases before being...
by Jay Janssen | Dec 19, 2013 | MySQL
A decade ago MySQL folks were in love with the concept of a relay slave for MySQL high availability across data centers. A relay is a single slave in a remote data center that receives replication from the global master and, in turn, replicates to all the other local...
by Dave Rosenlund | Dec 10, 2013 | MySQL
Use your MySQL expertise to analyze the strengths and weaknesses of MongoDB. SPEAKER: Tim Callaghan, VP of Engineering at Tokutek DATE: Tuesday, December 17th TIME: 1pm ET Register Now! MongoDB is a popular NoSQL DBMS that shares the ease-of-use and quick setup that...
