by Alexey Stroganov | Mar 8, 2013 | Benchmarks, MySQL
Last time I wrote about memory allocators and how they can affect MySQL performance in general. This time I would like to explore this topic from a bit different angle: What impact does the number of processor cores have on different memory allocators and what...
by Hrvoje Matijakovic | Mar 8, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server for MySQL version 5.1.67-14.4 on March 8, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.67, including all the bug fixes in it, Percona Server 5.1.67-14.4 is...
by Hrvoje Matijakovic | Mar 7, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server for MySQL 5.5.30-30.1 on March 7, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.30, including all the bug fixes in it, Percona Server 5.5.30-30.1 is now the...
by Tokutek | Mar 7, 2013 | MySQL
We had the opportunity to do a CUBE interview with Wikibon analyst Jeff Kelly at last week’s Strata Conference in Santa Clara. In the first part of our conversation, we discuss how our success in integrating Tokutek’s Fractal Tree® technology into MySQL has led us to...
by Vadim Tkachenko | Mar 6, 2013 | MySQL, Percona Software
by Peter Zaitsev | Mar 4, 2013 | MySQL, Percona Events
This Wednesday (March 6 at 10 a.m. PST) I’ll be presenting a webinar titled “MySQL 5.6: Advantages in a Nutshell.” In this presentation, I will provide a brief overview of the advantages MySQL 5.6 offers. My focus is a practical one – to...
by Ernie Souhrada | Mar 4, 2013 | Insight for DBAs, Insight for Developers, MySQL
This is part 2 in a 3 part series on InnoDB MySQL full-text searches. In part 1, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some queries and compare the result...
by Peter Zaitsev | Mar 3, 2013 | Benchmarks, Insight for DBAs, MySQL, Percona Software
by Vadim Tkachenko | Feb 28, 2013 | MySQL, Percona Software
Following Roel’s post, Percona Server on the Raspberry Pi: Your own MySQL Database Server , I thought what other crazy gadget can I run Percona Server on? And having an Asus Nexus 7 Android tablet I decided to give it a try. Anything below contains a risk that...
by Daniel Nichter | Feb 28, 2013 | Insight for DBAs, Insight for Developers, MySQL
Like Ovais said in Implications of Metadata Locking Changes in MySQL 5.5, the hot topic these days is MySQL 5.6, but there was an important metadata locking change in MySQL 5.5. As I began to dig into the Percona Toolkit bug he reported concerning this change...
by Tim.Callaghan | Feb 27, 2013 | MySQL
One doesn’t have to look far to see that there is strong interest in MongoDB compression. MongoDB has an open ticket from 2009 titled “Option to Store Data Compressed” with Fix Version/s planned but not scheduled. The ticket has a lot of comments, mostly from...
by Miguel Angel Nieto | Feb 27, 2013 | MySQL
The MySQL optimizer makes the decision of what execution plan to use based on the information provided by the storage engines. That information is not accurate in some engines like InnoDB and they are based in statistics calculations therefore sometimes some tune is...
by Ernie Souhrada | Feb 26, 2013 | Insight for DBAs, Insight for Developers, MySQL
I’ve never been a very big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was the only storage...
by Hrvoje Matijakovic | Feb 26, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server for MySQL version 5.5.29-30.0 on February 26th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.29, including all the bug fixes in it, Percona...
by Peter Zaitsev | Feb 26, 2013 | Insight for DBAs, MySQL
In many MySQL Benchmarks we can see performance compared with rather high level of concurrency. In some cases reaching 4,000 or more concurrent threads which hammer databases as quickly as possible resulting in hundreds or even thousands concurrently active queries....
by Roel Van de Paar | Feb 25, 2013 | Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL
There are many reasons for wanting a small MySQL database server: You’re a uni student who wants to learn the SQL language better and needs a mini-testbox You’re a Windows user who wants to play around with Percona Server on Linux You’re a corporate...
by Peter Zaitsev | Feb 25, 2013 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
MySQL 5.6 was made generally available as a production-ready solution earlier this month. This release comes about 2 years after MySQL 5.5 was released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb Full Text...
by Vadim Tkachenko | Feb 24, 2013 | MySQL, Percona Software
In this post I will describe a non-trivial way to authenticate users in Percona Sever for MySQL. Percona Server comes with PAM authentication plugin, which allows you to do a lot of cool things, such as: OS authentication, LDAP authentication, even RSA Secure Server...
by Daniel Nichter | Feb 22, 2013 | Insight for Developers, Percona Software
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:...
by Peter Zaitsev | Feb 21, 2013 | 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: mysql...
