PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
DIGEST The statement digest MD5 value as a string of 32 hexadecimal characters, or NULL if the statements_digest consumer is no. The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
The host_cache table has these columns: IP The IP address of the client that connected to the server, expressed as a string. The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-coordinator-table.html
An error number of 0 and message which is an empty string means “no error”. For a multithreaded replica, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the coordinator thread. For a multithreaded replica, the replication_applier_status_by_worker table shows the status of the worker ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
An error number of 0 and message of the empty string mean “no error”. If the replica is not multithreaded, this table shows the status of the applier thread. Otherwise, the replica uses multiple worker threads and a coordinator thread to manage ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
An error number of 0 and message of the empty string mean “no error.” If the LAST_ERROR_MESSAGE value is not empty, the error values also appear in the replica's error log. This table shows the current status of the replication I/O thread that ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-startup-configuration.html
Longer instrument name strings take precedence over shorter pattern names, regardless of order. To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. Assuming that the Performance Schema is ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
Statement events occur at a high level of the event hierarchy. Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. These tables store statement events: ...
https://dev.mysql.com/doc/refman/5.7/en/replication-delayed.html
Slave_SQL_Running_State: A string indicating the state of the SQL thread (analogous to Slave_IO_State). MySQL 5.7 supports delayed replication such that a replica server deliberately lags behind the source by at least a specified amount of time.
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterstatus.html
In that case, the values that you need to use later when specifying the source's log file and position are the empty string ('') and 4. To configure the replica to start the replication process at the correct point, you need to note the source's ...