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/sys-user-summary-by-statement-type.html
These views summarize information about statements executed, grouped by user and statement type. By default, rows are sorted by user and descending total latency. The user_summary_by_statement_type and x$user_summary_by_statement_type views have ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
For example, to add date values, use DATE_ADD(); see Section 14.7, “Date and Time Functions”. The result is determined according to the following rules: In the case of -, +, and *, the result is calculated with BIGINT (64-bit) precision if both ... Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator DIV Integer division The usual arithmetic operators are ...
https://dev.mysql.com/doc/refman/8.0/en/nested-loop-joins.html
Nested-Loop Join Algorithm Block Nested-Loop Join Algorithm Nested-Loop Join Algorithm A simple nested-loop join (NLJ) algorithm reads rows from the first table in a loop one at a time, passing each row to a nested loop that processes the next table ... MySQL executes joins between tables using a nested-loop algorithm or variations on ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT NAME, ENABLED, TIMED FROM ... Events are processed in a ...| wait/synch/mutex/sql/LOCK_global_read_lock | YES | YES | | wait/synch/mutex/sql/LOCK_global_system_variables | YES | YES | | wait/synch/mutex/sql/LOCK_lock_db | YES | YES | | wait/synch/mutex/sql/LOCK_manager | YES | YES | ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. Information available in this table provides a real-time snapshot of the active connections to the server. (Additional information is available ...The table contains one row per TCP/IP or Unix socket file ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io-type.html
These views summarize file I/O, grouped by host and event type. By default, rows are sorted by host and descending total I/O latency. The host_summary_by_file_io_type and x$host_summary_by_file_io_type views have these columns: host The host from ...total The total number of occurrences of the file I/O event for the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-file-io-type.html
These views summarize file I/O, grouped by user and event type. By default, rows are sorted by user and descending total latency. The user_summary_by_file_io_type and x$user_summary_by_file_io_type views have these columns: user The client user ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
For existing rows, only the ENABLED and TIMED columns can be modified, by users with the UPDATE privilege on the table. The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
This is displayed as a DATETIME value, and is NULL if no start date and time are defined for the event. Time zone The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. row ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam-bulk-data-loading.html
This does not update any indexes and therefore is very fast. If you use locking, connections 2, 3, and 4 probably do not finish before 1 or 5, but the total time should be about 40% faster. INSERT, UPDATE, and DELETE operations are very fast in ...