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/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management.html
If you (for example) wish to drop a partition and reorganize a table's remaining partitions, you must do so in two separate ALTER TABLE statements (one using DROP PARTITION and then a second one using REORGANIZE PARTITION). There are a number of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
In the second case, the optimizer evaluates the partitioning expression for each value in the list, creates a list of matching partitions, and then scans only the partitions in this partition list. Pruning can also be applied for such tables when ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
As you can see from the result when the SELECT is run a second time, there remains a row in the table matching the WHERE condition, but residing in a different partition (p2). Explicit selection of partitions and subpartitions for rows matching a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-component-scheduler-tasks-table.html
Does a periodic refresh of the audit log in-memory rules cache by calling audit_log_flush INTERVAL_SECONDS: 100 TIMES_RUN: 5 TIMES_FAILED: 0 1 row in set (0.02 sec) The component_scheduler_tasks table has the following columns: NAME The name ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-stages-current-table.html
The unit for these values is picoseconds (trillionths of a second). For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 29.4.1, “Performance Schema Event Timing”. The table stores one row ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
The unit for these values is picoseconds (trillionths of a second). For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 29.4.1, “Performance Schema Event Timing”. This value is computed in ...The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-current-table.html
The unit for these values is picoseconds (trillionths of a second). For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 29.4.1, “Performance Schema Event Timing”. The table stores one row ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
The unit for these values is picoseconds (trillionths of a second). For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 29.4.1, “Performance Schema Event Timing”. The table stores one row ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-functions.html
FORMAT_PICO_TIME(time_val) Given a numeric Performance Schema latency or wait time in picoseconds, converts it to human-readable format and returns a string consisting of a value and a units indicator. Times under 1 nanosecond are represented as ...