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/clone-plugin-monitoring.html
You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and clone_progress Performance Schema tables. Note The clone_status and clone_progress Performance Schema tables can be used ...To monitor a cloning operation on the donor MySQL server instance, use the clone stage events, as described in Monitoring Cloning Operations Using Performance Schema Stage ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Are stored procedures and functions created on a replication source server replicated to a replica? A.4.24. You can manage stored procedures with CREATE [FUNCTION|PROCEDURE], ALTER [FUNCTION|PROCEDURE], DROP [FUNCTION|PROCEDURE], and SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-threads-table.html
For background threads, setting the ENABLED value controls whether INSTRUMENTED is set to YES or NO for threads that are subsequently created for this instrument and listed in the threads table. For background threads, setting the HISTORY value ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-system-variables.html
(It is permissible to rename or move the file, as long as you change the value of keyring_file_data to match.) It is recommended that you create a separate backup of the keyring data file immediately after you create the first encrypted table and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.html
ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --database=dbname, -d dbname Name ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
The server performs identity and credentials checking using columns in the user table, accepting the connection only if these conditions are satisfied: The client host name and user name match the Host and User columns in some user table row. When ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
If a source used STATEMENT format and a replica used ROW format, the replica would be unable to handle the transaction correctly, therefore the CREATE TABLE ... When binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE ...When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html
If a definition omits the DEFINER attribute, the default object definer is the user who creates it. Creating a stored object with a nonexistent DEFINER account creates an orphan object, which may have negative consequences; see Orphan Stored Objects. This account must have the EXECUTE privilege for p1 as well as the UPDATE privilege for the table t1 referenced within the object ... Stored programs (procedures, functions, triggers, ...
https://dev.mysql.com/doc/refman/8.0/en/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html
To see whether a given Performance Schema table has indexes and what they are, use SHOW INDEX or SHOW CREATE TABLE: mysql> SHOW INDEX FROM performance_schema.accounts\G *************************** 1. row *************************** Table: accounts ... Applications that monitor databases may make frequent use of Performance Schema ...For example, include a WHERE clause that ...