One of our Percona Support customers recently reported that Percona XtraBackup failed with a page corruption error on an InnoDB table. The customer thought it was a problem or bug in the Percona XtraBackup tool. After investigation we found that an InnoDB page was actually corrupted and a Percona XtraBackup tool caught the error as [&]

The post Deep dive into MySQLs innochecksum tool appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/16/deep-dive-mysqls-innochecksum-tool/

My webinar Multi-threaded Replication in MySQL 5.6 and 5.73 on February 25 generated several excellent questions following the presentation (available here for playback along with the slides). I didnt have time to answer many of the questions during the session and so in this post I answer all of them. Thanks to everyone who attended! Q: [&]

The post Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/13/qa-multi-threaded-replication-in-mysql-5-6-and-mysql-5-7/

Geographic information systems (GIS) are used by application developers to incorporate geographic information into their datasets to create apps with cool features such finding the address to the best steakhouse in town or the locations of local points of historical interest (the list is endless). In a nutshell, GIS captures, store, checks and displays data [&]

The post MySQL and geospatial programming: An introduction to GIS appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/13/mysql-and-geospatial-programming-an-introduction-to-gis/

The MySQL Performance Schema exposes so much data that its not trivial to learn, configure, and use. With recently released Percona Agent 1.0.11 you can get query metrics  like min, max, and average query execution time  with a few clicks: Click Apply and about two minutes later youll have query metrics from Performance Schema, collected and [&]

The post Easy query metrics with MySQL Performance Schema appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/12/easy-query-metrics-with-mysql-performance-schema/

What is JSON JSON is an text based, human readable format for transmitting data between systems, for serializing objects and for storing document store data for documents that have different attributes/schema for each document. Popular document store databases use JSON (and the related BSON) for storing and transmitting data. Problems with JSON in MySQL It [&]

The post Advanced JSON for MySQL appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/10/advanced-json-mysql-indexing-aggregation-highly-complex-json-documents/

MySQL Replication is very simple to set up. In this post Ill discuss its importance and five handy tools for monitoring and managing MySQL replication. What is MySQL Replication? Its the process of copying the (real-time events) data from one master instance to another slave instance and maintaining the redundant consistent data in a different [&]

The post 5 free handy tools for monitoring and managing MySQL replication appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/09/5-free-handy-tools-for-monitoring-and-managing-mysql-replication/

Have you ever had a case where you needed to find a process which sent a HUP/KILL/TERM or other signal to your database? Let me rephrase. Did you ever have to find which process messed up your night? If so, you might want to read on. Im going to tell you how you can find [&]

The post What stopped MySQL? Tracing back signals sent to MySQL appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/06/stopped-mysql-tracing-back-signals-sent-mysql/

The CVE-2015-0204 FREAK SSL vulnerability abuses intentionally weak EXPORT ciphers which could be used to perform a transparent Man In The Middle attack. (We seem to be continually bombarded with not only SSL vulnerabilities but the need to name vulnerabilities with increasing odd names.) Is your server vulnerable? This can be tested using the following GIST [&]

The post How to test if CVE-2015-0204 FREAK SSL security flaw affects you appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/05/test-cve-2015-0204-freak-ssl-security-flaw-affects/

I am thrilled to announce that Apple co-founder and Silicon Valley icon and philanthropist Steve Wozniak will participate in a moderated Q&A on creativity and innovation April 14 during this year’s Percona Live MySQL Conference and Expo in Santa Clara, California. In addition to “The Woz,” as Steve is nicknamed, we have a great lineup [&]

The post Steve Woz Wozniak to speak at Percona Live MySQL Conference & Expo 2015 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/05/steve-woz-wozniak-to-speak-at-percona-live-mysql-conference-expo-2015/

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on March 5th 2015. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.6.22-72.0 including all the bug fixes in it, Galera Replicator 3.9, and on Codership wsrep API 25.8, Percona XtraDB Cluster 5.6.22-25.8 is now [&]

The post Percona XtraDB Cluster 5.6.22-25.8 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/05/percona-xtradb-cluster-5-6-22-25-8-now-available/

