PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/srjs-examples.html
Next, we create a simple JavaScript stored procedure using a CREATE PROCEDURE statement that includes an OUT parameter for passing the current date and time in a human-readable format to a user variable. This section contains examples illustrating ...
https://dev.mysql.com/doc/refman/9.7/en/sys-host-summary-by-file-io-type.html
total_latency The total wait time of timed occurrences of the file I/O event for the host. max_latency The maximum single wait time of timed occurrences of the file I/O event for the host. These views summarize file I/O, grouped by host and event ...
https://dev.mysql.com/doc/refman/9.7/en/sys-host-summary-by-stages.html
total_latency The total wait time of timed occurrences of the stage event for the host. avg_latency The average wait time per timed occurrence of the stage event for the host. By default, rows are sorted by host and descending total latency. The ...
https://dev.mysql.com/doc/refman/9.7/en/sys-user-summary-by-file-io-type.html
latency The total wait time of timed occurrences of the file I/O event for the user. max_latency The maximum single wait time of timed occurrences of the file I/O event for the user. These views summarize file I/O, grouped by user and event type.
https://dev.mysql.com/doc/refman/9.7/en/sys-user-summary-by-stages.html
total_latency The total wait time of timed occurrences of the stage event for the user. avg_latency The average wait time per timed occurrence of the stage event for the user. By default, rows are sorted by user and descending total stage latency.
https://dev.mysql.com/doc/refman/9.7/en/table-locking.html
But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily for tables that are queried often and rarely inserted into or updated. A SELECT statement that takes a long ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/refman/9.7/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions.html
Examples: SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(time_col))) FROM tbl_name; SELECT FROM_DAYS(SUM(TO_DAYS(date_col))) FROM tbl_name; Functions such as SUM() or AVG() that expect a numeric argument cast the argument to a number if necessary. Multiple ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-file-reading.html
The component opens each remaining candidate file, verifies that the file actually contains JSON audit events, and sorts the files using the timestamps from the first event of each file. For example: [ { "timestamp": "2025-05-18 13:39:33", "id": 0, ... The audit log component supports functions that provide an SQL interface for reading audit log ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-file-reading.html
The plugin opens each remaining candidate file, verifies that the file actually contains JSON audit events, and sorts the files using the timestamps from the first event of each file. For example: [ { "timestamp": "2020-05-18 13:39:33", "id": 0, ...