Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-runtimes-in-95th-percentile.html
rows_sent The total number of rows returned by occurrences of the statement. rows_sent_avg The average number of rows returned per occurrence of the statement. rows_examined The total number of rows read from storage engines by occurrences of the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
This table contains sys schema configuration options, one row per option. set_time The timestamp of the most recent modification to the row. set_by The account that made the most recent modification to the row. The value is NULL if the row has not ...Configuration changes made by updating this table persist across client sessions and server ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-latency.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. rows_sent The total number of rows returned by statements for the user. The ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-type.html
By default, rows are sorted by user and descending total latency. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. rows_sent ... These views summarize information about statements executed, grouped by user and statement ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
row *************************** CATALOG_NAME: def SCHEMA_NAME: mysql DEFAULT_CHARACTER_SET_NAME: utf8mb4 DEFAULT_COLLATION_NAME: utf8mb4_0900_ai_ci SQL_PATH: NULL DEFAULT_ENCRYPTION: NO *************************** 2. row *************************** ...It contains tables that store information required by the MySQL server as it ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
An “account” in this context corresponds to a row in the mysql.user system table. That is, a connection is assessed against the User and Host values in the user table row that applies to the connection. For example, an account ... One means of ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-list-backups.html
list backups [{--backupid=|-I }backup_id] [-all|-a] cluster_name list backups [{--backupid=|-I }backup_id] [--agent|-A] site_name Without the --agent option, the command lists all backups of the MySQL NDB Cluster named cluster_name that are known ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-insert-id.html
In the case of a multiple-row INSERT statement, mysql_insert_id() returns the first automatically generated AUTO_INCREMENT value that was successfully inserted. SELECT statement is executed, and no automatically generated value is successfully ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-predictions-ml-predict-table.html
If ML_PREDICT_TABLE takes a long time to complete, manually limit input tables to a maximum of 1,000 rows. mysql> SELECT * FROM table_name LIMIT N; Replace table_name with your own table name, and N with the number of rows from the table you want to ... ML_PREDICT_TABLE generates predictions for an entire table of trained ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-content.html
row *************************** id: 1 Output: {"text": "\nMySQL is an open-source relational database management system (RDBMS) that allows users to store, manage, and retrieve data in a structured format. row *************************** id: 2 ...