Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profiling.html
Values are also truncated to 6 decimal places to display data in the same format as SHOW PROFILES and SHOW PROFILE statements. The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-summary-tables.html
Exceptions to this truncation behavior are noted in individual summary table sections. Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways. Each summary ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or TRUNCATE TABLE statement for that table to ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
If N is less than the length of the input string, the string is truncated to N characters. For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger arguments are rounded ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-statement-digest.html
This attempt might fail because the Performance Schema truncates long SQL_TEXT values. in_start_fresh BOOLEAN: Whether to truncate the Performance Schema events_statements_history_long and events_stages_history_long tables before starting. Traces ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-limitations.html
It does not support automatic rounding or truncation of the input data. It fails if the input data requires rounding or truncation in order to be loaded. If the table has instantly added/dropped column, call TRUNCATE before calling LOAD DATA with ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-embed-row.html
This topic contains the following sections: ML_EMBED_ROW Syntax Syntax Examples See Also ML_EMBED_ROW Syntax mysql> SELECT sys.ML_EMBED_ROW('Text'[, options]); options: JSON_OBJECT(keyvalue[, keyvalue] ...) keyvalue: { 'model_id', {'ModelID'} ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-embed-table.html
ML_EMBED_TABLE Syntax mysql> CALL sys.ML_EMBED_TABLE('InputTableColumn', 'OutputTableColumn'[, options]); options: JSON_OBJECT(keyvalue[, keyvalue] ...) keyvalue: { 'model_id', {'ModelID'} |'truncate', {true|false} |'batch_size', BatchSize ... The ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
The Navigator area of the sidebar contains options to manage the active MySQL connection. It also lists the schemas on the server for that connection. To access the Navigator area, open an existing connection (or create a new connection) from the ...
https://dev.mysql.com/doc/workbench/en/wbcopytables.html
--truncate-target: Executes a TRUNCATE TABLE command on each target table that is copied. wbcopytables is a command-line utility included in MySQL Workbench that enables you to copy table data from a supported source database server to MySQL. It is ...