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/sys-version.html
For example, use the VERSION() function to retrieve the MySQL server version. This view provides the current sys schema and MySQL server versions. Note As of MySQL 5.7.28, this view is deprecated and subject to removal in a future MySQL version.
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-information-schema-tables.html
The following sections describe the INFORMATION_SCHEMA tables associated with the thread pool plugin (see Section 5.5.3, “MySQL Enterprise Thread Pool”). They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information ...Thus, the MySQL server holds the mutex of the thread group while producing the ...
https://dev.mysql.com/doc/refman/5.7/en/update-optimization.html
Performing multiple updates together is much quicker than doing one at a time if you lock the table. For a MyISAM table that uses dynamic row format, updating a row to a longer total length may split the row. An update statement is optimized like a ...
https://dev.mysql.com/doc/refman/5.7/en/verifying-package-integrity.html
After downloading the MySQL package that suits your needs and before attempting to install it, make sure that it is intact and has not been tampered with. There are three means of integrity checking: MD5 checksums Cryptographic signatures using ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-ftdump.html
--dump, -d Command-Line Format --dump Dump the index, including data offsets and word weights. Before using myisam_ftdump, be sure to issue a FLUSH TABLES statement first if the server is running. If you do not invoke myisam_ftdump in the directory ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-backup.html
MySQL Enterprise Backup performs hot backup operations for MySQL databases. Hot backups are performed while the database is running and applications are reading and writing to it. For these reasons, hot backups are desirable when your database ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-storage-engines.html
For tables using MyISAM or other non-InnoDB storage engines, it does a “warm” backup, where the database continues to run, but those tables cannot be modified while being backed up. Where can I obtain complete documentation for MySQL storage ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-being-deleted-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index; for example test/articles. Because the contents of INNODB_FT_BEING_DELETED ... The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-deleted-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index; for example test/articles. The INNODB_FT_DELETED table stores rows that are ...The ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-table-maintenance.html
The following sections describe how to perform these operations and how to set up a table maintenance schedule. This section discusses how to use myisamchk to check or repair MyISAM tables (tables that have .MYD and .MYI files for storing data and ...myisamchk operations that affect indexes can cause MyISAM FULLTEXT indexes to be rebuilt with full-text parameters that are incompatible with the values used by the MySQL ...