Search Results
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-24.html
Bugs Fixed The MySQL Enterprise Monitor console did not take the time zone into account and displayed an incorrect time. Functionality Added or Changed Bugs Fixed Functionality Added or Changed The MySQL server, bundled with MySQL Enterprise ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-a-forecasting-model.html
The following data types for this column are supported: DATETIME, TIMESTAMP, DATE, TIME, and YEAR, or an auto-incrementing index. Therefore, the predict table must not overlap the datetime_index with the training table. For example, the predict ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-tomcat.html
The following instructions are based on the instructions for Tomcat-5.x, available at http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html which is current at the time this document was written. First, install the .jar file ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-shm-definition.html
(NDB 8.4.0) When receiving, the time to wait before sleeping, in microseconds. For optimum performance, you can define a spin time for the SHM transporter (ShmSpinTime parameter); this affects both the data node receiver thread and the poll owner ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-a-forecasting-model.html
The following data types for this column are supported: DATETIME, TIMESTAMP, DATE, TIME, and YEAR, or an auto-incrementing index. Therefore, the predict table must not overlap the datetime_index with the training table. For example, the predict ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
The effect of a violation depends on the statement being executed, as described later in this section. CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates to ... CREATE TABLE permits the core features of table and column CHECK constraints, for all storage ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
The MySQL HeatWave Advisor also provides a Query Insights feature, which provides runtimes for successfully executed queries, and runtime estimates for EXPLAIN queries, queries canceled using Ctrl+C, and queries that fail due to out of memory errors. This enhancement reduces memory allocation and deallocation operations, memory usage, and execution time for affected ...Runtime ... Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL HeatWave Advisor provides string ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-clone-progress-table.html
The clone_progress table shows progress information for the current or last executed cloning operation only. BEGIN_TIME A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning stage started. END_TIME A timestamp in ...The ...
https://dev.mysql.com/doc/refman/8.4/en/command-line-options.html
For example, the following command tells mysqladmin to ping the server 1024 times, sleeping 10 seconds between each ping: mysqladmin --count=1K --sleep=10 ping When specifying file names as option values, avoid the use of the ~ shell metacharacter.
https://dev.mysql.com/doc/refman/8.4/en/using-spatial-indexes.html
| +-----+---------------------------------------------------------------+ 20 rows in set (0.00 sec) Use EXPLAIN to check the way this query is executed: mysql> SET @poly = -> 'Polygon((30000 15000, 31000 15000, 31000 16000, 30000 16000, 30000 ...The ... The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE ...