Tag: MySQL 5.7

Feed: Planet MySQL; Author: Valeriy Kravchuk; I've seen questions like this: "Is there a way to know when (date and time) the last statement captured in ... was actually ran?" more than once in some discussions (and customer issues) related to Performance Schema. I've seen answers provided by my colleagues and me after some limited testing. I've also noticed statements that it may not be possible.Indeed, examples of wall clock date and time in the output of queries from the performance_schema are rare (and usually come from tables in the information_schema.  sys.format_time() function converts time to a nice, human readable ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Some say that the best password is the one you don’t have to remember. That’s possible with MySQL, thanks to the auth_socket plugin and its MariaDB version unix_socket.Neither of these plugins is new, and some words have been written about the auth_socket on this blog before, for example: how to change passwords in MySQL 5.7 when using plugin: auth_socket. But while reviewing what’s new with MariaDB 10.4, I saw that the unix_socket now comes installed by default and is one of the authentication methods (one of them because in MariaDB 10.4 a single ... Read More

Feed: Planet MySQL; Author: Corrado Pandiani; From time to time you may have experienced that MySQL was not able to find the best execution plan for a query. You felt the query should have been faster. You felt that something didn’t work, but you didn’t realize exactly what.Maybe some of you did tests and discovered there was a better execution plan that MySQL wasn’t able to find (forcing the order of the tables with STRAIGHT_JOIN for example).In this article, we’ll see a new interesting feature available on MySQL 8.0 as well as Percona Server for MySQL 8.0: the histogram-based statistics.Today, ... Read More

Feed: Planet MySQL; Author: Colin Charles; Codership is pleased to announce a new Generally Available (GA) release of Galera Cluster for MySQL 5.6 and 5.7, consisting of MySQL-wsrep 5.6.46 (release notes, download) and MySQL-wsrep 5.7.28 (release notes, download). There is no Galera replication library release this time, so please continue using the 3.28 version, implementing wsrep API version 25. This release incorporates all changes to MySQL 5.6.46 and 5.7.28 respectively and can be considered an updated rebased version. It is worth noting that we will have some platforms reach end of life (EOL) status, notably OpenSUSE 13.2 and Ubuntu Trusty ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users,MySQL Shell 8.0.18 is a maintenance release of MySQL Shell 8.0 Series (acomponent of the MySQL Server). The MySQL Shell is provided underOracle’s dual-license.MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and5.7. Please upgrade to MySQL Shell 8.0.18.MySQL Shell is an interactive JavaScript, Python and SQL consoleinterface, supporting development and administration for the MySQLServer. It provides APIs implemented in JavaScript and Python thatenable you to work with MySQL InnoDB cluster and use MySQL as a documentstore.The AdminAPI enables you to work with MySQL InnoDB cluster, providing anintegrated solution for ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; There is an interesting feature in MySQL 5.7+: the global variable super_read_only.  MySQL 5.6 and before only had the read_only global variable which is not preventing a user with SUPER privilege to write to the database.  With super_read_only, those users cannot write anymore.  But this feature comes with a surprise.TL&DR: changing super_read_only to ON also sets read_only to ON and setting read_only to OFF changes super_read_only to OFF.That surprise is that changing super_read_only to ON also sets read_only to ON and setting read_only to OFF changes super_read_only to OFF).  It is documented in the manual under the read_only entry, and the ... Read More

Feed: Planet MySQL; Author: MyDBOPS;                                    Recently, One of our client reached our Remote DBA team with a requirement to reduce the size of the table as it is having many text columns with huge number of records. At preliminary check , I have validated the table size and its row format, as it was  in compressed  format already.  Later I checked on other possibilities to compress the text columns further, At that time, then I came across per-column compression feature in Percona MySQL ... Read More

Feed: Cloud Data Transformation Software | Matillion. Author: Veronica Kupetz, Solution Architect; Veronica Kupetz, Solution Architect Want to ensure that Amazon Redshift or Snowflake cloud data warehouse on AWS stays up to date with your source database? Change Data Capture (CDC) is your new best friend.  As we mentioned in our latest ebook, Accelerate Time to Insight, Matillion offers CDC functionality for AWS-hosted instances. CDC works directly with several AWS products: DMS, Lambda, SQS and S3. Setting up Change Data Capture takes a few steps. But once it’s ready to go, you no longer need to update with complex transformations, ... Read More

Feed: Planet MySQL; Author: Severalnines; MySQL Galera Cluster 4.0 is the new kid on the database block with very interesting new features. Currently it is available only as a part of MariaDB 10.4 but in the future it will work as well with MySQL 5.6, 5.7 and 8.0. In this blog post we would like to go over some of the new features that came along with Galera Cluster 4.0. Galera Cluster Streaming Replication The most important new feature in this release is streaming replication. So far the certification process for the Galera Cluster worked in a way that whole ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; MySQL Shell is a pretty nice piece of software. Is not just another mysql client but it is also a tool that offers scripting capabilities for JavaScript and Python. And one of the coolest things you can do with it is to check if your MySQL 5.7 server is ready for an upgrade or not. Enter: https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.htmlNow, how can I use it? First of all, you’ll have to install the MySQL Shell package: yum install -y mysql-shell.x86_64 …. …. Transaction test succeeded Running transaction Installing : mysql-shell-8.0.17-1.el7.x86_64 1/1 Verifying : mysql-shell-8.0.17-1.el7.x86_64 1/1 Installed: ... Read More