PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an ...
https://dev.mysql.com/doc/refman/9.7/en/optimize-overview.html
With modern disks, the mean time for this is usually lower than 10ms, so we can in theory do about 100 seeks a second. Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-logging.html
On a system with a multi-core processor, a value of 150 represents 100% usage of one CPU core plus 50% usage of a second CPU core. Consider the following guidelines for optimizing redo logging: Increase the size of your redo log files. When InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...