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/performance-schema-startup-configuration.html
It is possible that a plugin installed later may create the instrument, at which time the name is recognized and configured. At runtime, SHOW VARIABLES displays the actual values that autosized parameters were set to. To use the MySQL Performance ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking.html
Example 2: A credit card processor company provides a set of services using sensitive data, such as: Processing a large number of financial transactions per second. Note MySQL Enterprise Data Masking and De-Identification is an extension included ...
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
This is like executing a SHUTDOWN statement without having to connect to the server (which for shutdown requires an account that has the SHUTDOWN privilege). Clients can prevent installation of SIGPIPE handlers by specifying the ... On Unix and ...
https://dev.mysql.com/doc/refman/5.7/en/program-variables.html
For example, the first of the following lines is legal at program invocation time, but the second is not: $> mysql --max_allowed_packet=16M $> mysql --max_allowed_packet=16*1024*1024 Conversely, the second of the following lines is legal at runtime, ... Many MySQL programs have internal variables that can be set at runtime using the SET ...See Section ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-attribute-tables.html
For connections initiated using the C API, the libmysqlclient library imposes a limit of 64KB on the aggregate size of connection attribute data on the client side: Calls to mysql_options() that cause this limit to be exceeded produce a ...For ...
https://dev.mysql.com/doc/refman/5.7/en/charset-cp932.html
Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. (See http://www.iana.org/assignments/character-sets.) However, the meaning of ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
In the second statement, only rows with 'Pat' <= key_col < 'Pau' are considered. In the second statement, the LIKE value is not a constant. WHERE index_part1=1 OR index_part2=10 Sometimes MySQL does not use an index, even if one is available.
https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
If you get the error message Can't connect to MySQL server on some_host, you can try the following things to find out what the problem is: Check whether the server is running on that host by executing telnet some_host 3306 and pressing the Enter key ...After any port is closed it remains in TIME_WAIT status for 120 ...The error (2003) Can't connect to MySQL server on ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
When this happens, query execution is quicker by the time needed to perform materialization. The optimizer handles derived tables and view references the same way: It avoids unnecessary materialization whenever possible, which enables pushing down ...(For an example, see Section 8.2.2.2, “Optimizing Subqueries with Materialization”.) If merging would result in an outer query block that references more than 61 base tables, the optimizer chooses materialization ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html
The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. An ...It ...