Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The Performance Schema autosizes the value of N during server startup. To set the table size explicitly, set the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. To set the table size explicitly, set the performance_schema_events_statements_history_long_size system variable at ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The Performance Schema autosizes the value of N is autosized at server startup. To set the table size explicitly, set ... The events_transactions_history_long table contains the N most recent transaction events that have ended globally, across all ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The Performance Schema autosizes the value of N during server startup. To set the table size explicitly, set the ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-rag-table.html
Syntax Examples Running retrieval-augmented generation in a batch of 10: mysql> CALL sys.ML_RAG_TABLE("demo_db.input_table.Input", "demo_db.output_table.Output", JSON_OBJECT("vector_store", JSON_ARRAY("demo_db.demo_embeddings"), "model_options", ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql-custom-listeners.html
NoIndex = 1, BadIndex = 2, SkippedRows = 3, SkippedColumns = 4, FieldConversion = 5. To build custom listeners that work with the MySQL Connector/NET Trace Source, it is necessary to understand the key methods used, and the event data formats used.
https://dev.mysql.com/doc/internals/en/position.html
Purpose Provide the MySQL server with position/offset information for last-read row. ref_length in the above case is the size needed to store current_position. If you are using offsets to mark rows, then current_position should be the offset.
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-basic-read.html
This example illustrates basic retrieval of one or more rows from an NDB table using the NdbRecord interface and an NdbScanOperation. We assume that you have already created and populated the basic table, perhaps using the row insertion example ...
https://dev.mysql.com/doc/ndbapi/en/overview-ndbinterpretedcode-using.html
Method Buffer (words) Request message (words) load_const_null() 1 1 load_const_u16() 1 1 load_const_u32() 2 2 load_const_u64() 3 3 NdbInterpretedCode Methods for Copying Values Between Registers and Table Columns NdbInterpretedCode provides two ...
https://dev.mysql.com/doc/refman/8.4/en/delete-optimization.html
To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete all ...Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table ...