PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl.html
Less disk space usage and I/O overhead than the table-copy method. The online DDL feature provides support for in-place table alterations and concurrent DML. Benefits of this feature include: Improved responsiveness and availability in busy ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
Page Compression Limitations and Usage Notes Page compression is disabled if the file system block size (or compression unit size on Windows) * 2 > innodb_page_size. InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-use_sys_malloc.html
For more information about the performance implications of InnoDB memory usage, see Section 8.10, “Buffering and Caching”. When InnoDB was developed, the memory allocators supplied with operating systems and run-time libraries were often ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_aws keyring plugin communicates with the Amazon Web Services Key Management Service (AWS KMS) as a back end for key generation and ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-launchd.html
Figure 2.19 MySQL Preference Pane: Location Figure 2.20 MySQL Preference Pane: Usage Or, manually load the launchd file. macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-prefpane.html
Figure 2.24 MySQL Preference Pane: Location Figure 2.25 MySQL Preference Pane: Usage The MySQL Preference Pane shows the current status of the MySQL server, showing stopped (in red) if the server is not running and running (in green) if the server ... The MySQL Installation Package includes a MySQL preference pane that enables you to start, stop, and control automated startup during boot of your MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
In particular, the table locking involved with performing updates can slow down concurrent usage of MEMORY tables from multiple sessions. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 13.7.2.2, “CHECK TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk.html
For more information about memory allocation with myisamchk, see Section 4.6.3.6, “myisamchk Memory Usage”. The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM ...