PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-monitor-types.html
There are two types of InnoDB monitor: The standard InnoDB Monitor displays the following types of information: Work done by the main background thread Semaphore waits Data about the most recent foreign key and deadlock errors Lock waits for ...
https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(gtid_set[, timeout][,channel]) WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() is similar to WAIT_FOR_EXECUTED_GTID_SET() in that it waits until all of the transactions whose global transaction identifiers are contained in ...
https://dev.mysql.com/doc/refman/5.7/en/replication-setup-replicas.html
To do this, execute the following statement on the replica, replacing the option values with the actual values relevant to your system: mysql> CHANGE MASTER TO -> MASTER_HOST='source_host_name', -> MASTER_USER='replication_user_name', -> ...Before ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server-troubleshooting.html
If you have problems starting the server, here are some things to try: Check the error log to see why the server does not start. If mysqld is currently running, you can find out what path settings it is using by executing this command: $> mysqladmin ... This section provides troubleshooting suggestions for problems starting the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-table.html
Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can cause problems if no corresponding directory exists in the replica host's file ...
https://dev.mysql.com/doc/refman/5.7/en/system-optimization.html
Some system-level factors can affect performance in a major way: If you have enough RAM, you could remove all swap devices. Some operating systems use a swap device in some contexts even if you have free memory. The --external-locking and ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-character-sets-table.html
MAXLEN The maximum number of bytes required to store one character. The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name. Notes Character set information is also available from the SHOW CHARACTER SET statement. The ...
https://dev.mysql.com/doc/refman/5.7/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/5.7/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...