PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-first-start.html
This option requires that --initial or --reload also be specified; see Section 21.5.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”, for details. If all has gone well, and the cluster has been set up correctly, the cluster should now ... Starting the cluster is not very difficult after it has been ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-group-member-stats-table.html
This table shows statistical information for MySQL Group Replication members. This has a different value for each member in the group. Once the transactions have been checked for conflicts, if they pass the check, they are queued to be applied as ...The replication_group_member_stats table has these columns: CHANNEL_NAME Name of the Group Replication ...