Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-recommendation-model-types.html
Recommendation Models with Implicit Feedback Recommendation models that use implicit feedback collect data on users' behavior, such as past purchases, clicks, and view times. MySQL HeatWave AutoML derives rankings based on ratings from implicit ...
https://dev.mysql.com/doc/refman/8.4/en/lateral-derived-tables.html
In accordance with the SQL standard, MySQL always treats a join with a table function such as JSON_TABLE() as though LATERAL had been used. A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM clause. A ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
Otherwise, MySQL locks the table during the time OPTIMIZE TABLE is running. To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-summary-tables.html
Example wait event summary information: mysql> SELECT * FROM performance_schema.events_waits_summary_global_by_event_name\G ... row *************************** EVENT_NAME: wait/synch/mutex/sql/BINARY_LOG::LOCK_index COUNT_STAR: 8 SUM_TIMER_WAIT: ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-special-options.html
--safe-replica-backup-timeout=SECONDS For a replication setup, the option specifies the time (in seconds) mysqlbackup will wait for Replica_open_temp_tables to become “0” (which happens when no temporary tables are open) to complete the backup ...This option is not compatible with the --no-locking option; using both options together will make mysqlbackup throw an ... These options are for backing up ...
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
Sometimes, the driver might eventually fall back to the original host automatically before the client application continues to run, in which case the host switch is transparent and the client application will not even notice it. The failover is ...A ...
https://dev.mysql.com/doc/connectors/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/mysql-em-plugin/en/myoem-metric-mysqlserver-dmlstatementactivity-category.html
However, prepared statements take time to prepare and consume memory in the MySQL server until they are closed, so it is important to use them properly. However, prepared statements take time to prepare and consume memory in the MySQL server until ...Stmt Close (Delta) The total number of DEALLOCATE PREPARE statements, or mysql_stmt_close() calls, ...
https://dev.mysql.com/doc/connector-j/en/connector-j-config-failover.html
Sometimes, the driver might eventually fall back to the original host automatically before the client application continues to run, in which case the host switch is transparent and the client application will not even notice it. The failover is ...A ...
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 ...