Tag: Performance_Schema

Feed: Planet MySQL; Author: Kristian Köhntopp; My task is to collect performance data about a single query, using PERFORMANCE_SCHEMA (P_S for short) in MySQL, to ship it elsewhere for integration with other data. In a grander scheme of things, I will need to define what performance data from a query I am actually interested in. I will also need to find a way to attribute the query (as seen on the server) to a point in the codebase of the client, which is not always easy when an ORM or other SQL generator is being used. And finally I will ... Read More

Feed: Planet MySQL; Author: Andrew Grimo; MySQL-Shell has had a set of “Util” object functions for almost a year as of this post. It is this added functionality that negates any reason someone would still need to use the old mysqldump client. It (mysqldump) helped the MySQL Community for a long, long time. It also introduced a large amount of garbage and messiness in with those bloated data files, as it really belongs to an older era. We can now move on ahead without it. This process of “moving ahead” is what I will demonstrate in this blog post. Note: ... Read More

Feed: Planet MySQL; Author: Vlad Mihalcea; Introduction In this article, I’m going to explain how to do query profiling using the MySQL Performance Schema. The Performance Schema has been available since MySQL 5.5.3 and allows MySQL to instrument SQL queries and store their trace information in various tables that you can later inspect in order to determine why a given SQL statement is slow. On older versions of MySQL, you might have used the SHOW PROFILE command, but since this feature has been deprecated, you should now use the Performance Schema for SQL query profiling. Enabling the MySQL Performance Schema ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; Query attributes have in a long time been used to add metadata to queries to provide additional context such as where in the application the query was generated. The traditional way to do this is to add a comment at the start of the query with the attributes. Since the MySQL parser ignores the comment, it does not change the semantics of the query, but various tools can extract the comments. This post looks into the reasons for using query attributes, how it is done using a comment, and the new component for MySQL ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; MySQL Firewall is an enterprise security solution providing ease of mind while protecting your database from rogue queries. Sometimes granting wide-style access privileges may feel a bit too generous, and leaves you wondering whether you could do something more. Join us as we explore Firewall, and (in particular) using Group profiles. Having fun with Drupal In MySQL you can GRANT privileges per user, and per database. You may go as far as granting blanket privileges (GRANT ALL …), or be more specific and grant a subset of them (e.g GRANT SELECT, UPDATE ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Percona XtraBackup 8.0.23 enables the “lock-ddl” option by default to ensure any DDL events do not corrupt the backups. Any DML events continue to occur, and only DDL events are blocked. A DDL lock protects the definition of tables and views. With the “–lock-ddl” option disabled, Percona XtraBackup allows backups while concurrent DDL events continue to happen. These backups are invalid and fail at the Prepare stage. If DDL events have occurred without the backup user’s knowledge, they may be unaware the backup is corrupt. MySQL 8.0 introduced “Lock Instance for Backup”. This ... 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.23! In addition to several bug fixes and minor changes, some significant enhancements regarding monitoring/troubleshooting and performance were included. MySQL Shell AdminAPI Cluster diagnostics Checking how a Cluster is running and, whenever the cluster is not 100% healthy, perform troubleshooting tasks is certainly one of the main tasks of a DBA. The AdminAPI makes this operation very easy by centralizing the monitoring information in: <Cluster>.status([options]) In this release, we’ve extended the status() command to provide more ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; The MySQL Development team is very happy to announce that MySQL 8.0.23 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.23 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories. The source code is available at GitHub. You can find the full list of changes and bug fixes in the 8.0.23 Release Notes. Here are the highlights. Enjoy! Invisible Columns Support for INVISIBLE columns  (WL#10905) This work by Praveenkumar Hulakund adds support for INVISIBLE columns. A ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users,MySQL Shell 8.0.23 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.23.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 and InnoDBReplicaSet, providing integrated ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; In this blog, I am going to explain the different ways of electing the PRIMARY node in MySQL group replication. Before MySQL 8.0.2, primary election was based on the member’s UUID, with the lowest UUID elected as the new primary in the event of a failover.From MySQL 8.0.2: We can select the node to be promoted as a PRIMARY using the server weight ( group_replication_member_weight ). This can be achieved during the failure of the current primary node.From MySQL 8.0.12: We can promote any node as a PRIMARY using the function “group_replication_set_as_primary”. This ... Read More