Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table size. Of the tables that contain stage event rows, events_stages_current is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-tables.html
The Performance Schema tables provide a container to store progress data, but make no assumptions about the semantics of the metric itself: A “work unit” is an integer metric that increases over time during execution, such as the number of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
If the mysql.gtid_executed table cannot be accessed for writes, and the binary log file is rotated for any reason other than reaching the maximum file size (max_binlog_size), the current binary log file continues to be used. If the ... A global ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-fetchall.html
Syntax: rows = cursor.fetchall() The method fetches all (or all remaining) rows of a query result set and returns a list of tuples. If no more rows are available, it returns an empty list.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchall.html
Syntax: rows = cursor.fetchall() The method fetches all (or all remaining) rows of a query result set and returns a list of tuples. If no more rows are available, it returns an empty list.
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
DELETE if you are deleting rows from a table that has foreign keys with ON DELETE CASCADE properties. SELECT with no ORDER BY, the SELECT may return rows in a different order (which results in a row having different ranks, hence getting a different ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
Instead, the rows from the underlying MyISAM tables are copied into the altered table, which then uses the specified storage engine. However, use of the AUTO_INCREMENT table option for that MyISAM table has no effect for inserts into the MERGE table ... The following are known problems with MERGE tables: MERGE child tables are locked through the parent ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_DELETED: Stores rows that are deleted from the FULLTEXT index for an InnoDB table. INNODB_FT_INDEX_CACHE: Provides token information about newly inserted rows in a FULLTEXT index. mysql> SET GLOBAL innodb_ft_aux_table = 'test/articles'; ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-character.html
For column values less than 8KB in size, use binary VARCHAR instead of BLOB. When MySQL retrieves any value from a row, it reads a data block containing all the columns of that row (and possibly other adjacent rows). Keeping each row small, with ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
By limiting the search, it is possible to expend much less time and effort in finding matching rows than by scanning all partitions in the table. An INSERT statement also accesses only one partition per inserted row; this is true even for a table ...