Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-ioglobalbyfilebylatency-category.html
Misc Latency The total wait time of timed other IO events for the file. Read Latency The total wait time of timed read IO events for the file. Total Latency The total wait time of timed IO events for the file. Write Latency The total wait time of ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-mysql-configuration-details.html
Last updated The date and time the configuration was last updated. If the configuration has never been updated, it shows the date of time of its creation. Last updated: The date and time the configuration was last updated. If the configuration has ... MySQL Configuration Details 19.3 MySQL Configuration Details Follow these steps to view details of your MySQL configurations: In the MySQL HeatWave Console, select the Resources tab, and then click the Configurations ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-index-statistics.html
select_latency The total wait time of timed reads using the index. insert_latency The total wait time of timed inserts into the index. update_latency The total wait time of timed updates in the index. delete_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
Returns 1 if the lock was obtained successfully, 0 if the attempt timed out (for example, because another client has previously locked the name), or NULL if an error occurred (such as running out of memory or the thread was killed with mysqladmin ...
https://dev.mysql.com/doc/internals/en/capability-negotiation.html
They can agree on: use of status flags use of SQL states for error-codes authentication methods SSL support Compression . To permit an old client to connect to newer servers, the initial handshake contains the MySQL Server version the server's ...
https://dev.mysql.com/doc/refman/8.4/en/regexp.html
To control the maximum number of steps performed by the engine (and thus indirectly the execution time), set the regexp_time_limit system variable. Because this limit is expressed as number of steps, it affects execution time only indirectly. A - ...
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
With the mysql client, to use a character set different from the default, you could explicitly execute a SET NAMES statement every time you connect to the server (see Client Program Connection Character Set Configuration). Connect-Time Error ...The ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight reports. With efficient use of the InnoDB buffer pool, MyISAM key cache, and the ...NDB Cluster supports a join pushdown optimization whereby a qualifying join is sent in its entirety to NDB Cluster data nodes, where it can be distributed among them and executed in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-show-tables.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges at routine execution time, as described later in this section. For statements that can be determined at function definition time to return a ...By default, MySQL automatically grants the ALTER ROUTINE and EXECUTE privileges to the routine ...