PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-connection.html
These session system variable values are initialized at connect time, but can be changed within the session. With the mysql client, to use a character set different from the default, you could explicitly execute a SET NAMES statement every time you ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
However, when larger queries are submitted, the time spent in query optimization may easily become the major bottleneck in the server's performance. The general idea is that the fewer plans that are investigated by the optimizer, the less time it ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges at routine execution time, as described later in this section. For statements that can be determined at function definition time to return a ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
If a transaction-safe engine such as InnoDB is being used, a transaction is either completed on the replica or not applied at all, but replication does not guarantee that all data on the source and the replica remains consistent at all times. NDB ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-triggers.html
Can a table have multiple triggers with the same trigger event and action time? A.5.11. MySQL does have specific special behavior for some TIMESTAMP columns, as well as for columns which are defined using AUTO_INCREMENT. Can a table have multiple ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. MySQL Server supports many ... This section describes some of the important characteristics of the MySQL Database ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
Killed Someone has sent a KILL statement to the thread and it should abort next time it checks the kill flag. The flag is checked in each major loop in MySQL, but in some cases it might still take a short time for the thread to die. Locking system ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-table.html
COMPRESS_OPS The number of times a B-tree page of size PAGE_SIZE has been compressed. COMPRESS_OPS_OK The number of times a B-tree page of size PAGE_SIZE has been successfully compressed. COMPRESS_TIME The total time in seconds used for attempts to ... The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html
You can use the following methods to speed up inserts: If you are inserting many rows from the same client at the same time, use INSERT statements with multiple VALUES lists to insert several rows at a time. This is considerably faster (many times ... To optimize insert speed, combine many small operations into a single large ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
For escape character handling, a difference from the LIKE behavior is that the escape character for JSON_SEARCH() must evaluate to a constant at compile time, not just at execution time. For example, if JSON_SEARCH() is used in a prepared statement ... The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within ...