PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-operations.html
Such operations do not require single user mode for NDB table alterations made in an NDB cluster with multiple API nodes; transactions can continue uninterrupted during online DDL operations. row *************************** Level: Warning Code: 1478 ...For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-other.html
The listings in this section provide information about parameters used in the [computer], [tcp], and [shm] sections of a config.ini file for configuring NDB Cluster. For detailed descriptions and additional information about individual parameters, ...The following parameters apply to the config.ini file's [computer] section: HostName: Host name or IP address of this ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width ...If you reload the table from the dump file, all resulting rows have internal value 2012 and display value 12, thus losing the distinctions between ...
https://dev.mysql.com/doc/refman/5.7/en/table-cache.html
If table_open_cache is set too high, MySQL may run out of file descriptors and exhibit symptoms such as refusing connections or failing to perform queries. MySQL is multithreaded, so there may be many clients issuing queries for a given table ...
https://dev.mysql.com/doc/refman/5.7/en/structured-system-variables.html
(You could also have written --default.key_buffer_size=256K.) In addition, the server creates a second key cache named extra_cache that has a size of 128KB, with the size of block buffers for caching table index blocks set to 2048 bytes. For ...A ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-thread.html
Each result set returned from the procedure should be used for a complete graph. in_start_fresh BOOLEAN: Whether to reset all Performance Schema data before tracing. Dumps all Performance Schema data for an instrumented thread to a .dot formatted ...This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
The compact family of row formats also optimizes CHAR column storage when using a variable-length character set such as utf8mb3 or utf8mb4. With ROW_FORMAT=REDUNDANT, CHAR(N) occupies N × the maximum byte length of the character set. With the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-range.html
In addition, changing the character set or collation for a given database, table, or column after such a table is created may cause changes in how rows are distributed. For information about how MySQL handles character sets and collations, see ...A ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/5.7/en/reset-slave.html
RESET SLAVE does not change any replication connection parameters such as the source's host name and port, or the replication user account name and its password. RESET SLAVE [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET SLAVE ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory.html
All MySQL installations have certain standard databases: The mysql directory corresponds to the mysql system database, which contains information required by the MySQL server as it runs. The sys directory corresponds to the sys schema, which ...Some ...