Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
Data and indexes for each partition can be assigned to a specific directory using the DATA DIRECTORY and INDEX DIRECTORY options for the PARTITION clause of the CREATE TABLE statement used to create the partitioned table. For more information about ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
The following options for the CREATE TABLE statement: AUTOEXTEND_SIZE AVG_ROW_LENGTH CHECKSUM COMPRESS CONNECTION DATADIR DELAY_KEY_WRITE ENCRYPT INDEXDIR INSERT_METHOD KEY_BLOCK_SIZE MAX_ROWS MIN_ROWS PACK_KEYS PASSWORD ROW_FORMAT STATS_AUTO_RECALC ...Unsupported Items MySQL HeatWave Lakehouse does not support the following: DML statements: INSERT UPDATE DELETE REPLACE The CREATE TABLESPACE ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
The following statement would not work because it refers to a table both as my_table and as MY_TABLE: mysql> SELECT * FROM my_table WHERE MY_TABLE.col=1; Partition, subpartition, column, index, stored routine, event, and resource group names are not ...Note Although database, table, and trigger names are not case-sensitive on some platforms, you should not refer to one of these using different cases within the same ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
Note that when you do mysqladmin shutdown on a remote server, the mysqld server is still available for a while after mysqladmin returns, until all statement-processing has stopped and all index changes have been flushed to disk. You can also use the ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbconfiguration-category.html
Adaptive Hash Index Enabled Whether InnoDB adaptive hash indexes are enabled or disabled. Buffer Pool Size The size in bytes of the memory buffer InnoDB uses to cache data and indexes of its tables. Change Buffering Whether InnoDB performs change ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index record. Default undo tablespaces are created at initialization time to provide a ...A minimum of two undo tablespaces is required to support automated truncation of undo ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
InnoDB tables require a FULLTEXT index on all columns of the MATCH() expression to perform boolean queries. Boolean queries against a MyISAM search index can work even without a FULLTEXT index, although a search executed in this fashion would be ...
https://dev.mysql.com/doc/internals/en/binary-log-overview.html
It also contains statements that potentially could have updated it (for example, a DELETE which matched no rows), unless row-based logging is used. Statements are stored in the form of "events" that describe the modifications. The binary log also ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-sql.html
Thus, there are "statement" routines like sql_delete.c, sql_load.c, and sql_help.c, which take care of the DELETE, LOAD DATA, and HELP statements. If you remember your manual, you know that you must pronounce this: ess queue ell. The "parser" ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-firewall.html
MySQL Enterprise Firewall is an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against allowlists of accepted statement patterns. Each MySQL account registered with the ...