PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
Replicate_Do_DB, Replicate_Ignore_DB The names of any databases that were specified with the --replicate-do-db and --replicate-ignore-db options, or the CHANGE REPLICATION FILTER statement. SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation.html
For a list of systems on which MySQL is known to run, see https://www.mysql.com/support/supportedplatforms/database.html. Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation ...
https://dev.mysql.com/doc/refman/8.0/en/start-replica.html
When a replication channel has gaps, the replica’s database is in a state that might never have existed on the source. START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | MASTER_LOG_FILE = 'log_name', MASTER_LOG_POS = log_pos | SOURCE_LOG_FILE = 'log_name', SOURCE_LOG_POS = log_pos | RELAY_LOG_FILE = 'log_name', RELAY_LOG_POS = log_pos | SQL_AFTER_MTS_GAPS } connection_options: [USER='user_name'] [PASSWORD='user_pass'] [DEFAULT_AUTH='plugin_name'] [PLUGIN_DIR='plugin_dir'] channel_option: FOR CHANNEL channel gtid_set: uuid_set [, uuid_set] ...
https://dev.mysql.com/doc/refman/8.0/en/starting-server-troubleshooting.html
This is where it expects to find databases and where it expects to write log files. This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.5, ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-metadata.html
To obtain metadata about stored routines: Query the ROUTINES table of the INFORMATION_SCHEMA database. Use the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements to see routine definitions. Use the SHOW PROCEDURE STATUS and SHOW FUNCTION ...
https://dev.mysql.com/doc/refman/8.0/en/sys-processlist.html
db The default database for the thread, or NULL if there is none. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. They provide more complete information than the SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-analysis.html
db The default database for the statement, or NULL if there is none. The statement_analysis and x$statement_analysis views have these columns: query The normalized statement string. full_scan The total number of full table scans performed by ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. 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/8.0/en/sys-statements-with-errors-or-warnings.html
db The default database for the statement, or NULL if there is none. These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-full-table-scans.html
db The default database for the statement, or NULL if there is none. These views display normalized statements that have done full table scans. By default, rows are sorted by descending percentage of time a full scan was done and descending total ...