Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 151 to 160 of 36379 10 Older Entries
Using MySQL 5.7 Document Store with Internet of Things (IoT)
+0 Vote Up -0Vote Down

In this blog post, I’ll discuss how to use MySQL 5.7 Document Store to track data from Internet of Things (IoT) devices.

Using JSON in MySQL 5.7

In my previous blog post, I’ve looked into MySQL 5.7.12 Document Store. This is a brand new feature in MySQL 5.7, and many people are asking when do I need or want to use the JSON or Document Store interface?

…  [Read more...]
Announcing NinesControl: deploy and monitor MySQL Galera clusters on DigitalOcean
+0 Vote Up -0Vote Down

Following the recent completion of our testers programme for NinesControl, we’re now happy to announce the public availability of NinesControl (beta), the database infrastructure management solution for the cloud.

Many thanks to our testers for participating in the NinesControl feedback programme. With the collective insight gained, we were able to fine-tune this initial public release and present it to you today.

With NinesControl, users can now easily and quickly deploy and monitor (MySQL) Galera clusters on DigitalOcean. Droplets are launched and …

  [Read more...]
Toward A Practical Perceptual Video Quality Metric
+0 Vote Up -0Vote Down

by Zhi Li, Anne Aaron, Ioannis Katsavounidis, Anush Moorthy and Megha Manohara

At Netflix we care about video quality, and we care about measuring video quality accurately at scale. Our method, Video Multimethod Assessment Fusion (VMAF), seeks to reflect the viewer’s perception of our streaming quality.  We are open-sourcing this tool and invite the research community to collaborate with us on this important project.
Our Quest for High Quality Video
We strive to provide our members with a great viewing experience: smooth video playback, free of annoying picture artifacts. A significant part of this endeavor is …

  [Read more...]
Advanced MySQL Slow Query Logging
+0 Vote Up -0Vote Down

Proper MySQL Query Optimization starts with a proper Slow Query Logging session. And MySQL Query Optimization is where I spend 70-80% of my time when doing MySQL performance optimization. In this short series I will show you how to do Slow Query Logging the right way.

UPDATE: Part 2 is now available. You can find it here:

Advanced MySQL Slow Query Logging Part 2: pt-query-digest report

Stay tuned for Part 3, as well as the cheat sheet mentioned in the video.

The post …

  [Read more...]
Severe performance regression in MySQL 5.7 crash recovery
+0 Vote Up -0Vote Down

In this post, we’ll discuss some insight I’ve gained regarding severe performance regression in MySQL 5.7 crash recovery.

Working on different InnoDB log file sizes in my previous post:

What is a big innodb_log_file_size?

I tried to understand how we can make InnoDB crash recovery faster, but found a rather surprising 5.7 crash recovery regression.

Basically, crash recovery in MySQL 5.7 is two times slower, due to this issue:  …

  [Read more...]
Webinar Thursday, June 9: Troubleshooting MySQL configuration issues
+0 Vote Up -0Vote Down

Please join us on Thursday June 9, at 10:00 am PDT (UTC-7) for the webinar Troubleshooting MySQL configuration issues.

MySQL Server is highly tunable. It has hundreds of configuration options which provide great tuning abilities and, at the same time, can be the source of various issues.

In this webinar you will learn which types of options MySQL Server supports, when they take effect …

  [Read more...]
Percona Server 5.7.12-5 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the GA release of Percona Server 5.7.12-5 on June 6, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories.

Based on MySQL 5.7.12, …

  [Read more...]
EL5 and why we’ve had to enable TLSv1.0 again
+0 Vote Up -0Vote Down

We have had to revert back to TLSv1.0.

If you saw my previous post on TLSv1.0 (, you’ll know I  wanted to deprecate TLSv1.0 well ahead of PCI’s changes. We made the changes May 31st.

Unfortunately, it has become apparent that EL 5, which is in the final …

  [Read more...]
Fun with Bugs #43 - Bugs Fixed in MySQL 5.7.13
+1 Vote Up -0Vote Down

For some reason I do not see numerous public announcements about recent MySQL 5.7.13 release, even though it happened a couple of days ago formally. Maybe that's because we do not have any really "big" new features in this release (new ->> operator for introduced though for those who, unlike me, care about JSON). Still there are many fixes for bugs previously reported by Community (or Oracle engineers, but still in …

  [Read more...]
MySQL 5.7 ghost users
+2 Vote Up -0Vote Down

Several months ago I reported on Default Users in MySQL 5.7. With the addition of the sys schema the server needs an extra user to secure operations. The problem with extra users is that, if you are not aware of their existence and why they are needed, you may easily mismanage them. For example, you may have a cleanup routine that you run when you use a new server, and the routine may have a command like

DELETE FROM mysql.user WHERE user != 'root'; …
  [Read more...]
10 Newer Entries Showing entries 151 to 160 of 36379 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.