Tag: MySQL 5.7

Feed: Planet MySQL; Author: MySQL Performance Blog; Disclaimer: the following script only works for Percona Server for MySQL 5.7, and relies on enabling performance schema (PS) instrumentation which can add overhead on high concurrent systems, and is not intended for continuous production usage as it’s a POC (proof of concept).IntroductionIn Percona Support, we frequently receive tickets related to deadlocks and even though the deadlock concept is simple, troubleshooting might not be in all cases. As explained in How to Deal with MySQL Deadlocks, a deadlock occurs when two or more transactions mutually hold and request for locks, creating a cycle of dependencies ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; Undo Tablespaces can be truncated either implicitly or explicitly in MySQL 8.0. Both methods use the same mechanism. This mechanism could cause periodic stalls on very busy systems while an undo tablespace truncate completes. This problem has been fixed in MySQL 8.0.21. First, let’s understand the two methods that you can use to keep your undo tablespaces from growing too large. Implicit Truncation The implicit method is ON by default in MySQL 8.0. It uses the settings innodb_undo_log_truncate (default = ON) and innodb_max_undo_log_size (default = 1GB). With these settings, if an undo ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; The MySQL team is proud to announce the general availability of version 8.0.21 of the MySQL Shell. MySQL Shell Logical Dump and Load Utilities A new suite of logical dump utilities was introduced in MySQL Shell 8.0.21.util.dumpInstance(), util.dumpSchemas() and util.loadDump() can quickly createand restore logical dumps of MySQL databases in parallel, with zstd or gzipcompression and optionally store them in an OCI Object Storage bucket. It also has features designed to help smoothly copy data from MySQL 5.7 and MySQL 8.0 servers to the new MySQL Database Service in Oracle Cloud. A ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.21! As always, we have listened to the growing community of users and introduced a very useful feature for any production deployment of MySQL InnoDB cluster or ReplicaSet. Also, since we’re talking about a patch release, quality has been improved with several bugs fixed! MySQL Shell AdminAPI This release focused on introducing a tagging framework for the AdminAPI, which ultimately allowed us to introduce a very demanded feature: As usual, we would like to ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Shell 8.0.21 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle’s dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8.0.21. MySQL Shell is an interactive JavaScript, Python and SQL console interface, supporting development and administration for the MySQL Server. It provides APIs implemented in JavaScript and Python that enable you to work with MySQL InnoDB cluster and use MySQL as a document store. The AdminAPI enables ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; When I speak about MySQL performance troubleshooting (or frankly any other database), I tend to speak about four primary resources which typically end up being a bottleneck and limiting system performance: CPU, Memory, Disk, and Network.It would be great if when seeing what resource is a bottleneck, we could also easily see what queries contribute the most to its usage and optimize or eliminate them. Unfortunately, it is not as easy as it may seem.First, MySQL does not really provide very good instrumentation in those terms, and it is not easy to get ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/NET 8.0.21 is the latest General Availability release of the MySQL Connector/NET 8.0 series. This version supports .NET Core 3.1 and the X DevAPI, which enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL. To learn more about how to write applications using the X DevAPI, see http://dev.mysql.com/doc/x-devapi-userguide/en/index.html. For more information about how the X DevAPI is implemented in Connector/NET, see http://dev.mysql.com/doc/dev/connector-net. NuGet packages provide functionality at a project level ... Read More

Feed: Planet MySQL; Author: Bhuvanesh R; In any MySQL replication or migration, generally, we’ll skip the mysql database from the dump file. Since it has the current server’s settings, users, etc. So we should not create a mess on the target server with this source mysql database dump. But one downside of this approach is we’ll not get the users on the target MySQL server. Maybe you tried some approaches that are mentioned here. But whenever I don’t the credentials list during the migration and don’t have time to explore/install any tools likept-show-grants, then I’ll use this trick.DISCLAIMER You should ... Read More

Feed: Planet MySQL; Author: Andrew Grimo; Below I will show you how to build the solution + manage your capabilities & compared against having MySQL 8.0 Server’s usage. This post will also demonstrate using MySQL’s Pluggable Password Store and the API-CLI for all password and cluster commands. These are MySQL 8.0 Features in the MySQL-Shell 8.0, of course. Understanding & Building the Solution The solution components presented here are as follows: A set of 3 MySQL 5.7 Servers 3-Server minimum, increase servers in odd numbered setup up to 7 (or 9 with extra configuration) Note: InnoDB Cluster with 8.0 Servers ... Read More

Feed: Recent Announcements. Aurora Serverless is an on-demand, auto-scaling configuration for Amazon Aurora (MySQL-compatible and PostgreSQL-compatible editions), where the database will automatically start up, shut down, and scale capacity up or down based on your application's needs. It's a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads. With Amazon Aurora Serverless, you no longer have to provision or manage database capacity. You simply create an endpoint through the Amazon RDS Management Console, and Aurora Serverless handles the rest. You pay by the second, and only when the database is in use. Aurora Serverless with MySQL 5.7 compatibility is supported ... Read More