EmergencyEMERGENCY? Get 24/7 Help Now!

CentOS 5.8 users: your UTF-8 data is in peril with Perl MySQL

 | February 22, 2013 |  Posted In: Insight for Developers, Percona Toolkit

CentOS 5.8 and earlier use Perl module DBD::mysql v3.0007 which has a bug that causes Perl not to flag UTF-8 data as being UTF-8.  Presuming that the MySQL table/column is using UTF-8, and the Perl MySQL connection is also using UTF-8, then a correct system returns: PV = 0x9573840 "\343\203\213 \303\250"\0 [UTF8 "\x{30cb} \x{e8}"] That’s a Devel::Peek inside a Perl scalar variable which […]

Read More

MySQL 5.5 and MySQL 5.6 default variable values differences

 | February 21, 2013 |  Posted In: Insight for DBAs, MySQL

As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to default variable values. To do that I’ve loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query:

Lets go over to see what are the most important changes […]

Read More

Solving RPM installation conflicts in CentOS 5 and CentOS 6

 | February 21, 2013 |  Posted In: MySQL

Lately we’ve had many reports of the RPM packages for CentOS 5 (mostly) and CentOS 6 having issues when installing different combinations of our products, particularly with Percona Toolkit for MySQL. Examples of bugs related to these issues are lp:1031427 and lp:1051874. These problems arise when trying to install a package from the distribution that […]

Read More

NoSQL is Great, But You Still Need Indexes

 | February 20, 2013 |  Posted In: Tokutek, TokuView

I’ve said it before, and, as is the nature of these things, I’ll almost certainly say it again: your database performance is only as good as your indexes. That’s the grand thesis, so what does that mean? In any DB system — SQL, NoSQL, NewSQL, PostSQL, … — data gets ingested and organized. And the […]

Read More

Analyzing Slow Query Table in MySQL 5.6

 | February 18, 2013 |  Posted In: Events and Announcements, Insight for DBAs, MySQL, Percona Toolkit

Next week I’m teaching an online Percona Training class, called Analyzing SQL Queries with Percona Toolkit.  This is a guided tour of best practices for pt-query-digest, the best tool for evaluating where your database response time is being spent. This month we saw the GA release of MySQL 5.6, and I wanted to check if any […]

Read More

Percona MySQL University comes to Toronto on March 22

 | February 18, 2013 |  Posted In: Events and Announcements, MySQL

Following our events in Raleigh, Montevideo, Buenos Aires, Percona MySQL University comes to Toronto on March 22nd. This is going to our most dense event yet, absolutely packed with information. Even though we have just 1 track we have 12 talks and 11 speakers. We had unique opportunity this time because Percona’s Consulting, Support, RemoteDBA, […]

Read More

Is MySQL 5.6 slower than MySQL 5.5?

 | February 18, 2013 |  Posted In: MySQL

There have been a number reports/benchmarks showing MySQL 5.6 to be slower than MySQL 5.5 on variety of workloads. There are many possible reasons and I believe we will learn about many of them in the next few weeks and months as MySQL 5.6 is starting to get production battle-tested and there is inflow of […]

Read More

Using MySQL Sandbox with Percona Server

 | February 16, 2013 |  Posted In: MySQL

One of the most useful tools if you’re working with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL, Percona Server, MariaDB. If you’re just working with single sandbox you can just use MySQL Sandbox in its most basic way and it will work:

However […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.