Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-io-global-by-file-by-latency.html
These views summarize global I/O consumers to display time waiting for I/O, grouped by file. total_latency The total wait time of timed I/O events for the file. read_latency The total wait time of timed read I/O events for the file. write_latency ...The io_global_by_file_by_latency and x$io_global_by_file_by_latency views have these columns: file The file path ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
Rewriting Prepared Statements Prepared statements are rewritten at parse time (that is, when they are prepared), not when they are executed later. This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/internals/en/implementing-store-lock-method.html
If the argument of store_lock is TL_IGNORE, it means that MySQL requests the handler to store the same lock level as the last time. The [custom-engine.html#custom-engine-api-reference-store_lock store_lock()] method is called before any reading or ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
NDB_COLUMN can be used in a column comment to set the size of the blob parts table column used for storing parts of blob values by NDB to its maximum. Setting a value greater than 29980 raises an error; setting a value less than 1 is allowed, but ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. --wait, -w Command-Line Format --wait Type Boolean Default Value false Instead of terminating with an ... The options described in this section can be used for any type of table maintenance operation performed by ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
innodb_log_wait_for_flush_spin_hwm: Defines the maximum average log flush time beyond which user threads no longer spin while waiting for flushed redo. On a system with a multi-core processor, a value of 150 represents 100% usage of one CPU core ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Do stored procedures have a statement for raising application errors? A.4.13. Do the preceding limitations affect the ability of MySQL to do point-in-time recovery? A.4.28. Can a stored procedure call a trigger? A stored procedure can execute an SQL ...Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-batch.html
When a batch is executed, all operations are executed; the callback for each operation is called when that operation is executed (operations are not performed in any particular order). A batch is executed in the context of the session's current ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-cloud-options.html
Minimum value: 64 Maximum value: 3072 on 32-bit machines, 5120 on 64-bit machines Default value: 2048 Note One and only one of --cloud-tempauth-url, --cloud-identity-url, --cloud-basicauth-url, or --cloud-storage-url should be used when accessing a ...The maximum number of segments a backup can have is determined by the object storage service, and the maximum size of the segments is controlled by this ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ...This ...