Search Results
https://dev.mysql.com/doc/refman/8.4/en/compressed-format.html
Compressed tables have the following characteristics: Compressed tables take very little disk space. The header for a row takes up one to three bytes depending on the biggest row in the table. Note While a compressed table is read only, and you ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
External Tables When MySQL HeatWave loads data and creates a table from a file in Object Storage, it is an external Lakehouse table. Lakehouse Engine The lakehouse storage engine allows you to create tables that point to external data sources. As of ...While Lakehouse provides in-memory query processing on data in Object Storage, it does not load data into a DB System ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
db_name is the name of the database where the table into which to import the data is found; file_name is the name of the CSV file from which to read the data; this must include the path to this file if it is not in the current directory. The name of ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
Note Named time zones can be used only if the time zone information tables in the mysql database have been created and populated. The MySQL installation procedure creates the time zone tables, but does not load them. This section describes the time ...Time zone offsets are also supported for inserted datetime values; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”, for more ...
https://dev.mysql.com/doc/ndbapi/en/overview-ndbinterpretedcode-using.html
Both of these methods require that the table being operated on was specified when creating the NdbInterpretedCode object for which they are called. The space required by each of these methods is shown in the following table: Table 1.1 ... The next ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
LDAP pluggable authentication provides these capabilities: External authentication: LDAP authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables in LDAP directories. The following tables show the ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ps-tables.html
Thread names are shown in the name column of the threads and setup_threads tables using the format prefix/plugin_name/thread_name. Using the thread ID or OS thread ID for a given thread in the threads or setup_threads table, it is possible to obtain ... NDB provides information in the MySQL Performance Schema about ndbcluster plugin threads and instrumenting for transaction batch ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-details.html
Table 3-9 MySQL DB System Backup Details Field Description Name The name of the backup State The state of the backup CREATING: Resources are being reserved for the DB System backup and the backup is being created. Table 3-7 Tabs on the MySQL DB ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
mysqlslap runs in three stages: Create schema, table, and optionally any stored programs or data to use for the test. --create=value Command-Line Format --create=value Type String The file or string containing the statement to use for creating the ...Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...For example, in a replication setup, perhaps your source server uses InnoDB tables for maximum safety, but the replica servers use other storage engines for speed at the expense of durability or ...