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/information-schema-innodb-sys-columns-table.html
For character columns in multibyte character sets, this length value is the maximum length in bytes needed to represent a definition such as VARCHAR(N); that is, it might be 2*N, 3*N, and so on depending on the character encoding. The ...The ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-queries.html
To tune queries for InnoDB tables, create an appropriate set of indexes on each table. Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-background.html
Alternatively, for more advanced users the group can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued concurrently. Therefore, the ultimate challenge is to fuse the logic of the database and data ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading.html
Note In the following discussion, MySQL commands that must be run using a MySQL account with administrative privileges include -u root on the command line to specify the MySQL root user. Commands that require a password for root also include a -p ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading.html
Note In the following discussion, MySQL commands that must be run using a MySQL account with administrative privileges include -u root on the command line to specify the MySQL root user. Commands that require a password for root also include a -p ...
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/plugin-loading.html
In the descriptions, plugin_name stands for a plugin name such as innodb, csv, or validate_password. The argument format is the same as for --plugin-load, but multiple instances of --plugin-load-add can be used to avoid specifying a large set of ...
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. Do not start the server with the delay_key_write system variable set to ALL or use the DELAY_KEY_WRITE=1 table option for any ...Here are some examples: If you run multiple servers that use the same database directory (not recommended), each server must have external locking ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. TABLE_SCHEMA The name of the schema (database) to which the table containing the index belongs. INDEX_SCHEMA The name of the ...
https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html
If you have set a password for the root account, deleted the anonymous account, or created a new user account, then to connect to the MySQL server you must use the appropriate -u and -p options with the commands shown previously. For more ...(Be ...