by Alexander Rubin | Jun 23, 2016 | MySQL
In this blog series, I will share my experiences as I migrate commercial databases (i.e., Microsoft SQL or Oracle) to open source (MySQL). More specifically, we will look at how you can migrate from MS SQL Server to MySQL. For this first blog post I’ve chosen...
by Sveta Smirnova | Jun 22, 2016 | MySQL
In this blog, I will provide answers to the Q & A for the Troubleshooting configuration issues webinar. First, I want to thank you for attending the June, 9 webinar. The recording and slides for the webinar are available here. Below is the list of your questions...
by Vadim Tkachenko | Jun 21, 2016 | Cloud, MySQL, Percona Software
In this post, we’ll discuss Docker automatic MySQL slave propagation for help with scaling. In my previous posts on the Docker environment, I covered Percona XtraDB Cluster. Percona XtraDB Cluster can automatically scale by conveniently adding new nodes using...
by Dave Avery | Jun 20, 2016 | Insight for DBAs, MySQL
Please join Percona, Technical Account Manager, Michael Patrick on Thursday, June 23, 2016 at 10 AM PDT (UTC-7) as he presents “
by Fernando Ipar | Jun 14, 2016 | MongoDB
In this blog, I will discuss how I found some of my basic SQL assumptions that don’t hold true when dealing with MongoDB and non-existent collections. Coming from a MySQL background, I have some assumptions about databases that don’t apply to MongoDB (or...
by Sveta Smirnova | May 31, 2016 | MySQL
In this blog, I will provide answers to the Q & A for the Troubleshooting locking issues webinar. First, I want to thank you for attending the May, 12 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I...
by Vadim Tkachenko | May 31, 2016 | MySQL
In this post, we’ll discuss what constitutes a big innodb_log_file_size, and how it can affect performance. In the comments for our post on Percona Server 5.7 performance improvements, someone asked why we use innodb_log_file_size=10G with an indication that it...
by Alexander Rubin | May 24, 2016 | MySQL
In this blog, we’ll look at the MySQL 5.7 document store feature, and how it is implemented. Document Store MySQL 5.7.12 is a major new release, as it contains quite a number of new features: Document store and “MongoDB” like NoSQL interface to JSON...
by Przemysław Malkowski | May 24, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are...
by Dave Avery | May 24, 2016 | MySQL
Join Sveta on Thursday, May 26, 2016, at 10 am PDT (UTC-7) for her webinar Troubleshooting MySQL hardware resource usage. MySQL does not just run on its own. It stores data on disk, and stores data and temporarily results in memory. It uses CPU resources to perform...
by Dave Avery | May 18, 2016 | MongoDB, MySQL
Please join Alexander Rubin, Percona Principal Consultant, for his webinar MongoDB administration for MySQL DBA on Thursday, May 19 at 10 am PDT (UTC-7). If you are a MySQL DBA and want to learn MongoDB quickly – this webinar is for you. MySQL and MongoDB share...
by Vadim Tkachenko | May 6, 2016 | MySQL
In this blog, we’ll examine how CPU governor performance affects MySQL. It’s been a while since we looked into CPU governors and with the new Intel CPUs and new Linux distros, I wanted to check how CPU governors affect MySQL performance. Before jumping to...
by Laurynas Biveinis | May 5, 2016 | MySQL
In this blog post, we’ll discuss how to use multi-threaded LRU flushing to prevent bottlenecks in MySQL. In the previous post, we saw that InnoDB 5.7 performs a lot of single-page LRU flushes, which in turn are serialized by the shared doublewrite buffer. Based...
by Tibor Korocz | Apr 27, 2016 | MySQL, Percona Software
In this post, we’ll discuss how MySQL 5.7 handles the old temporal types during an upgrade. MySQL changed the temporal types in MySQL 5.6.4, and it introduced a new feature: microseconds resolution in the TIME, TIMESTAMP and DATETIME types. Now these parameters...
by Dave Avery | Apr 21, 2016 | Percona Live
The second day of Percona Live 2016 is wrapping up, but I still wanted to get to one last lecture. Fortunately, there was a great one available: What’s New in MySQL with Geir Høydalsvik, Senior Software Development Director at Oracle, and Simon Mudd, DBA at...
by Dave Avery | Apr 16, 2016 | Percona Services
The last email introduced two members of the Percona Database Performance Team: The Maven and The Specialist. Now we’re ready to reveal the identity of the final three team members. The Database Performance Team is comprised of our services experts, who work...
by Tibor Korocz | Apr 13, 2016 | Insight for DBAs, MySQL
In our previous post, we showed how Orchestrator can handle complex replication topologies. Today we will discuss how the Orchestrator-agent complements Orchestrator by monitoring our servers, and provides us a snapshot and recovery abilities if there are problems....
by Dave Avery | Apr 5, 2016 | MySQL
Join us for our latest webinar on Thursday, April 7, at 10 am PDT (UTC-7) on Introduction to Troubleshooting Performance: What Affects Query Execution? MySQL installations experience a multitude of issues: server hangs, wrong data stored in the database, slow running...
by Nik Vyzas | Mar 30, 2016 | Cloud, Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll discuss some of the basics regarding Docker MySQL replication. Docker has gained widespread popularity in recent years as a lightweight alternative to virtualization. It is ideal for building virtual development and testing environments....
by Dave Avery | Mar 23, 2016 | Percona Live
Welcome to the next installment of our talks with Percona Live Data Performance Conference 2016 speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference, as well as discuss the technologies and outlooks of the...
