Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-features-qrti.html
It is a "quality of service" measurement for each query, and uses the Apdex formula for that calculation: Apdex on Wikipedia. Reading QRTi Values The queries listed on the Query Analyzer page also have a color-coded pie chart representing a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-timezone.html
By default, source and replica servers assume that they are in the same time zone. If you are replicating between servers in different time zones, the time zone must be set on both source and replica. Otherwise, statements depending on the local ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.point.html
You can restore your database server to its state at an arbitrary time using the binary log files included in the backups. The process assumes that following conditions are met: The backed-up MySQL Server has had its binary logging enabled (which ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tzinfo-to-sql.html
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. It is used on systems that have a zoneinfo database (the set of files describing time zones). One likely location for these files is the /usr/share/zoneinfo directory ...
https://dev.mysql.com/doc/refman/8.4/en/fractional-seconds.html
MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-pitr.html
Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was made. Performing point-in-time recovery of NDB Cluster ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-date-handling.html
The binary (prepared statement) protocol enables you to send and receive date and time values (DATE, TIME, DATETIME, and TIMESTAMP), using the MYSQL_TIME structure. The members of this structure are described in Section 6.2, “C API Prepared ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-graphs-time-series-data-aggregation.html
When you upgrade to MySQL Enterprise Monitor 3.4, all existing timeseries data is aggregated when the upgraded MySQL Enterprise Service Manager first starts. A progress bar is displayed on the user interface, adjacent to the system status bar, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
This topic describes how to use the EXPLAIN statement to analyze query execution and verify whether a query is offloaded to MySQL HeatWave for accelerated processing. To learn how to download the sample database, see AirportDB Analytics Quickstart.
https://dev.mysql.com/doc/refman/8.4/en/timezone-problems.html
If you have a problem with SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. This should be done for the environment in which the server runs (for example, in mysqld_safe or ...