Search Results
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/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/refman/9.7/en/identifiers.html
The identifier quote character is the backtick (`): mysql> SELECT * FROM `select` WHERE `select`.id > 100; If the ANSI_QUOTES SQL mode is enabled, it is also permissible to quote identifiers within double quotation marks: mysql> CREATE TABLE "test" ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-tuning.html
In addition to user data, the page format includes some internal system data that is not compressed. For example: USE test; SET GLOBAL innodb_file_per_table=1; SET GLOBAL autocommit=0; -- Create an uncompressed table with a million or two rows. \! ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-doublewrite-buffer.html
innodb_doublewrite_dir The innodb_doublewrite_dir variable defines the directory where InnoDB creates doublewrite files. If no directory is specified, doublewrite files are created in the innodb_data_home_dir directory, which defaults to the data ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_DEFAULT_STOPWORD: Holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB tables. The VALUE column is empty if there is no user-defined stopword table. use_stopword: Indicates whether a stopword table is ...INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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 ...