Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
This section describes some internal implementation details about compression for InnoDB tables. These properties make this compression technique unsuitable for use in an update-intensive database system. When compression is working well for a data ...The information presented here may be helpful in tuning for performance, but is not necessary to know for basic use of ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(WL #16221) Microsoft Windows: Third party DLL files on which MySQL plugins depend are located, when installed, in the same directory as the MySQL executables. The default Windows behavior is to look for dependences in the same directory as the ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-access-linked-tables.html
You can use Microsoft Access as a front end to MySQL by linking tables within your Microsoft Access database to tables that exist within your MySQL database. When a query is requested on a table within Access, ODBC is used to execute the queries on ...Figure 5.24 Get External Data: Link To ODBC Database Option Chosen The Select Data Source dialog box appears; it lists the defined data sources for any ODBC drivers installed on your ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html
You can use Microsoft Access as a front end to MySQL by linking tables within your Microsoft Access database to tables that exist within your MySQL database. When a query is requested on a table within Access, ODBC is used to execute the queries on ...Figure 6.13 Get External Data: Link To ODBC Database Option Chosen The Select Data Source dialog box appears; it lists the defined data sources for any ODBC drivers installed on your ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new ...MySQL Enterprise Backup The MySQL Enterprise Backup product lets you back up a running MySQL database with minimal disruption to operations while producing a consistent snapshot of the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
A full-text index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX. When incoming documents are tokenized, the individual words (also referred to as “tokens”) are inserted into the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-generated-columns.html
As of MySQL 9.5.1, you have the option to include stored generated columns when creating external Lakehouse tables. To learn more about generated columns, see CREATE TABLE and Generated Columns. Before You Begin Prepare to create external tables by ...col_name data_type [GENERATED ALWAYS] AS (expr) STORED [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'], ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
This table contains sys schema configuration options, one row per option. Configuration changes made by updating this table persist across client sessions and server restarts. The sys_config table has these columns: variable The configuration ...