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-transaction-tables.html
Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. These tables store transaction events: events_transactions_current: The current transaction event for each ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-tables.html
The Performance Schema instruments waits, which are events that take time. Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. These tables store wait events: ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-mysql-sock.html
For example, put the following lines in /etc/my.cnf: [mysqld] socket=/path/to/socket [client] socket=/path/to/socket See Section 4.2.2.2, “Using Option Files”. The default location for the Unix socket file that the server uses for communication ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking purposes. This enables the external user to be a proxy for the second user; that is, to assume the ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html
For example, add these lines to the server my.cnf file: [mysqld] myisam_sort_buffer_size=256M key_buffer_size=1G myisam_max_sort_file_size=100G These settings do not include read_buffer_size. REPAIR TABLE for MyISAM tables is similar to using ...
https://dev.mysql.com/doc/refman/5.7/en/replication-encrypted-connections.html
To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network connections. If either server does not support encrypted connections (because it ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-disable-gtids.html
On each server, execute: SET @@GLOBAL.GTID_MODE = OFF; On each server, set gtid_mode=OFF in my.cnf. This section describes how to disable GTID transactions on servers that are already online. This procedure does not require taking the server ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-enable-gtids.html
On each server, execute: SET @@GLOBAL.GTID_MODE = ON; On each server, add gtid_mode=ON and enforce_gtid_consistency=ON to my.cnf. This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
For example, you can set the variables in my.cnf files on the source and replica sides as follows. Semisynchronous replication is implemented using plugins, so the plugins must be installed into the server to make them available. After a plugin has ...
https://dev.mysql.com/doc/refman/5.7/en/replication-setup-replicas.html
Note The contents of the connection metadata repository override some of the server options specified on the command line or in my.cnf. Before you proceed, ensure that you have: Configured the source with the necessary configuration properties.