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/replication-options.html
A set of quick-reference tables providing basic information about these options and variables is also included. On a replication source server and each replica, you must specify server_id to establish a unique replication ID in the range from 1 to ... The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-worker.html
On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads respectively. For a ...
https://dev.mysql.com/doc/refman/5.7/en/replication.html
Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database. Replication enables data from one MySQL database server (the source) to be copied to one or more MySQL database servers ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
https://dev.mysql.com/doc/refman/5.7/en/server-logs.html
You can tell the server to write general query and slow query entries to log tables, log files, or both. MySQL Server has several logs that can help you find out what activity is taking place. (The DDL log is always created when required, and has ...
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
The plugins supported by this interface include, but are not limited to, storage engines, INFORMATION_SCHEMA tables, full-text parser plugins, partitioning support, and server extensions. MySQL supports an plugin API that enables creation of server ...
https://dev.mysql.com/doc/refman/5.7/en/show-character-set.html
Character set information is also available from the INFORMATION_SCHEMA CHARACTER_SETS table. SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The LIKE clause, if ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-database.html
row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */ SHOW CREATE DATABASE quotes table and column names according to the value of the sql_quote_show_create option. SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
To use either statement, you must be the user named in the routine DEFINER clause or have SELECT access to the mysql.proc table. row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, ... SHOW CREATE ...