PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
The “non-strict” behavior lets you import a mysqldump file into a database that does not support compressed tables, even if the source database contained compressed tables. To import the dump file into a new database, and have the tables ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking.html
The parameter innodb_file_format_check affects only what happens when a database is opened, not subsequently. Conversely, the parameter innodb_file_format (which enables a specific format) only determines whether or not a new table can be created in ... To prevent possible crashes or data corruptions when InnoDB opens an ib-file set, it checks that it can fully support the file formats in use within the ib-file ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multi-versioning.html
Internally, InnoDB adds three fields to each row stored in the database: A 6-byte DB_TRX_ID field indicates the transaction identifier for the last transaction that inserted or updated the row. Update undo logs are used also in consistent reads, but ...It keeps information about old versions of changed rows to support transactional features such as concurrency and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
14.8.11.1.5 InnoDB Persistent Statistics Tables The persistent statistics feature relies on the internally managed tables in the mysql database, named innodb_table_stats and innodb_index_stats. row *************************** database_name: sakila ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/5.7/en/introduction.html
The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server. The following list describes some sections of particular interest in this manual: For a discussion of MySQL Database ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview.html
NDB Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “Network DataBase”).
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-all.html
--database=dbname, -d dbname Name of the database in which the table is found. ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-monitor.html
For more information, visit Comprehensive Monitoring and Compliance Management for MySQL Databases using Enterprise Manager. Use the database monitoring capabilities of the OCI Database Management service. For information about MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html
(See Section 2.1.5, “Installation Layouts”.) mysqld_safe expects one of the following conditions to be true: The server and databases can be found relative to the working directory (the directory from which mysqld_safe is invoked). If the server ... mysqld_safe is the recommended way to start a mysqld server on ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-upgrade-testing.html
Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled properly. (This is also useful for testing downgrades.) On the production server: $> ... When ...