Search Results
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
This occurs because t2 is inserted into within the trigger, so the READ request is converted to a WRITE request. LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ... lock_type: { READ [LOCAL] | WRITE } ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
You can optionally specify an INSERT_METHOD option to control how inserts into the MERGE table take place. If you specify no INSERT_METHOD option or if you specify it with a value of NO, inserts into the MERGE table are not permitted and attempts to ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Client 2: INSERT INTO x VALUES(1); The statement requests and blocks waiting for a write lock on x. Client 2: INSERT INTO x VALUES(1); The statement requests and blocks waiting for a write lock on x. MySQL uses metadata locking to manage concurrent ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. --join=big_tbl_name, -j big_tbl_name Command-Line Format --join=big_tbl_name Type String Join all tables named on the command line into a single ...This results in much better performance when accessing individual rows, because you only have to uncompress exactly one ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-binary.html
This section covers the steps necessary to install the correct executables for each type of Cluster node from precompiled binaries supplied by Oracle. For setting up a cluster using precompiled binaries, the first step in the installation process ...
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== '/*!*/; ### INSERT INTO ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
The permissible values are read (scan tables), write (insert into tables), key (read primary keys), update (update primary keys), or mixed (half inserts, half scanning selects). mysqlslap --delimiter=";" --number-of-queries=10 --query="use ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam-bulk-data-loading.html
LOAD DATA performs the preceding optimization automatically if the MyISAM table into which you insert data is empty. These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT Statements”.
https://dev.mysql.com/doc/refman/8.4/en/parenthesized-query-expressions.html
parenthesized_query_expression: ( query_expression [order_by_clause] [limit_clause] ) [order_by_clause] [limit_clause] [into_clause] query_expression: query_block [set_op query_block [set_op query_block ...]] [order_by_clause] [limit_clause] ...An ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
List partitioning in MySQL is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be explicitly defined. The chief difference between the two types of partitioning is that, in list partitioning, each ...