PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysqladmin.html
You can use it to check the server's configuration and current status, to create and drop databases, and more. Invoke mysqladmin like this: mysqladmin [options] command [command-arg] [command [command-arg]] ... Some of the commands take an argument ...
https://dev.mysql.com/doc/refman/9.7/en/mysqld-multi.html
For more information on which options must be unique per server in a multiple-server environment, see Section 7.8, “Running Multiple MySQL Instances on One Machine”. mysqld_multi is designed to manage several mysqld processes that listen for ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldm-options.html
--plugin-authentication-webauthn-client-preserve-privacy={OFF|ON} Command-Line Format --plugin-authentication-webauthn-client-preserve-privacy Type Boolean Default Value OFF Determines how assertions are sent to server in case there is more than one ... mysqldm accepts MySQL standard connection options and several mysqldm-specific ...
https://dev.mysql.com/doc/refman/9.7/en/optimize-numeric.html
For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string columns. Since large numeric values can be stored in fewer bytes than the corresponding strings, it is faster and takes less ...
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-tables.html
This table, like other Performance Schema tables, is read-only, and thus cannot be updated or truncated by users. See Section 29.12.22.7, “The mysql_option Table”, for more detailed information about this table, such as columns and their ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations.html
It can be desirable in some cases (see Section 26.6.1, “Partitioning Keys, Primary Keys, and Unique Keys”) to modify a table's primary key. This section discusses current restrictions and limitations on MySQL partitioning support. The following ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-subpartitions.html
Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned table. Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-clone-progress-table.html
The clone_progress table has these columns: ID A unique cloning operation identifier in the current MySQL server instance. The clone_progress table shows progress information for the current or last executed cloning operation only. The stages of a ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-clone-status-table.html
The clone_status table has these columns: ID A unique cloning operation identifier in the current MySQL server instance. The clone_status table shows the status of the current or last executed cloning operation only. The table only ever contains ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-error-log-table.html
Event timestamps are derived from the UTC timestamp in the crash message header and made unique for individual rows. Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The ...