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/aggregate-functions-and-modifiers.html
They are often used with a GROUP BY clause to group values into subsets. For information about aggregate functions that operate on geometry values, see Section 14.16.12, “Spatial Aggregate Functions”.
https://dev.mysql.com/doc/refman/8.0/en/buffering-caching.html
MySQL uses several strategies that cache information in memory buffers to increase performance.
https://dev.mysql.com/doc/refman/8.0/en/component-statements.html
...
https://dev.mysql.com/doc/refman/8.0/en/database-count-limit.html
The underlying file system may have a limit on the number of directories. The underlying file system may have a limit on the number of files that represent tables.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-option-variable-reference.html
Table 29.18 Performance Schema Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic performance_schema Yes Yes Yes Global No Performance_schema_accounts_lost Yes Global No performance_schema_accounts_size Yes Yes Yes ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-checksum-table.html
CHECKSUM TABLE returns a checksum that is calculated row by row, using a method that depends on the table row storage format. The storage format is not guaranteed to remain the same between MySQL versions, so the checksum value might change ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-user-names.html
The maximum length for user names in MySQL 8.0 is 32 characters. Replication of user names longer than 16 characters fails when the replica runs a version of MySQL previous to 5.7, because those versions support only shorter user names. This occurs ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-views.html
Views are filtered by their own name, not by the tables they refer to. This means that a view can be replicated to the replica even if the view contains a table that would normally be filtered out by replication-ignore-table rules. Care should ...
https://dev.mysql.com/doc/refman/8.0/en/replication-notes.html
...
https://dev.mysql.com/doc/refman/8.0/en/select-benchmarking.html
To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client program. The return value is always zero, but mysql prints a line displaying approximately how long the statement took to ...