PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/performance-schema-error-log-table.html
Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). As of MySQL 8.0.22, depending on error log configuration, the server can also write the most recent error ...Typically, the server writes diagnostics to a file on the server host or to a system log ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-digests.html
The MySQL server is capable of maintaining statement digest information. Digesting occurs in the parser regardless of whether the Performance Schema is available, so that other features such as MySQL Enterprise Firewall and query rewrite plugins ...
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/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/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/creating-tables.html
Age changes as time passes, which means you'd have to update your records often. MySQL provides functions for doing date arithmetic, so this is not difficult. Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet ...You want a table that contains a record for each of your ...