Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/devapi-connection-concepts.html
This section explains the concepts of connections and sessions as used by the X DevAPI. Code examples for connecting to a MySQL Document Store (see Using MySQL as a Document Store) and using sessions are provided. An X DevAPI session is a ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
| | | | Warning: Executing the generated script may alter column definitions and secondary engine flags in the schema | | | | Using SQL_MODE: ...| | Using current parallelism of 32 thread(s) as maximum for internal tables. If you have external data ...
https://dev.mysql.com/doc/refman/8.4/en/kill.html
KILL permits an optional CONNECTION or QUERY modifier: KILL CONNECTION is the same as KILL with no modifier: It terminates the connection associated with the given processlist_id, after terminating any statement the connection is executing. KILL ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html
However, you can switch to another supported major release series at any time by reconfiguring the configuration package you have installed. After returning to the command prompt, update package information from the MySQL APT repository with this ...
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/innodb-information-schema-examples.html
Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. Each session corresponds to a MySQL thread, and executes one transaction after another. For example, if the blocking_pid is 6, issue this query: ... This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
If the table has a foreign key relationship, foreign_key_checks must be disabled before executing DISCARD TABLESPACE. Also, you should export all foreign key related tables at the same logical point in time, as ALTER TABLE ... A schema mismatch ...
https://dev.mysql.com/doc/internals/en/myisam-files.html
A table can be closed during one of the following events: Out of space in table cache Someone executed flush tables MySQL was shut down flush_time expired (which causes an automatic flush-tables to be executed) When MySQL opens a table, it checks if ... Some notes about MyISAM file handling: If a table is never updated, MySQL will never touch the table files, so it would never be marked as closed or ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-add.html
It takes a single document or a list of documents as its argument, and is executed by the execute() function. The Collection.add() function is for storing documents in a collection, similar to the INSERT statement for an SQL database. The ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-instanceactivity-category.html
Queries (Per Second) The average number of statements executed by the server per second. Uptime The number of seconds that the server has been up. Uptime Since Flush Status The number of seconds since the most recent FLUSH STATUS statement. (The ...