You are here

MySQL Performance Blog

MySQL Performance Blog
Checked: 3 years 8 months ago
Updated: 3 years 8 months ago
Update every: 2 hours

Percona's Data performance and scalability blog
Subscribe to MySQL Performance Blog

Is 80% of RAM how you should tune your innodb_buffer_pool_size?

MySQL Performance Blog - Tue, 02/06/2015 - 10:00am

It seems these days if anyone knows anything about tuning InnoDB, it’s that you MUST tune your innodb_buffer_pool_size to 80% of your physical memory. This is such prolific tuning advice, it seems engrained in many a DBA’s mind.  The MySQL manual to this day refers to this rule, so who can blame the DBA?  The […]

Percona TokuMXse 3.0.3-1.0-rc6 is now available

MySQL Performance Blog - Mon, 01/06/2015 - 5:54pm

Percona is glad to announce the release of Percona TokuMXse 3.0.3-1.0rc6 on June 1st 2015. TokuMXse is a TokuMX storage engine for MongoDB 3.0.3. Downloads are available from our download site here. Packages for this Release Candidate release, will be available in our Ubuntu Trusty testing and CentOS 7 testing repositories. Based on MongoDB 3.0.3, […]

New PERFORMANCE_SCHEMA defaults in MySQL 5.7.7

MySQL Performance Blog - Mon, 01/06/2015 - 2:27pm

I thought it was worth a moment to reiterate on the new Performance Schema related defaults that MySQL 5.7.7 brings to the table, for various reasons. For one, most of you might have noticed that profiling was marked as deprecated in MySQL 5.6.7. So it is expected that you invest into learning more about Performance […]

MongoDB Community Open House: June 1 in NYC

MySQL Performance Blog - Thu, 28/05/2015 - 1:13pm

If you can make it to Manhattan next Monday, please join me at the MongoDB Community Open House. The June 1 event is free and open to all. It runs from 3:30-6:30 p.m. just across the road from MongoDB World. The MongoDB Community Open House, held at the New York Hilton Midtown, will feature technical […]

The post MongoDB Community Open House: June 1 in NYC appeared first on MySQL Performance Blog.

Percona XtraBackup 2.2.11 is now available

MySQL Performance Blog - Thu, 28/05/2015 - 7:59am

Percona is glad to announce the release of Percona XtraBackup 2.2.11 on May 28, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered […]

MySQL 5.7 key features

MySQL Performance Blog - Wed, 27/05/2015 - 7:00am

The other day I was discussing new features of MySQL 5.7 with a Percona Support customer. After that conversation, I thought it would be a good idea to compile list of important features of MySQL 5.7. The latest MySQL 5.7.6 release candidate (RC) is out and is packed with nice features. Here’s a list of […]

The post MySQL 5.7 key features appeared first on MySQL Performance Blog.

Storing time-series data with MongoDB and TokuMX

MySQL Performance Blog - Tue, 26/05/2015 - 2:12pm

Storing time-series data is a frequent pattern for databases – be it for logs or for any kind of monitoring. Such data has the following properties: records are inserted but also never updated, the insertion rate can be high and records are likely to expire after some time. MongoDB and TokuMX are both good fits […]

MongoDB / TokuMX plugin for LinkBench (Part 1)

MySQL Performance Blog - Fri, 22/05/2015 - 6:31pm

“There’s no benchmark for how life’s “supposed” to happen. There is no ideal world for you to wait around for. The world is always just what it is now, it’s up to you how you respond to it.” ― Isaac Marion, Warm Bodies At one time or another, most of us have heard some version […]

The post MongoDB / TokuMX plugin for LinkBench (Part 1) appeared first on MySQL Performance Blog.

Percona XtraBackup 2.3.1-beta1 is now available

MySQL Performance Blog - Wed, 20/05/2015 - 6:10pm

Percona is glad to announce the release of Percona XtraBackup 2.3.1-beta1 on May 20th 2015. Downloads are available from our download site here. This BETA release, will be available in Debian testing and CentOS testing repositories. This is an BETA quality release and it is not intended for production. If you want a high quality, […]

Like my MySQL QA series? Here’s how to record your own!

MySQL Performance Blog - Tue, 19/05/2015 - 1:55pm

Whilst not directly related to MySQL, it may be helpful to post (and open source at the same time) the HD screen recording/screencast template I’ve been using to create the MySQL QA series. If you’ve never recorded a screencast before, or if you’d like to improve your screen recordings, this short blog post will get […]

Percona security update: oCERT and SSL improvements

MySQL Performance Blog - Mon, 18/05/2015 - 5:56pm

We have recently become a member of oCERT to aid in allowing responsible disclosure for Percona products and services as can be seen on their members page. We are presently working on the verbiage for the responsible disclosure program, and we are also investigating establishing a bug bounty program. In the mean time you can […]

MySQL QA Episode 2: Build a MySQL server – Git, Bazaar, compiling & build tools

MySQL Performance Blog - Fri, 15/05/2015 - 7:00am

Welcome to MySQL QA Episode 2: Build a MySQL Server – Git, Bazaar (bzr), Compiling, and Build Tools In this episode you’ll learn how to build Percona Server and/or MySQL Server for QA purposes & more in this short 25 minute tutorial. In HD quality (set your player to 720p!) To watch the other episodes […]

