Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-events.html
For more information about creating notification groups, see Chapter 22, Event Handlers. Table 26.1 Events Filter Controls Name Description Time Range Enables you to choose a time range. Table 26.2 Events List Columns Name Description Multi-select ... Advisors generate events if one, or more, of the defined thresholds are crossed by the monitored ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-troubleshoot.html
Move the files with supported formats to another folder, create a new PAR and run the VECTOR_STORE_LOAD command with the new PAR to load the vector embeddings into the vector store table again. If you find unsupported format files, then try one of ... This section describes some commonly encountered issues and errors for MySQL HeatWave GenAI and their ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-monitoring.html
You can monitor the status of MySQL HeatWave AutoML by querying the rapid_ml_status variable or by querying the ML_STATUS column of the performance_schema.rpd_nodes table. mysql> SHOW GLOBAL STATUS LIKE 'rapid_ml_status'; ...Before You Begin Review ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-1-0.html
MySQL HeatWave uses statistics based on minimum and maximum values to create zone maps for every primary key column. (WL #16414) MySQL HeatWave Auto Parallel Load now uses Autopilot to collect statistics about frequently used InnoDB and MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/account-activity-auditing.html
When a client connects successfully, the server authenticates the client to a particular row in this table. Its value is constructed from the User and Host columns of the user table row for the account. However, this value does not necessarily ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-transactional-storage.html
Data dictionary tables are created in a single InnoDB tablespace named mysql.ibd, which resides in the MySQL data directory. The data dictionary schema stores dictionary data in transactional (InnoDB) tables. Data dictionary tables are located in ...
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
Starting the MySQL server with the --skip-grant-tables option causes event_scheduler to be set to DISABLED, overriding any other value set either on the command line or in the my.cnf or my.ini file (Bug #26807). For SQL statements used to create, ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
The default return type of IF() (which may matter when it is stored into a temporary table) is calculated as follows: If expr2 or expr3 produce a string, the result is a string. The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/refman/8.4/en/key-space.html
In MyISAM tables, you can also prefix compress numbers by specifying the PACK_KEYS=1 table option when you create the table. This is for the worst case when all keys are inserted in sorted order and the table doesn't have any compressed keys. You ...