Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 17883 10 Older Entries

Displaying posts with tag: mysql (reset)

Restoring MySQL Database from xtrabackup – facepalm moments
+0 Vote Up -0Vote Down

Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.

Advanced MySQL Slow Query Logging Part 2: pt-query-digest report
+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.

Here in part 2, we will go over the pt-query-digest report, that we have prepared in part 1.

The post Advanced MySQL Slow Query Logging Part 2: pt-query-digest report appeared first on Speedemy.

Percona XtraDB Cluster 5.6.30-25.16 is now available
+1 Vote Up -0Vote Down

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on June 10, 2016. Binaries are available from the downloads area or our software repositories.

Percona XtraDB Cluster 5.6.30-25.16 is now the …

  [Read more...]
Running Percona XtraDB Cluster in a multi-host Docker network
+0 Vote Up -0Vote Down

In this post, I’ll discuss how to run Percona XtraDB Cluster in a multi-host Docker network.

With our release of Percona XtraDB Cluster 5.7 beta, we’ve also decided to provide Docker images for both Percona XtraDB Cluster 5.6 and  …

  [Read more...]
Percona Monitoring and Management 1.0.1 Beta
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Monitoring and Management 1.0.1 Beta on 10 June, 2016.

Like prior versions, PMM is distributed through Docker Hub and is free to download. Full instructions for download and installation of the server and client are available in the documentation.

Notable changes to …

  [Read more...]
Percona XtraDB Cluster 5.7 beta is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona XtraDB Cluster 5.7.11-4beta-25.14.2 on June 9, 2016. Binaries are available from the downloads area or our software repositories.

NOTE: This …

  [Read more...]
RocksDB, InnoDB and the insert benchmark
+0 Vote Up -0Vote Down

Today I share results for RocksDB and InnoDB using MySQL 5.6 and the insert benchmark. I have many more results that I am currently sharing with engine vendors to help them improve (WiredTiger) or to show them the potential of RocksDB. Percona has embraced MongoRocks. I hope to see similar support for MyRocks in a widely used MySQL distribution.

tl;dr - RocksDB did better than InnoDB for a write-heavy workload and a range-scan heavy workload. The former is expected, the latter is a …

  [Read more...]
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...]
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...]
10 Newer Entries Showing entries 31 to 40 of 17883 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.