Tag: MySQL 5.7

Feed: Planet MySQL; Author: Yves Trudeau; Yves Trudeau | May 15, 2018 |  Posted In: AWS, Hardware and Storage, MySQL, ZFS PREVIOUS POST If you are a regular reader of this blog, you likely know I like the ZFS filesystem a lot. ZFS has many very interesting features, but I am a bit tired of hearing negative statements on ZFS performance. It feels a bit like people are telling me “Why do you use InnoDB? I have read that MyISAM is faster.” I found the comparison of InnoDB vs. MyISAM quite interesting, and I’ll use it in this post. To have some data ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Peter Zaitsev | May 14, 2018 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0 PREVIOUS POST Do you want to install MySQL 8.0 on Ubuntu 16.04 LTS? In this quick tutorial, I show you exactly how to do it in five minutes or less. This tutorial assumes you don’t have MySQL or MariaDB installed. If you do, it’s necessary to uninstall them or follow a slightly more complicated upgrade process (not covered here). Step 1: Install MySQL APT Repository Ubuntu 16.04 LTS, also known as Xenial, comes with a choice of MySQL 5.7 and MariaDB 10.0 ... Read More

Feed: Planet MySQL; Author: Abdel-Mawla Gharieb; There are two simple ways to backup only the users and privileges in MySQL: 1- Using mysqlpump utility (as create user and grant statements): [shell ~]$ mysqlpump -uUSER -p --exclude-databases=% --add-drop-user --users > /tmp/pump-all-users_privileges-timestamp.sqlDump completed in 1364 milliseconds Sample output: [shell ~]$ head /tmp/pump-all-users_privileges-timestamp.sql-- Dump created by MySQL pump utility, version: 5.7.21-20, Linux (x86_64)-- Dump start time: Sun May 13 23:30:49 2018-- Server version: 5.7.21SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;SET @OLD_SQL_MODE=@@SQL_MODE;SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";SET @@SESSION.SQL_LOG_BIN= 0;SET @OLD_TIME_ZONE=@@TIME_ZONE;SET TIME_ZONE='+00:00';SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;SET NAMES utf8mb4;DROP USER 'check'@'%';CREATE USER 'check'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*B865CAE8F340F6CE1485A06F4492BB49718DF' REQUIRE NONE PASSWORD EXPIRE DEFAULT ... Read More

Feed: Planet MySQL; Author: John Scott; Most companies make a mistake at the very beginning.  They set their system time zone to Eastern, Central, Mountain, or Pacific time.  Then, they install their database on it.  They use all manner of timestamp and date types and insert terabytes of data.  After that, it becomes almost impossible (in terms of being worth the effort) to change it some months or years later when the company has a popular product or service.  One of the unfortunate issues that may arise is illegal datetimes. On Sunday, March 11, 2018, when US time zones switched ... Read More

Feed: Planet MySQL; Author: Dimitri Kravtchuk; In the previous article I've intentionally skipped the topic related to Binlog impact on MySQL 8.0 Performance because it's not a short story, nor a simple one..In fact, for most of people Binlog in MySQL is generally representing an additional overhead, and historically it was true. Since MySQL 5.6 there is Binlog Group Commit (BGC) feature available, and it was rather doing well, decreasing the gap between "binlog=OFF" and "binlog=ON sync_bin=1". However, storage vendors are making flash drives more and more faster (and cheaper) from year to year.. And when we delivered MySQL 5.7 ... Read More

Feed: Planet MySQL; Author: Dimitri Kravtchuk; This post is following previously published OLTP_RO results for MySQL 8.0 (latin1 and utf8mb4 charsets), and now is focusing on Sysbench RW workloads, particularly "mixed" OLTP_RW and Update-NoKey : OLTP_RW : while this workload has writes, it's mainly driven by reads (OLTP_RO + 2 updates + delete + insert) Update-NoKey : aggressively bombarding UPDATE queries (but with no changes on indexed columns) The same 2S Skylake server was used as in previous tests :Server configuration : OS : Oracle Linux 7.4 CPU : 48cores-HT Intel Skylake 2.7Ghz (2CPU sockets (2S), Intel(R) Xeon(R) Platinum 8168 ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Vadim Tkachenko | May 4, 2018 |  Posted In: Benchmarks, Insight for DBAs, MySQL, MySQL 8.0 PREVIOUS POST As part of my benchmarks of binary logs, I’ve decided to check how the recently released MySQL 8.0 performance is affected in similar scenarios, especially as binary logs are enabled by default. It is also interesting to check how MySQL 8.0 performs against the claimed performance improvements in redo logs subsystem. I will use a similar setup as in my last blog with MySQL 8.0, using the utf8mb4 charset. I have a few words about MySQL 8.0 tuning. Dimitri’s ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Vadim Tkachenko | May 4, 2018 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MySQL, MySQL 8.0 PREVIOUS POST I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in throughput for the InnoDB storage engine, even though we spent a lot of time making it as stable as possible in Percona Server for MySQL. In the end, the culprit was enabled binary ... Read More

Feed: Planet MySQL; Author: MyDBOPS;            MySQL is the most widely used  Relational Database Management System in the open source world. MySQL stepped into the NoSQL world by introducing the JSON Data Type in MySQL 5.7 release. In this blog post I am going to explain one of the major advantage of optimisation made in JSON Replication . This was done from the MySQL 8.0.3 release. What happened before 8.0.3 ? Before MySQL 8.0.3, Whatever changes (Updates) made in JSON document, it will log as a full document in binary log & replicate the same into ... Read More

Feed: Planet MySQL; Author: HowToForge; LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache web server on an Ubuntu 18.04 LTS (Bionic Beaver) server with PHP 7.2 (mod_php) and MySQL / MariaDB support and how to setup an SSL certificate with Let's encrypt. Additionally, I will install PHPMyAdmin to make MySQL administration easier. A LAMP setup is a perfect basis for popular CMS systems like Joomla, Wordpress or Drupal. Preliminary Note In this tutorial, I will use the hostname server1.example.com with the IP address 192.168.1.100. These settings might differ for you, so ... Read More