Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-summarize-content.html
The following sections in this topic describe how to summarize exiting content using the GenAI: Before You Begin Summarizing Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and privileges. For Running Batch ...Summarizing Content To summarize text, perform the following steps: To define the text that you want to summarize, set the @text variable: mysql> SET @text="TextToSummarize"; Replace TextToSummarize with the text that you want to ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-26.html
Deprecation and Removal Notes Pluggable Authentication Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes The TLSv1 and TLSv1.1 connection protocols now are deprecated and support for them is subject to removal in a future ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-default-users-roles.html
Display Query Analyzer Examples: maps to View actual (example) queries in previous versions. Any user with View actual (example) queries defined, is added to the Display Query Analyzer Examples role. For example, if a user is assigned to the dba ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-grahs-timeseries-controls.html
Graph Query Analysis Graph Query Analysis enables you to examine the queries which were running during specific intervals. Click the database icon to open the Query Analyzer's Browse Queries page. Browse Queries displays all the queries which were ... This section describes the controls available on the All Timeseries Graphs ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-introduction-server.html
Analyzing the SQL queries performed on the monitored instance, in real-time, using the Query Analyzer. MySQL Enterprise Service Manager is the central hub of the MySQL Enterprise Monitor installation and is responsible for the following: Receiving ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-silos.html
Real-time Analytics Without ETL Analytics queries always access the latest data, as updates from transactions in MySQL automatically replicate in real time to MySQL HeatWave. This data is then loaded into the memory of the MySQL HeatWave Cluster, ...
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/information-functions.html
For example, instead of these queries: SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE id > 100 LIMIT 10; SELECT FOUND_ROWS(); Use these queries instead: SELECT * FROM tbl_name WHERE id > 100 LIMIT 10; SELECT COUNT(*) FROM tbl_name WHERE id > 100; ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-example.html
The following example illustrates how an error can occur when a lock request causes a deadlock. Client A enables innodb_print_all_deadlocks, creates two tables, 'Animals' and 'Birds', and inserts data into each. Thererfore, the previous read-only ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of information using the techniques from Section 17.17, “InnoDB Monitors”, setting up InnoDB monitors ...