by Alexey Stroganov | Aug 22, 2016 | Benchmarks, MySQL
In this post, we’ll look at a scalability fix for issues the query rewrite plugin had on performance. Several months ago, Vadim blogged about the impact of a query rewrite plugin on performance. We decided to re-evaluate the latest release of 5.7(5.7.14), which...
by Muhammad Irfan | Aug 19, 2016 | MySQL, Webinars
Thank you for attending my 22nd July 2016 webinar titled “Top Most Overlooked MySQL Performance Optimizations”. In this blog, I will provide answers to the Q & A for that webinar. For hardware, which disk raid level do you suggest? Is raid5 suggested...
by Hrvoje Matijakovic | Aug 19, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.5.51-38.1 on August 19, 2016. Based on MySQL 5.5.51, including all the bug fixes in it, Percona Server 5.5.51-38.1 is now the current stable release in the 5.5 series. Percona Server is open-source and free. You can...
by Alexander Rubin | Aug 17, 2016 | Insight for DBAs, MySQL
In this blog post, we’ll discuss how to improve the performance of slow MySQL queries using Apache Spark. In my previous blog post, I wrote about using Apache Spark with MySQL for data analysis and showed how to transform and analyze a large volume of data (text...
by Vadim Tkachenko | Aug 10, 2016 | Benchmarks, MySQL
In this blog post, we’ll discuss how a small innodb_page_size can create a performance boost for SSD. In my previous post Testing Samsung storage in tpcc-mysql benchmark of Percona Server I compared different Samsung devices. Most solid state drives (SSDs) use...
by Vadim Tkachenko | Aug 9, 2016 | Benchmarks, MySQL
In this blog post, I’ll discuss changes I’ve made to the tpcc-mysql benchmark tool. These changes make it less random and support multi-schema. This post might only be interesting to performance researchers. The tpcc-mysql benchmark to is what I use to...
by Dave Avery | Aug 9, 2016 | MySQL, Percona Events, Webinars
Join Sveta Smirnova Thursday, August 11 at 10 am PDT (UTC-7) for a webinar on InnoDB Troubleshooting. InnoDB is one of the most popular database engines. This general-purpose storage engine is widely used, has been MySQL’s default engine since version 5.6, and...
by Vadim Tkachenko | Aug 8, 2016 | Cloud, Insight for DBAs, MySQL
In this post, I will point you to Docker images for MySQL Group Replication testing. There is a new release of MySQL Group Replication plugin for MySQL 5.7.14. It’s a “beta” plugin and it is probably the last (or at lease one of the final pre-release...
by Yves Trudeau | Aug 4, 2016 | MySQL, Percona Software
by Federico Razzoli | Jul 29, 2016 | MariaDB, MySQL
In this blog post, we’ll look at the MariaDB 10.2 CHECK and DEFAULT clauses. MariaDB 10.2 includes some long-awaited features. In this blog, we are going to discuss the improvements to some table definitions: the DEFAULT clause and the CHECK constraints. These...
by Dave Avery | Jul 28, 2016 | MySQL, Webinars
Join Brent Compton, Kyle Bader and Yves Trudeau on August 2, 2016 at 10 am PDT (UTC-7) for a MySQL and Ceph webinar. Many operators select OpenStack as their control plane of choice for providing both internal and external IT services. The OpenStack user survey...
by Peter Zaitsev | Jul 20, 2016 | MongoDB, MySQL, Percona Services
In this post, I’ll discuss how database support is good for your enterprise. Years ago when I worked for the MySQL Support organization at the original MySQL AB, we spoke about MySQL Support as insurance and focused on a value proposition similar to that of car...
by Dave Avery | Jul 19, 2016 | MySQL
Are you looking to improve your MySQL performance? Application success is often limited by poor MySQL performance. Please join Percona CEO and Founder Peter Zaitsev for this exclusive webinar on Wednesday, July 20th, 2016 at 11:00 AM PDT (UTC – 7) as he presents...
by Yves Trudeau | Jul 13, 2016 | Hardware and Storage, Insight for DBAs, MySQL
Over the last year, the Ceph world drew me in. Partly because of my taste for distributed systems, but also because I think Ceph represents a great opportunity for MySQL specifically and databases in general. The shift from local storage to distributed storage is...
by Hrvoje Matijakovic | Jul 7, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.6.31-77.0 on July 7th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.31, including all the bug fixes in it, Percona Server 5.6.31-77.0 is the...
by Alexander Rubin | Jul 6, 2016 | MySQL
by Alexander Rubin | Jul 5, 2016 | MySQL
In this post, I’ll discuss how MySQL 5.7 handles UTF8MB4 and the load data infile. Many of my clients have told me that they do not like using the LOAD DATA INFILE statement and prefer to manually parse and load the data. The main reason they do it are issues...
by Miguel Angel Nieto | Jul 1, 2016 | Cloud, MySQL
In this blog post, I discuss some of the insights needed when using Amazon RDS and pt-online-schema-change together. The pt-online-schema-change tool runs DDL queries (ALTER) online so that the table is not locked for reads and writes. It is a commonly used tool by...
by Manjot Singh | Jun 30, 2016 | Insight for DBAs, MySQL, Percona Software
This article discusses how to salvage a crashed pt-online-schema-change by leveraging pt-archiver and executing queries to ensure that the data gets accurately migrated. I will show you how to continue the data copy process, and how to safely close out the...
by Shahriyar Rzayev | Jun 29, 2016 | MySQL, Percona Events
In this post, I’ll share my experience attending the annual MySQL User Group Leaders Summit in Bucharest, Romania. The MySQL User Group Leaders Summit gathers together as many of the global MySQL user group leaders as possible. At the summit, we discuss further...
