Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
All indexes of a table (including the clustered index) are compressed using the same page size, as specified in the CREATE TABLE or ALTER TABLE statement. Table attributes such as ROW_FORMAT and KEY_BLOCK_SIZE are not part of the CREATE INDEX syntax ...Thus, compression applies only to tables (and indexes) stored in file-per-table or general ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
Where practical, wrap several related data change operations into a single transaction, by issuing SET AUTOCOMMIT=0 or a START TRANSACTION statement, followed by a COMMIT statement after making all the changes. Alternatively, for transactions that ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. Normally, greedy search is used, but since the ...row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This can be useful mark when several traces are ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
Can I preserve a results tab rather than have it refresh every time I execute a statement? A.5. The SQL statement history is stored as plain text on your system under your user's MySQL Workbench configuration path in the sql_history directory. These ... FAQ Categories Basic Usage MySQL Workbench Functionality Data Management General Basic Usage ...
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
Com_show_binary_log_status: Count of SHOW BINARY LOG STATUS statements; use instead of Com_show_master_status. Com_change_master: Count of CHANGE REPLICATION SOURCE TO and CHANGE MASTER TO statements. Com_show_slave_status: Count of SHOW REPLICA ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
For this reason, when enabling generated invisible primary keys in this way, you cannot create a table having a column named my_row_id unless the table creation statement also specifies an explicit primary key. To make the generated invisible ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
If the LOCK clause specifies a less restrictive level of locking than is permitted for a particular DDL operation, the statement fails with an error. Use this clause when you do not expect the default locking level of the DDL statement to cause any ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-triggers.html
With statement-based replication, triggers executed on the source also execute on the replica. If you want triggers to execute on both the source and the replica, perhaps because you have different triggers on the source and replica, you must use ...With row-based replication, triggers executed on the source do not execute on the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
Define a Data Placement Key Defining a data placement key requires adding a column comment with the data placement keyword string: RAPID_COLUMN=DATA_PLACEMENT_KEY=N where N is an index value that defines the priority order of data placement keys.
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-mecab.html
In addition to tokenizing text into meaningful words, MeCab indexes are typically smaller than ngram indexes, and MeCab full-text searches are generally faster. Verify that the MeCab parser plugin is loaded using the SHOW PLUGINS statement. Creating ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...