PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/lock-instance-for-backup.html
The BACKUP_ADMIN privilege is automatically granted to users with the RELOAD privilege when performing an in-place upgrade to MySQL 8.0 from an earlier version. WITH READ LOCK; LOCK INSTANCE FOR BACKUP; UNLOCK INSTANCE; UNLOCK TABLES; The ... LOCK ...
https://dev.mysql.com/doc/refman/8.0/en/locking-functions.html
Returns 1 if the lock was obtained successfully, 0 if the attempt timed out (for example, because another client has previously locked the name), or NULL if an error occurred (such as running out of memory or the thread was killed with mysqladmin ...
https://dev.mysql.com/doc/refman/8.0/en/locking-issues.html
MySQL manages contention for table contents using locking: Internal locking is performed within the MySQL server itself to manage contention for table contents by multiple threads. External locking occurs when the server and other programs lock ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-start.html
The following options to mysqld can be used to change the behavior of MyISAM tables. Note If you do this, you should not access MyISAM tables from another program (such as from another MySQL server or with myisamchk) when the tables are in use.
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--parallel-recover, -p Command-Line Format --parallel-recover Note This option is deprecated in MySQL 8.0.28 and removed in MySQL 8.0.30. --correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table.
https://dev.mysql.com/doc/refman/8.0/en/no-matching-rows.html
Remove one table at a time from the query until it returns some rows. If you still cannot figure out what is wrong, create a minimal test that can be run with mysql test < query.sql that shows your problems. You can create a test file by dumping the ... If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously ...
https://dev.mysql.com/doc/refman/8.0/en/optimization-indexes.html
Although it can be tempting to create an indexes for every possible column used in a query, unnecessary indexes waste space and waste time for MySQL to determine which indexes to use. The best way to improve the performance of SELECT operations is ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-benchmarking.html
To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of operations (a “workload”) works over a period of time. Benchmarks are typically long-running ...
https://dev.mysql.com/doc/refman/8.0/en/platform-support.html
MySQL platform support evolves over time; please refer to https://www.mysql.com/support/supportedplatforms/database.html for the latest updates.
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...