Search Results
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
To display the current structure of the log tables, use these statements: SHOW CREATE TABLE mysql.general_log; SHOW CREATE TABLE mysql.slow_log; Log contents are accessible through SQL statements. The log table implementation has the following ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
Create a New Data Directory With this method, the data directory is in the same state as when you first install MySQL, and has the default set of MySQL accounts and no user data. There are different methods of setting up a data directory for a new ... Each MySQL Instance on a machine should have its own data ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-windows-command-line-servers.html
To do this, create an option file for each server and tell the server the file name with a --defaults-file option when you run it. To shut down the servers, connect to each using the appropriate port number: C:\> C:\mysql\bin\mysqladmin --port=3307 ... The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.3.6, “Starting MySQL from the Windows Command ...
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 ...