Percona is glad to announce the release of Percona Server 5.6.23-72.1 on March 4, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.23, including all the bug fixes in it, Percona Server 5.6.23-72.1 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source [&]

The post Percona Server 5.6.23-72.1 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/04/percona-server-5-6-23-72-1-now-available/

Percona is glad to announce the release of Percona Server 5.5.42-37.1 on March 4, 2015. Based on MySQL 5.5.42, including all the bug fixes in it, Percona Server 5.5.42-37.1 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.42-37.1 [&]

The post Percona Server 5.5.42-37.1 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/04/percona-server-5-5-42-37-1-now-available/

Talking with Percona Live attendees last year I heard a couple of common themes. First, people told me that there is a lot of great advanced content at Percona Live but there is not much for people just starting to learn the ropes with MySQL. Second, they would like us to find a way to [&]

The post Introducing MySQL 101, a 2-day intensive educational track at Percona Live this April 15-16 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/03/introducing-mysql-101-a-2-day-intensive-educational-track-at-percona-live/

As the need for information grows so does the size of data we need to keep in our databases. SST is unavoidable for spinning up new nodes in a PXC cluster and when datasets reach the terra-byte range this becomes ever more cumbersome requiring many hours for a new node to synchronize. More often that not, [&]

The post Improving Percona XtraDB Cluster SST startup with Google Compute Engine snapshots appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/03/improving-percona-xtradb-cluster-sst-startup-google-cloud-engine-snapshots/

From time to time people wonder how to implement roles in MySQL. This can be useful for companies having to deal with many user accounts or for companies with tight security requirements (PCI or HIPAA for instance). Roles do not exist in regular MySQL but here is an example on how to emulate them using [&]

The post Emulating MySQL roles with the Percona PAM plugin and proxy users appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/03/02/emulating-roles-percona-pam-plugin-proxy-users/

DBAs often encounter situations where they need to kill queries to ensure there are no long-running queries on a MySQL server that would impact performance. Long-running queries can be the result of many factors. Fortunately, Percona Server contains some handy tools to remove problematic MySQL processes. I will highlight all of the tools via some [&]

The post 3 handy tools to remove problematic MySQL processes appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/27/3-handy-tools-to-remove-problematic-mysql-processes/

If you use Percona Server 5.5 and you have configured it to use multiple buffer pool instances than sooner or later youll see the following lines on the servers error log and chances are youll be worried about them: [crayon-54f381dc06a7f792453169/] Worry not as this is mostly harmless. Its becoming a February tradition for me (Fernando) [&]

The post Worrying about the InnoDB: detected cycle in LRU for buffer pool (&) message? appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/26/worrying-about-the-innodb-detected-cycle-in-lru-for-buffer-pool-message/

MySQL introduced the Event Scheduler in version 5.1.6. The Event Scheduler is a MySQL-level cron job, which will run events inside MySQL. Up until now, this was not a very popular feature, however, it has gotten more popular since the adoption of Amazon RDS  as well as similar MySQL database as a service offerings [&]

The post Using MySQL Event Scheduler and how to prevent contention appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/25/using-mysql-event-scheduler-and-how-to-prevent-contention/

MySQLs innodb_file_per_table is a wonderful thing  most of the time. Having every table use its own .ibd file allows you to easily reclaim space when dropping or truncating tables. But in some use cases, it may cause significant performance issues. Many of you in the audience are responsible for running automated tests on your [&]

The post Is MySQLs innodb_file_per_table slowing you down? appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/24/mysqls-innodb_file_per_table-slowing/

Have designs on Percona Live this April in Silicon Valley? Send them to us! The winning entry will appear on a cool limited edition t-shirt that well award to a few dozen lucky recipients at our booth’s new Percona T-Shirt Bar. The winner will also get a t-shirt, of course, along with a pair “Beats [&]

The post MySQL community t-shirt contest for Percona Live 2015 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/23/mysql-community-t-shirt-contest-for-percona-live-2015/