Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate.html
Some worry that AI could lead to job displacement, as machines become more capable of performing tasks traditionally done by humans. The ML_GENERATE routine uses the specified large language model (LLM) to generate text-based content as a response ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-0-0.html
(WL #15817) MySQL HeatWave MySQL HeatWave includes improvements to query optimization that lead to better performance for low latency queries in MySQL HeatWave and MySQL HeatWave Lakehouse. MySQL HeatWave AutoML MySQL HeatWave Autopilot MySQL ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-0.html
With this feature, you can access and utilize hyperparameter information to refine your models, leading to improved performance and accuracy. Note MySQL HeatWave User Guide has been restructured and improved to provide better visibility of ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-1.html
By injecting actual cardinalities from previous query executions into subsequent optimizations, MySQL HeatWave can produce more accurate and efficient plans, leading to significant performance improvements. These release notes were created with the ...
https://dev.mysql.com/doc/connector-j/en/connecting-using-kerberos.html
Kerberos is a ticket-based server-client mutual authentication protocol that is supported by the MySQL Server (commercial versions only) . Support for Kerberos is implemented by Connector/J using the GSS-API, JAAS API, and JCA API; providers for ...
https://dev.mysql.com/doc/connector-j/en/connector-j-config-failover.html
This, however, may lead to unexpected results: for example, if the driver is connected to the primary host with read/write access mode and it fails-over to a secondary host in read-only mode, further attempts to issue data-changing queries will ...A ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-high-availability-and-clustering.html
This tends to work better than round-robin, as the randomness will somewhat account for spreading loads where requests vary in response time, while round-robin can sometimes lead to overloaded nodes if there are variations in response times across ... autoReconnect Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect before the next query issued on the connection in a new ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
If you create a new connection every time a thread needs one rather than using connection pooling, your application's resource usage can be wasteful, and it could lead to unpredictable behaviors for your application when it is under a heavy load.
https://dev.mysql.com/doc/refman/8.4/en/alter-table-generated-columns.html
This can lead to inconsistent data being returned and unexpectedly failed statements. ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and CHANGE. CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
When sampling user data as part of building a histogram, not all values are read; this may lead to missing some values considered important. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N ...