How Percona Support handles bugs

MySQL Performance Blog - Mon, 11/05/2015 - 10:00am

One of the great values of a Percona Support contract is that we provide bug fixes for covered software, and not just support in terms of advice on how to use it. This is the skill which is most likely missing from in-house for most customers, as it requires a team with code knowledge to […]

The post How Percona Support handles bugs appeared first on MySQL Performance Blog.

Percona Server 5.6.24-72.2 is now available

MySQL Performance Blog - Fri, 08/05/2015 - 8:55pm

Percona is glad to announce the release of Percona Server 5.6.24-72.2 on May 8, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.24, including all the bug fixes in it, Percona Server 5.6.24-72.2 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source […]

Percona Server 5.5.43-37.2 is now available

MySQL Performance Blog - Fri, 08/05/2015 - 8:55pm

Percona is glad to announce the release of Percona Server 5.5.43-37.2 on May 8, 2015. Based on MySQL 5.5.43, including all the bug fixes in it, Percona Server 5.5.43-37.2 is now the current stable release in the 5.5 series. Percona Server is open-source and free. Details of the release can be found in the 5.5.43-37.2 […]

MongoDB with Percona TokuMXse – experimental build RC5 is available!

MySQL Performance Blog - Fri, 08/05/2015 - 4:43pm

While our engineering team is working on finalizing the TokuMXse storage engine, I want to provide an experimental build that you can try and test MongoDB 3.0 with our storage engine. It is available here percona.com/downloads/TESTING/Percona-TokuMXse-rc5/percona-tokumxse-3.0.3pre-rc5.tar.gz To start MongoDB with TokuMXse storage engine use: [crayon-554cf9c98e1a9780105667/] I am looking for your feedback!

MySQL indexing 101: a challenging single-table query

MySQL Performance Blog - Fri, 08/05/2015 - 7:00am

We discussed in an earlier post how to design indexes for many types of queries using a single table. Here is a real-world example of the challenges you will face when trying to optimize queries: two similar queries, but one is performing a full table scan while the other one is using the index we […]

Introducing email reports for Percona Cloud Tools!

MySQL Performance Blog - Thu, 07/05/2015 - 10:00am

For those PCT users who forget to regularly check query performance, you can now get server query reports delivered to your email daily or weekly. The report contains a digest of the most critical performance information related to a particular MySQL instance, enabling you to act on any recent issues. There are convenient links that […]

Percona Security Advisory CVE-2015-1027

MySQL Performance Blog - Wed, 06/05/2015 - 2:52pm

Contents Summary Analysis Mitigating factors P.O.C Acknowledgments Summary During a code audit performed internally at Percona, we discovered a viable information disclosure attack when coupled with a MITM attack in which percona-toolkit and xtrabackup perl components could be coerced into returning additional MySQL configuration information. The vulnerability has since been closed. Timeline 2014-12-16 Initial research, […]

Peter Zaitsev hits the road for East Coast MySQL Meetup tour

MySQL Performance Blog - Wed, 06/05/2015 - 10:00am

Percona CEO Peter Zaitsev and Big Data guru Alexander Rubin will be speaking at Meetups along the East Coast next week with stops in Boston (May 11), New York City (May 12), Philadelphia (May 13) and Baltimore (May 14). Dubbed the “MySQL Whistle-Stop Tour” since they’ll be traveling city to city via Amtrak, Peter will […]

MongoDB’s flexible schema: How to fix write amplification

MySQL Performance Blog - Tue, 05/05/2015 - 3:56pm

Being schemaless is one of the key features of MongoDB. On the bright side this allows developers to easily modify the schema of their collections without waiting for the database to be ready to accept a new schema. However schemaless is not free and one of the drawbacks is write amplification. Let’s focus on that […]

Keep your MySQL data in sync when using Tungsten Replicator

MySQL Performance Blog - Mon, 04/05/2015 - 10:00am

MySQL replication isn’t perfect and sometimes our data gets out of sync, either by a failure in replication or human intervention. We are all familiar with Percona Toolkit’s pt-table-checksum and pt-table-sync to help us check and fix data inconsistencies – but imagine the following scenario where we mix regular replication with the Tungsten Replicator: We […]

LinkBenchX: benchmark based on arrival request rate

MySQL Performance Blog - Fri, 01/05/2015 - 7:00am

An idea for a benchmark based on the “arrival request” rate that I wrote about in a post headlined “Introducing new type of benchmark” back in 2012 was implemented in Sysbench. However, Sysbench provides only a simple workload, so to be able to compare InnoDB with TokuDB, and later MongoDB with Percona TokuMX, I wanted […]

Optimizer hints in MySQL 5.7.7 – The missed manual

MySQL Performance Blog - Thu, 30/04/2015 - 7:00am

In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about the hints. The only note which I found in the user manual about the hints is: It is now possible to provide hints to the optimizer by including /*+ ... */ comments following the SELECT, […]

Optimizer hints in MySQL 5.7.7 – The missed manual

MySQL Performance Blog - Thu, 30/04/2015 - 7:00am

In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about the hints. The only note which I found in the user manual about the hints is: It is now possible to provide hints to the optimizer by including /*+ ... */ comments following the SELECT, […]

Pages

Subscribe to MySQL Performance Blog