Tag: MySQL 5.7

Feed: Planet MySQL. Author: Jaime Crespo. For the impatient: # echo -e "deb http://repo.mysql.com/apt/debian/ stretch mysql-5.7ndeb-src http://repo.mysql.com/apt/debian/ stretch mysql-5.7" > /etc/apt/sources.list.d/mysql.list # wget -O /tmp/RPM-GPG-KEY-mysql https://repo.mysql.com/RPM-GPG-KEY-mysql # apt-key add /tmp/RPM-GPG-KEY-mysql # apt update # apt install mysql-server# echo -e "deb http://repo.mysql.com/apt/debian/ stretch mysql-5.7ndeb-src http://repo.mysql.com/apt/debian/ stretch mysql-5.7" > /etc/apt/sources.list.d/mysql.list# wget -O /tmp/RPM-GPG-KEY-mysql https://repo.mysql.com/RPM-GPG-KEY-mysql# apt-key add /tmp/RPM-GPG-KEY-mysql# apt update# apt install mysql-serverIn the latest stable version of Debian, if you ask to install mysql-server, you now get installed mariadb automatically, with no (evident) way of installing Oracle’s MySQL. Any major version upgrade has to be done carefully (not only for MariaDB, but ... Read More

Feed: Planet MySQL. Author: Valeriy Kravchuk. This is a "Howto" kind of post, and some speculations and historical references aside, it will show you how to build MariaDB ColumnStore (current version 1.0.9) from GitHub source, how to install and configure it for basic usage, as well as how to resolve some minor problems you may get in the process. Keep reading and eventually you'll get the real Howto below :) * * * I try not to care about any software issues besides good old MySQL, InnoDB storage engine internals, query optimization and some MyRocks or a little bit of ... Read More

Feed: Planet MySQL. Author: Yngve Svendsen. Debian logo by Software in the Public Interest, Inc. (CC-BY-SA) MySQL and Debian 9 “Stretch” Debian 9 (“Stretch”) was released on June 17, and we congratulate the Debian community on another iteration of a central Linux distro. Now, the Debian release team some time ago decided not to ship MySQL as part of the distro, instead replacing it with one of the downstream forks. The MySQL team is absolutely committed to making sure that the vast MySQL user base can continue to use Debian as a platform, and we are directing a lot of attention to making ... Read More

Feed: Percona Database Performance Blog. Author: Kenny Gryp. Kenny Gryp and Ramesh Sivaraman  | June 23, 2017 |  Posted In: Group Replication, High-availability, InnoDB, Percona XtraDB Cluster PREVIOUS POST Thank you for attending the Wednesday, June 21, 2017 high availability webinar titled Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication. In this blog, I will provide answers to the Q & A for that webinar. You can find the slides and a recording of the webinar here. Is there a minimum MySQL server version for Group Replication? MySQL Group Replication is GA since MySQL Community 5.7.17. This is the lowest version that you ... Read More

Feed: Planet MySQL. Author: TwinDB. If you ever tried to backup MySQL 5.7 with Percona Xtrabackup that comes in percona-xtrabackup package most likely you got error message like this: 1234567891011121314151617 # innobackupex ./170623 05:58:43 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully.At the end of a successful backup run innobackupexprints "completed OK!".170623 05:58:44 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'dba' (using password: YES).170623 05:58:44 version_check Connected to MySQL server170623 05:58:44 version_check Executing a version check against the server...170623 05:58:44 version_check Done.170623 05:58:44 Connecting to MySQL server host: localhost, user: dba, password: set, port: ... Read More

Feed: Planet MySQL. Author: Mark Callaghan. I used Linux perf to get more details on system performance while running the point-query test with modern sysbench. This is for an in-memory workload and part of my series on low-concurrency CPU regressions for bug 86215.tl;drI have more explaining to do The increase in instructions/query explains the decrease in queries/second from MySQL 5.6 to 5.7 to 8.0. ConfigurationI tested MySQL using upstream 5.6.35, 5.7.17 and 8.0.1. For 8.0.1 I used the latin1 charset and latin1_swedish_ci collation. My servers are described here and are named i3 NUC and i5 NUC.My usage of sysbench, including the tests run, ... Read More

Feed: Percona Database Performance Blog. Author: Colin Charles. Colin Charles  | June 19, 2017 |  Posted In: InnoDB, MariaDB, MySQL PREVIOUS POST This blog post looks at the recent MariaDB Server 10.2 GA release. Congratulations to the MariaDB Foundation for releasing a generally available (GA) stable version of MariaDB Server 10.2! We’ll definitely spend the next few weeks talking about MariaDB Server 10.2, but here’s a quick overview in the meantime. Keep in mind that when thinking about compatibility, this is meant to be the equivalent of MySQL 5.7 (GA: October 21, 2015, with Percona Server for MySQL 5.7 GA available February 23, ... Read More

Feed: Planet MySQL. Author: Mark Callaghan. As I document the low-concurrency CPU regressions in MySQL 5.7 and 8 one of the questions is whether the performance schema is part of the problem. I don't think it is as the worst-case overhead I measure is about 7% and the typical overhead is less than 5% for a single-threaded & in-memory workload.  Eventually I will repeat this test for workloads with more concurrency because there are overheads that won't be apparent at low-concurrency. The overhead is larger for simple queries, like sysbench point-query, and larger for complex queries. The overhead is also ... Read More

Feed: Planet MySQL. Author: Valeriy Kravchuk. Previous post in series was published almost 4 months ago, but I do not plan to end it. So, let me quickly discuss some of problems I worked on or was interested in so far in June, and provide some useful links.Back on June 2 I had to find out what exact files are created by MariaDB's ColumnStore when I create a table in this storage engine. Actually in recent versions one can check the tables in the INFORMATION_SCHEMA, but if still wonders why are all these directories with numbers in the names (/usr/local/mariadb/columnstore/data1/000.dir/000.dir/011.dir/193.dir/000.dir/FILE000.cdf), ... Read More

Feed: Planet MySQL. Author: Mark Callaghan. After sharing results for in-memory sysbench with MySQL 5.6, 5.7 and 8 I was curious about older releases and here I have results for MySQL 5.0, 5.1 and 5.5 in addition to 5.6, 5.7 and 8. This is one more result in my series on low-concurrency performance regressions.tl;drMySQL 4.1 and 5.5 weren't great releases for performance. I skipped both in production. The biggest drop in QPS between releases is from 5.6 to 5.7 and that drop often exceeds the drop from 5.0 to 5.6. What happened? Bug 86215 is open for this. ConfigurationI tested MySQL ... Read More