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/stored-programs-defining.html
For example, the following stored procedure has a body made up of a BEGIN ... The following example shows how to do this for the dorepeat() procedure just shown. The delimiter is changed to // to enable the entire definition to be passed to the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-switch.html
To use CHANGE MASTER TO, add all information about how to connect to Replica 1 from Replica 2 or Replica 3 (user, password, port). When this is true for all replicas, they can be reconfigured to the new setup. During this procedure, do not forget to ...The replica does not check whether the databases on the source are compatible with those on the replica; it simply begins reading and executing events from the specified coordinates in the new source's binary ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-elements.html
Tables in the mysql system database provide persistent storage of filter and user account data. A set of functions enables manipulation of filtering definitions that control logging behavior, the encryption password, and log file reading. System ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
In conjunction with the MySQL binary log, users can perform point-in-time recovery. MySQL Enterprise Backup can also create compressed backup files, and back up subsets of tables and databases. The key to safe database management is making regular ...When mysqlbackup is copying InnoDB tables, reads and writes to InnoDB tables can ...
https://dev.mysql.com/doc/refman/5.7/en/connectors-apis.html
Native drivers are also easier for end users to build and deploy because no copy of the MySQL client libraries is needed to build the native driver components. Connector/J provides driver support for connecting to MySQL from Java applications using ... MySQL Connectors provide connectivity to the MySQL server for client ...APIs provide low-level ...
https://dev.mysql.com/doc/refman/5.7/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
There are no user-configurable server options or variables associated with this file. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table partitioning, such as ALTER TABLE t3 DROP ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-objects-summary-global-by-type-table.html
row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: mysql OBJECT_NAME: user COUNT_STAR: 14 SUM_TIMER_WAIT: 365567592 MIN_TIMER_WAIT: 1141704 AVG_TIMER_WAIT: 26111769 MAX_TIMER_WAIT: 334783032 ... The Performance Schema maintains the ...row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: test OBJECT_NAME: t COUNT_STAR: 3 SUM_TIMER_WAIT: 263126976 MIN_TIMER_WAIT: 1522272 AVG_TIMER_WAIT: 87708678 MAX_TIMER_WAIT: 258428280 ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-trx-info.html
Configuration Options ps_thread_trx_info() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 26.4.2.1, “The sys_config Table”): ps_thread_trx_info.max_length, ...
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. Do not start the server with the delay_key_write system variable set to ALL or use the DELAY_KEY_WRITE=1 table option for any ...Here are some examples: If you run multiple servers that use the same database directory (not recommended), each server must have external locking ...