PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/transport-protocols.html
For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based on several transport protocols: TCP/IP, Unix socket file, named pipe, and shared memory. For additional information, ...This section describes how to select these protocols, and how they are similar and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
The effect of the default object configuration is to instrument all tables except those in the mysql, INFORMATION_SCHEMA, and performance_schema databases. The order in which matching occurs matters because different matching setup_objects rows can ... The setup_objects table controls whether the Performance Schema monitors particular ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
MySQL Events are tasks that run according to a schedule. When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
For example, in the above scenario of 5 servers where 3 leave at once, if the 3 leaving servers warn the group that they are leaving, one by one, then the membership is able to adjust itself from 5 to 2, and at the same time, securing quorum while ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
In its simplest form, SHOW EVENTS lists all of the events in the current schema: mysql> SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ | jon@ghidora | myschema | ... SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
For example: key_buffer_size = 4G hot_cache.key_buffer_size = 2G cold_cache.key_buffer_size = 2G init_file=/path/to/data-directory/mysqld_init.sql The statements in mysqld_init.sql are executed each time the server starts. Note As of MySQL 8.0, the ...Shared access to the key cache improves performance but does not eliminate contention among sessions ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html
COMMIT; The mysqldump option --opt creates dump files that are fast to import into an InnoDB table, even without wrapping them with the SET autocommit and COMMIT statements. For optimal performance when loading data into an InnoDB FULLTEXT index, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-source.html
To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 on the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) for the channel. GTID ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html
The DEFINER Attribute The SQL SECURITY Characteristic Examples Orphan Stored Objects Risk-Minimization Guidelines The DEFINER Attribute A stored object definition can include a DEFINER attribute that names a MySQL account. Orphan Stored Objects An ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
mysql> USE innodb_memcache; Database changed mysql> SHOW TABLES; +---------------------------+ | Tables_in_innodb_memcache | +---------------------------+ | cache_policies | | config_options | | containers | +---------------------------+ ... InnoDB ...