Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profiling.html
Performance Schema displays event timer information in picoseconds (trillionths of a second) to normalize timing data to a standard unit. In the following example, TIMER_WAIT values are divided by 1000000000000 to show data in units of seconds. The ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the source. If a GTID was assigned for the transaction, the GTID is persisted atomically at commit time by writing it to the binary log at the ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-general-information.html
It was developed according to the specifications of the SQL Access Group and defines a set of function calls, error codes, and data types that can be used to develop database-independent applications. ODBC (Open Database Connectivity) provides a ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-general-information.html
It was developed according to the specifications of the SQL Access Group and defines a set of function calls, error codes, and data types that can be used to develop database-independent applications. ODBC (Open Database Connectivity) provides a ...
https://dev.mysql.com/doc/refman/8.4/en/using-systemd.html
This script assists in creating the error log file only if the log location matches a pattern (/var/log/mysql*.log for RPM platforms, /var/log/mysql/*.log for Debian platforms). In other cases, the error log directory must be writable or the error ...If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-vault.html
By using the vault, you need not enter credentials every time MySQL Workbench attempts to connect to a server. The vault provides a convenient secure storage for passwords used to access MySQL servers. For example, a local connection might use ...
https://dev.mysql.com/doc/internals/en/plugins.html
For example, several storage engines have been converted to plugins, and they can be selected or disabled at configuration time. Beginning with MySQL 5.1, the server supports a plugin architecture for loading plugins. You can build a plugin as ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
Symptoms of corrupted tables include queries that abort unexpectedly and observable errors such as these: Can't find file tbl_name.MYI (Errcode: nnn) Unexpected end of file Record file is crashed Got error nnn from table handler To get more ... The ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query.html
Table 4.37 deletePersistentAll() Parameter Description return the number of instances deleted 4.3.1.19.9 execute(Map<String, ?>) public abstract Results<E> execute(Map<String, ?> parameters); Execute the query with one or more named parameters. A ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
If any argument has a longitude or latitude that is out of range, an error occurs: If a longitude value is not in the range (−180, 180], an ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE error occurs. If a latitude value is not in the range [−90, 90], ... Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text ...