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/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. If you do not need the information provided by enabling lower-level settings, disable them and the Performance Schema executes less code on your behalf ...The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively from high to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...Standard Monitor output is limited to 1MB when produced using the SHOW ENGINE INNODB STATUS ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
In addition to user data, the page format includes some internal system data that is not compressed. Given these considerations, for many applications, some tables compress more effectively than others, and you might find that your workload performs ...However, because the efficiency of compression depends on the nature of your data, you can make decisions that affect the performance of compressed tables: Which tables to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
Of course, it is not possible for one mysqld instance to access user variables set on another server instance directly. We have employed a user variable @latest here to represent the value obtained in Step 1. This means that the ndb_apply_status ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-thread-pool.html
It is designed to cache idle connections in the MySQL client for use by other users as they are needed. If you are using the innodb_thread_concurrency to limit the number of concurrently executing statements, you should find that the Thread Pool ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
TABLE_SCHEMA The name of the schema (database) to which the table belongs. TABLE_TYPE BASE TABLE for a table, VIEW for a view, or SYSTEM VIEW for an INFORMATION_SCHEMA table. For partitioned tables, ENGINE shows the name of the storage engine used ...The TABLES table has these columns: TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. Examples of functions that are nondeterministic and fail this definition: CONNECTION_ID(), ...The ...
https://dev.mysql.com/doc/refman/5.7/en/system-variable-privileges.html
For some system variables, setting the session value may have effects outside the current session and thus is a restricted operation that can be done only by users who have the SUPER privilege. In contrast to setting global runtime values, setting ...Setting the session value of these variables affects binary logging for the current session, but may also have wider implications for the integrity of server replication and ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-local-connections.html
As an administrator, connect to the server and create an account for a local user who connects from the ::1 local IPv6 host address: mysql> CREATE USER 'ipv6user'@'::1' IDENTIFIED BY 'ipv6pass'; For the permitted syntax of IPv6 addresses in account ...mysql> SELECT CURRENT_USER(), @@bind_address; +----------------+----------------+ | CURRENT_USER() | @@bind_address | +----------------+----------------+ | ipv6user@::1 | :: | ...