Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
# at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ' fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ== '/*!*/; ... # at 302 ...
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
Whether the optimizer actually does so depends on whether reading the index is more efficient than a table scan if columns not in the index must also be read. In that case, scanning an entire index and looking up table rows to find columns not in ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH (expr) clause, where expr is an expression that returns an integer. In addition, you most likely want to follow this with ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-subpartitions.html
Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned table. Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) ...Each of these partitions—p0, p1, and p2—is further divided into 2 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-restrictions.html
If you save event information in another table, you should not assume that the original events remain available later. For example, if you select events from a performance_schema table into a temporary table, intending to join that table with the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-filtering.html
The threads table contains a row for each server thread. For the Performance Schema to monitor a thread, these things must be true: The thread_instrumentation consumer in the setup_consumers table must be YES. Monitoring occurs only for those ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. The in-memory tables become effective for access control at that point. If you modify the grant ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-restrictions.html
When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as InnoDB. This restriction is due to the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
gtid_executed_compression_period: Compress gtid_executed table each time this many transactions have occurred. Replica_open_temp_tables: Number of temporary tables that replication SQL thread currently has open. replicate-do-table: Tells replication ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
Channel specific replication filters are particularly useful in a multi-source replication topology when the same database or table is present on multiple sources, and the replica is only required to replicate it from one source. Overview of ...