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/charset-collation-information-schema.html
Changing the value of lower_case_table_names to 1 or 2 causes the second query to return the same (nonempty) result as the first query. String columns in INFORMATION_SCHEMA tables have a collation of utf8_general_ci, which is case-insensitive.
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-restrictions.html
To prevent execution of statements that would cause GTID-based replication to fail, all servers must be started with the --enforce-gtid-consistency option when enabling GTIDs. This causes statements of any of the types discussed previously in this ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 4.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/5.7/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/5.7/en/batch-mode.html
Why use a script? Here are a few reasons: If you run a query repeatedly (say, every day or every week), making it a script enables you to avoid retyping it each time you execute it. Just edit your script to correct the error, then tell mysql to ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode.html
Attempting to use them with SET NAMES or SET CHARACTER SET produces an error. The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the BMP. For information about the Unicode ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
Otherwise, an error occurs: ERROR 1123 (HY000): Can't initialize function 'keyring_key_generate'; The user is not privileged to execute this function. Attempts to use the functions without the keyring_udf plugin result in an error. Otherwise, an ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cpustat-1sec.html
The cpustat-1sec table provides raw, per-thread CPU data obtained each second for each thread running in the NDB kernel. Like cpustat_50ms and cpustat_20sec, this table shows 20 measurement sets per thread, each referencing a period of the named ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cpustat-20sec.html
The cpustat_20sec table provides raw, per-thread CPU data obtained each 20 seconds, for each thread running in the NDB kernel. Like cpustat_50ms and cpustat_1sec, this table shows 20 measurement sets per thread, each referencing a period of the ...
https://dev.mysql.com/doc/refman/5.7/en/replica-sql-thread-states.html
Waiting until MASTER_DELAY seconds after master executed event The SQL thread has read an event but is waiting for the replica delay to lapse. Making temporary file (create) before replaying LOAD DATA INFILE The thread is executing a LOAD DATA ...