Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...
https://dev.mysql.com/doc/refman/9.7/en/sys-schema-unused-indexes.html
This view is most useful when the server has been up and processing long enough that its workload is representative. These views display indexes for which there are no events, which indicates that they are not being used. Otherwise, presence of an ...
https://dev.mysql.com/doc/refman/9.7/en/sys-schema-usage.html
Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform ...
https://dev.mysql.com/doc/refman/9.7/en/sys-version-major.html
This function returns the major version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_major(); +-----------+---------------------+ | VERSION() | sys.version_major() | +-----------+---------------------+ | 9.5.0 | 9 | ...
https://dev.mysql.com/doc/refman/9.7/en/sys-version-minor.html
This function returns the minor version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_minor(); +-----------+---------------------+ | VERSION() | sys.version_minor() | +-----------+---------------------+ | 9.4.0 | 4 | ...
https://dev.mysql.com/doc/refman/9.7/en/sys-version-patch.html
This function returns the patch release version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_patch(); +-----------+---------------------+ | VERSION() | sys.version_patch() | +-----------+---------------------+ | 9.4.0 | 0 | ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-trace.html
Tracing telemetry enables you to visualize the flow of any processing action as it is processed through your server. The data for each action, a span, includes possible error information and timing data. Traces are generated for COM_QUERY commands ...
https://dev.mysql.com/doc/refman/9.7/en/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), ...
https://dev.mysql.com/doc/refman/9.7/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (This is the same type of conversion performed by the CONVERT_TZ() ...
https://dev.mysql.com/doc/refman/9.7/en/triggers.html
Triggers do not activate for changes to tables made by APIs that do not transmit SQL statements to the MySQL Server. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the ...