Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-performance-timers-table.html
For example, on a system with a 2.4GHz processor, the CYCLE may be close to 2400000000. For an explanation of how event timing occurs, see Section 29.4.1, “Performance Schema Event Timing”. For a cycle timer, the frequency is generally related ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-query-profiling.html
The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE statements. The setup_actors table can be used to ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-statement-histogram-summary-tables.html
The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and average statement latency (see Section 29.12.20.3, “Statement Summary Tables”). To permit assessment at a more fine-grained ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-rounding.html
On many systems, this means that ROUND() uses the “round to nearest even” rule: A value with a fractional part exactly half way between two integers is rounded to the nearest even integer. This section discusses precision math rounding for the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rules-table-options.html
For example, a GRANT statement, which updates the mysql.user system table but does not mention that table, is not affected by a filter that specifies mysql.% as the wildcard pattern. The replica checks for and evaluates table options only if either ...
https://dev.mysql.com/doc/refman/9.7/en/role-names.html
It is possible for a row in the mysql.user system table to serve as both an account and a role. MySQL role names refer to roles, which are named collections of privileges. Role names have syntax and semantics similar to account names; see Section ...
https://dev.mysql.com/doc/refman/9.7/en/set-operations.html
(Some database systems, such as Oracle, use MINUS for the name of this operator. Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT ...
https://dev.mysql.com/doc/refman/9.7/en/source-installation-methods.html
File names for source distributions can be distinguished from those for precompiled binary distributions in that source distribution names are generic and include no platform name, whereas binary distribution names include a platform name indicating ... There are two methods for installing MySQL from source: Use a standard MySQL source ...
https://dev.mysql.com/doc/refman/9.7/en/source-installation.html
For a list of systems on which MySQL is known to run, see https://www.mysql.com/support/supportedplatforms/database.html. Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-aggregate-functions.html
If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. MySQL supports aggregate functions that perform a calculation on a set of values. For general ...