Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-asyncio.html
job_mysql: Connects to a MySQL server to perform operations such as queries and stored procedures. Asynchronous MySQL Queries This is a similar example that uses MySQL queries instead of generic jobs. Installing Connector/Python also installs the ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
The InnoDB source files are the best place to look for information about internals of the file structure that MySQLers can optionally use for transaction support. But when you first look at all the subdirectories and file names you'll wonder: Where ...
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...
MySQL Enterprise Monitor 8.0 Release Notes :: Changes in MySQL Enterprise Monitor 8.0.0 (2018-04-19)
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-0.html
Important It is not possible to upgrade to MySQL Enterprise Monitor 8.0 from versions preceding MySQL Enterprise Monitor 3.3. To upgrade an older version, it is recommended you first upgrade to MySQL Enterprise Monitor 4.0 before running the MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-exec-stats-table.html
For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each query. The rpd_exec_stats table stores query execution statistics produced by MySQL HeatWave nodes in JSON format. One row of ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model catalog. To learn how to use ML_MODEL_IMPORT to share models, see Share a Model. ML_MODEL_IMPORT Overview ML_MODEL_IMPORT Syntax ML_MODEL_IMPORT Parameters Syntax ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to group values into subsets. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to ...
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
Normally, this is one of the last queries in the log file just before the server restarts. Run the command mysqladmin -i 5 status or mysqladmin -i 5 -r status in a separate window to produce statistics while running other queries. Each MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/explain-extended.html
The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following EXPLAIN. Extended information is available for SELECT, DELETE, INSERT, REPLACE, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
This issue does not occur for queries that use index or table scans, even against NDB tables having BLOB or TEXT columns. You can help minimize issues with shared read locks by avoiding queries that use unique key lookups that retrieve BLOB or TEXT ... A number of limitations exist in NDB Cluster with regard to the handling of ...