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/set-default-role.html
SET DEFAULT ROLE requires these privileges: Setting the default roles for another user requires the global CREATE USER privilege, or the UPDATE privilege for the mysql.default_roles system table. role [, role ] ...: Set the default to the named ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-event.html
For example (using the same event e_daily defined and then altered in Section 15.7.7.18, “SHOW EVENTS Statement”): mysql> SHOW CREATE EVENT myschema.e_daily\G *************************** 1. SHOW CREATE EVENT event_name This statement displays ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-trigger.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. This statement requires the TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-stack.html
row *************************** thread_stack: {"rankdir": "LR","nodesep": "0.10", "stack_created": "2014-02-19 13:39:03", "mysql_version": "8.0.2-dmr-debug-log", "mysql_user": "root@localhost","events": [{"nesting_event_id": "0", "event_id": "10", ... Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-overview.html
Note For MySQL instances with a large number of objects, this view might take a long time to execute. This view summarizes the types of objects within each schema. object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, ...
https://dev.mysql.com/doc/refman/8.0/en/verifying-package-integrity.html
After downloading the MySQL package that suits your needs and before attempting to install it, make sure that it is intact and has not been tampered with. If you notice that the MD5 checksum or GPG signatures do not match, first try to download the ...There are three means of integrity checking: MD5 checksums Cryptographic signatures using GnuPG, the GNU Privacy Guard For RPM packages, the built-in RPM integrity verification mechanism The following sections describe how to use these ...
https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html
They must not be expressions, such as these: 3.14159 col1 + 3 UPPER(col2) col3 / col4 (subquery) MySQL sets a flag, called the view updatability flag, at CREATE VIEW time. It is sometimes possible for a multiple-table view to be updatable, assuming ... Some views are updatable and references to them can be used to specify tables to be updated in data change ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-index-statistics.html
select_latency The total wait time of timed reads using the index. insert_latency The total wait time of timed inserts into the index. update_latency The total wait time of timed updates in the index. delete_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-avg-latency.html
total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait time of timed occurrences of events in the class. avg_latency The average wait time per timed occurrence of events in the class.