Search Results
https://dev.mysql.com/doc/refman/9.7/en/srjs-session-info.html
The MLE component provides a number of loadable functions for working with MLE user sessions. Possible session state keys are listed here, with their descriptions: is_active: Returns 1 if the current MySQL user session is an MLE session, otherwise 0. Syntax and similar errors encountered by an unsuccessful CREATE FUNCTION or CREATE PROCEDURE statement are not written here, only runtime errors raised during execution of a stored function or stored ...
https://dev.mysql.com/doc/refman/9.7/en/sql-prepared-statements.html
To create a test case that reproduces a problem with prepared statements, so that you can file a bug report. If you create a prepared statement within a stored routine, it is not deallocated when the stored routine ends. To guard against too many ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
In MySQL 4.0 and 4.1, such events are written only to the first binary log file that mysqld creates after startup. Log files created subsequently (when someone issues a FLUSH LOGS statement or the current binary log file becomes too large) do not ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
What is a MySQL connection? Why might I need to create more than one? A.2. How do I create a MySQL database (schema) in MySQL Workbench? A.4. What is a MySQL connection? Why might I need to create more than one? A MySQL connection links (connects) ... FAQ Categories Basic Usage MySQL Workbench Functionality Data Management General Basic Usage ...
https://dev.mysql.com/doc/refman/9.7/en/explain.html
The SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements also provide information about tables. MySQL 9.7 supports an additional INTO option with EXPLAIN FORMAT=JSON, which enables saving the JSON formatted output into a user variable, ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-install-linux-binary.html
Some OS distributions create these as part of the operating system installation process. Change location to the directory containing the downloaded file, unpack the archive, and create a symbolic link named mysql to the mysql directory. This ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/meb-group-replication.html
In addition to the mysqlbackup@localhost account created on each host as described in Section 4.1.2, “Grant MySQL Privileges to Backup Administrator”, accounts for the user mysqlbackup to access all hosts in the group have been created on every ... For how to use MySQL Enterprise Backup to back up and subsequently restore a Group Replication member, see Using MySQL Enterprise Backup with Group ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-relnotes.html
2024-02-20: Custom MySQL Configurations Can Now be Created You can now create a custom configuration by copying an existing MySQL configuration and modifying its user variables. 2025-07-22: Running SQL statements as Asynchronous Tasks Now Supported ... Release Notes 23 Release Notes Release notes for MySQL HeatWave on AWS 2025-08-26: Data Storage Size Can Now Be Increased For Highly Available DB Systems You can now increase the data storage size of a highly available DB System ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-meter-metrics.html
The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno ...binlog_stmt_cache_disk_use Binlog_stmt_cache_disk_use ASYNC COUNTER The number of non-transaction statements that used the binary log statement cache but that exceeded the value of binlog_stmt_cache_size and used a temporary file to store those ...
https://dev.mysql.com/doc/relnotes/mysql-shell/9.7/en/news-9-6-0.html
As of this release, creation of user accounts is logged in the progress file. Note These release notes were created with the assistance of MySQL HeatWave GenAI. As a result, the ocimds:true option and the force_innodb compatibility option now ...