PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-collections.html
Each collection has a unique name and exists within a single schema. When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. Collections contain JSON documents that you can add, ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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. Note The Performance Schema table described here is available as of MySQL 8.0.17. The clone_progress table shows progress ...
https://dev.mysql.com/doc/refman/8.0/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. Note The Performance Schema table described here is available as of MySQL 8.0.17. The clone_status table shows the status of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-stages-current-table.html
The THREAD_ID and EVENT_ID values taken together uniquely identify the row. The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-current-table.html
The THREAD_ID and EVENT_ID values taken together uniquely identify the row. The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the ...