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/replication-options-replica.html
With respect to replication, the server generates warnings that it succeeded in reconnecting after a network or connection failure, and provides information about how each replication thread started. The replication SQL thread continues to run, and ... This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas Options for Logging Replica Status to Tables System Variables Used on Replicas Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their privileges. The privileges applicable to execution of a stored object are ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. The ENUM type has these advantages: Compact data storage in situations where a column ...See Section 11.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
To create a database such that its tables use a given default character set and collation for data storage, use a CREATE DATABASE statement like this: CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_general_ci; Tables created in the database ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
As of MySQL 5.7.2, a warning is generated when the WITH CONSISTENT SNAPSHOT clause is ignored. Because of this, SHOW PROCESSLIST displays Rolling back in the State column for the session, not only for explicit rollbacks performed with the ROLLBACK ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
For DATE and DATETIME columns that are declared as NOT NULL, you can find the special date '0000-00-00' by using a statement like this: SELECT * FROM tbl_name WHERE date_column IS NULL This is needed to get some ODBC applications to work because ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
This event executes once—one hour following its creation—by running an SQL statement that increments the value of the myschema.mytable table's mycol column by 1. (However, a warning is generated in such cases.) The ON SCHEDULE clause determines ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
Consider the following query: SELECT * FROM t1 JOIN (SELECT DISTINCT f1 FROM t2) AS derived_t2 ON t1.f1=derived_t2.f1; The optimizer constructs an index over column f1 from derived_t2 if doing so would enable use of ref access for the lowest cost ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
When the parser encounters a word that is the name of a built-in function, it must determine whether the name signifies a function call or is instead a nonexpression reference to an identifier such as a table or column name. The server generates a ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
The ENABLED and TIMED columns should be set to YES for the instruments that you enabled. $> ./mysqlslap --auto-generate-sql --concurrency=100 --iterations=10 --number-of-queries=1000 --number-char-cols=6 --number-int-cols=6; Query the wait event ...