Search Results
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-tablespaces-brief-table.html
The INNODB_TABLESPACES_BRIEF table provides space ID, name, path, flag, and space type metadata for file-per-table, general, undo, and system tablespaces. Possible values include General for InnoDB general tablespaces, Single for InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-background.html
Compression is especially valuable for read-intensive applications, on systems with enough RAM to keep frequently used data in memory. The different page size requires that the table be placed in a file-per-table tablespace or general tablespace ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-disk-io.html
There are two read-ahead heuristics in InnoDB: In sequential read-ahead, if InnoDB notices that the access pattern to a segment in the tablespace is sequential, it posts in advance a batch of reads of database pages to the I/O system. In random ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-optimize-tablespace-page-allocation.html
You can disable innodb_extend_and_initialize on Linux systems to avoid physically writing NULLs to newly allocated tablespace pages. On non-Linux systems and Windows, InnoDB allocates new pages to the tablespace and physically writes NULLs to those ... You can optimize how InnoDB allocates space to file-per-table and general tablespaces on ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-multiple_io_threads.html
The default value for innodb_read_io_threads is the number of available logical processors on the system divided by 2, with a minimum default value of 4. The purpose of these configuration options to make InnoDB more scalable on high end systems. If ... InnoDB uses background threads to service various types of I/O ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-troubleshooting-datadict.html
Cannot Open Datafile With innodb_file_per_table enabled (the default), the following messages may appear at startup if a file-per-table tablespace file (.ibd file) is missing: [ERROR] InnoDB: Operating system error number 2 in a file operation.
https://dev.mysql.com/doc/refman/9.7/en/numeric-type-syntax.html
The FIXED synonym is available for compatibility with other database systems. The actual range might be slightly smaller depending on your hardware or operating system. The actual range might be slightly smaller depending on your hardware or ... For ...
https://dev.mysql.com/doc/refman/9.7/en/password-too-long.html
This occurs when the library provided by the system to read passwords limits password values to a small number of characters (typically eight). That is a problem with the system library, not with MySQL. To work around it, change your MySQL password ...
https://dev.mysql.com/doc/refman/9.7/en/preface.html
This is the Reference Manual for the MySQL Database System, for the 9.7.0 Innovation release. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed, or activated on delivered ...
https://dev.mysql.com/doc/refman/9.7/en/selinux-mode.html
In disabled mode, polices are not enforced, and contexts are not applied to system objects, which makes it difficult to enable SELinux later. $> getenforce Enforcing To change the SELinux mode, use the setenforce utility: $> setenforce 0 $> ...