PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
You must not delete the ibdata files that represent the InnoDB system tablespace. When you convert MyISAM tables that are large, frequently accessed, and hold vital data, investigate and consider the innodb_file_per_table and innodb_page_size ... If ...Handling Too-Long Or Too-Short Transactions Because MyISAM tables do not support transactions, you might not have paid much attention to the autocommit configuration option and the COMMIT and ROLLBACK ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tde-setup.html
Perform a rolling initial start (or restart) of all the data nodes (see Section 25.6.5, “Performing a Rolling Restart of an NDB Cluster”): Start each data node with --initial; in addition, supply either of the options --filesystem-password or ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
The innodb_data_file_path setting on the donor and recipient must specify the same number of data files of an equivalent size. mysql> SHOW VARIABLES LIKE 'innodb_page_size'; mysql> SHOW VARIABLES LIKE 'innodb_data_file_path'; If cloning encrypted or ...By default, the InnoDB system tablespace, redo logs, and undo tablespaces are cloned to the same locations that are configured on the donor (as defined by innodb_data_home_dir and innodb_data_file_path, innodb_log_group_home_dir, and innodb_undo_directory, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
When compression is working well for a data set, the size of the InnoDB data files (the file-per-table tablespace or general tablespace .ibd files) is 25% to 50% of the uncompressed size or possibly smaller. Compression and the InnoDB Redo Log Files ...Unlike compression performed by an application, or compression features of some other database management systems, InnoDB compression applies both to user data and to ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files-using-mysql.html
At startup, the server automatically generates server-side and client-side SSL certificate and key files in the data directory if the auto_generate_certs system variable is enabled, no SSL options other than --ssl are specified, and the server-side ... MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The server can autogenerate these files at startup, for MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
To ensure that all InnoDB mutex instances are instrumented and enabled, add the following performance-schema-instrument rule to your MySQL configuration file: performance-schema-instrument='wait/synch/mutex/innodb/%=ON' If you do not require wait ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
Rather than a single InnoDB table column to hold a composite data value, data is divided among three table columns (population, area_sq_km, and drive_side). The sample Python application inserts data into the multicol table and retrieves data for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
INNODB_DATAFILES INNODB_TABLESTATS INNODB_FOREIGN INNODB_COLUMNS INNODB_INDEXES INNODB_FIELDS INNODB_TABLESPACES INNODB_TABLESPACES_BRIEF INNODB_FOREIGN_COLS INNODB_TABLES The table names are indicative of the type of data provided: INNODB_TABLES ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data nodes. FileSystemPath: Path to directory where data node stores its data ...For ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
This script installs the innodb_memcache database with three required tables (cache_policies, config_options, and containers). get BB VALUE BB 10 16 GOODBYE, GOODBYE END quit If you shut down the MySQL server, which also shuts off the integrated ...