Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-an-anomaly-detection-model.html
To detect anomalies in row data, you can run the ML_PREDICT_ROW or ML_PREDICT_TABLE routines. To detect anomalies in log data (MySQL 9.2.2 and later), you can only run the ML_PREDICT_TABLE routine. Requirements for Generating Predictions As of MySQL ...To generate predictions, use the sample data from the two anomaly detection datasets: credit_card_train and ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-channel-filter-rules.html
Table 8-1 Channel Filter Rules Filter Type Filter Value Details REPLICATE_DO_DB database Replicates the specified database. REPLICATE_IGNORE_TABLE database.table Restricts the replication of the specified table in the database. Channel Filter Rules ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-stopwords.html
To see the default InnoDB stopword list, query the Information Schema INNODB_FT_DEFAULT_STOPWORD table. The stopword table must have a single VARCHAR column named value. The following example demonstrates creating and configuring a new global ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks-handling.html
When modifying multiple tables within a transaction, or different sets of rows in the same table, do those operations in a consistent order each time. Add well-chosen indexes to your tables so that your queries scan fewer index records and set fewer ... This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
mysqlslap runs in three stages: Create schema, table, and optionally any stored programs or data to use for the test. --auto-generate-sql-add-autoincrement Command-Line Format --auto-generate-sql-add-autoincrement Type Boolean Default Value FALSE ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-optimization.html
Applications that monitor databases may make frequent use of Performance Schema tables. To write queries for these tables most efficiently, take advantage of their indexes. Tables that do not are those that normally contain few rows or are unlikely ...For example, include a WHERE clause that restricts retrieved rows based on comparison to specific values in an indexed ...
https://dev.mysql.com/doc/refman/8.4/en/processlist-access.html
Note An alternative implementation for SHOW PROCESSLIST is available based on the Performance Schema processlist table, which, like the threads table, does not require a mutex and has better performance characteristics. The threads table displays ...
https://dev.mysql.com/doc/refman/8.4/en/resignal.html
ERROR 1051 (42S02): Unknown table 'xx' Then execution enters the EXIT handler. ERROR 1051 (42S02): Unknown table 'xx' At this point, the contents of the first (current) and second (stacked) diagnostics areas are the same. ERROR 1051 (42S02): Unknown ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
Here is a simple example that associates a trigger with a table, to activate for INSERT operations. The trigger acts as an accumulator, summing the values inserted into one of the columns of the table. In this case, the trigger activates before each ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). (Bug #35205358) Data Dictionary Notes Attempting to upgrade a MyISAM table containing a mix of ...Now pruning continues in such cases, but with a warning printed in the error log stating that it was not possible to delete the missing audit log ...