Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
Instrument Server Command statement/com/Prepare COM_STMT_PREPARE statement/com/Execute COM_STMT_EXECUTE statement/sql/prepare_sql SQLCOM_PREPARE statement/sql/execute_sql SQLCOM_EXECUTE The Performance Schema manages the contents of the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links-to-tables.html
For InnoDB tables, use the alternative technique explained in Section 17.6.1.2, “Creating Tables Externally” instead. To instruct a running MySQL server to perform the symlinking, use the DATA DIRECTORY and INDEX DIRECTORY options to CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/windows-troubleshooting.html
Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist These messages often occur when the MySQL base or data directories are installed in different locations than the default locations (C:\Program Files\MySQL\MySQL ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-restore.html
When restoring a single-file backup created with the option setting --use-tts=with-minimum-locking, the folder specified with --backup-dir is also used for extracting temporarily all the tables in the backup and for performing an apply-log operation ... The restore operations restores the data files from a backup to their original locations on the database server, or to other desired ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-process.html
It blocks DDL operations (except for those on user-created temporary tables), but not DML operations (except for those not captured by the binary log, like administrative changes to the database) on InnoDB tables. This step is skipped if no ... The ...In general, this is what happens when you run a backup operation with mysqlbackup: The InnoDB data files, redo log, binary log, and relay log files (except for the log files currently in use) are being copied into the backup, while the database server operates as ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-show-status.html
stopped The cluster is not running, because it has been stopped by the user. created The cluster has been created successfully using the create cluster command, but has never been started. import The process is part of a cluster that was created for ... show status show status --cluster|-c cluster_name show status --operation|-o cluster_name show status --backup|-b cluster_name show status --process|-r cluster_name show status --progress cluster_name show status --progressbar cluster_name This command is used to check the status of clusters, cluster processes, backups, and commands issued in the MySQL Cluster Manager ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-asynchronous-interface-usage.html
CREATE DATABASE db; USE db; CREATE TABLE test_table (id INT NOT NULL); INSERT INTO test_table VALUES (10), (20), (30); CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpass'; GRANT ALL ON db.* TO 'testuser'@'localhost'; Create a file named ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-functions.html
There are three ways to add a new function to MySQL: Create a stored function (a type of stored object). A loadable function is compiled as a library file and then loaded and unloaded from the server dynamically using the CREATE FUNCTION and DROP ...A stored function is written using SQL statements rather than by compiling object ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-27.html
(Bug #28725534) Connector/J now supports authentication of MySQL users created using the authentication_oci plugin. (Bug #31117686) Synchronization in the MultiHostConnectionProxy#invoke() method forced connection pools to wait for statements to ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-automl-privileges.html
mysql> GRANT CREATE, DROP, INSERT, SELECT, ALTER, DELETE, UPDATE ON database_name.* TO 'user_name'@'%'; Tracking and Monitoring Privileges You need the following privileges to track/monitor the status of AutoML and AutoML routines.. mysql> GRANT ...