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/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN privilege (or ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
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/replication-options-replica.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID in the range from 1 to 232 − 1. To specify more than one database, use this option multiple times, once for each database; however, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-uri.html
This topic contains the following sections: Before You Begin Types of URIs URI Parameters CREATE TABLE Statement JSON Syntax and SQL Syntax OCIFS URI Examples PAR URI Examples Native URI Examples What's Next Before You Begin To use URIs, you require ... To load data manually using uniform resource identifiers (URI), which is available as of MySQL 9.3.1 and supported in MySQL HeatWave on OCI only, review the following examples for different ways to set them ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
Optimizer statistics are persisted to disk when innodb_stats_persistent=ON or when individual tables are defined with STATS_PERSISTENT=1. Formerly, optimizer statistics were cleared when restarting the server and after some other types of ... The ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM ...However, if the user's privileges on t are subsequently revoked, the user can continue to access t by doing so ...