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/table-locking.html
But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily for tables that are queried often and rarely inserted into or updated. A SELECT statement that takes a long ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/refman/8.0/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...
https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html
On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process. Some command interpreters associate certain key sequences with signals, such as Control+C to ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
MySQL enables extra optimizations for queries on InnoDB tables when the transaction is known to be read-only. Rolling back can be a slow operation that may occur implicitly without the user having explicitly asked for it (for example, when an error ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/8.0/en/cursor-restrictions.html
One limitation of the implementation is that for a large result set, retrieving its rows through a cursor might be slow. Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A server-side cursor enables a ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
In other words, the system can do 1,200 reads per second with no writes, the average write is twice as slow as the average read, and the relationship is linear. In the following section, we provide answers to questions that are most frequently ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
For MyISAM tables, boolean-mode searches can be done on nonindexed columns, although they are likely to be slow. Full-text searches are supported for InnoDB and MyISAM tables only. The exception is that for Unicode, the utf8mb3 or utf8mb4 character ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-purge-configuration.html
If DML action is concentrated on a single table, purge operations for the table are performed by a single purge thread, which can result in slowed purge operations, increased purge lag, and increased tablespace file size if the DML operations ...
https://dev.mysql.com/doc/refman/8.0/en/replica-connection-thread-states.html
When global scope is used, the slow query log contains the old versions of the names. These thread states occur on a replica server but are associated with connection threads, not with the I/O or SQL threads. In MySQL 8.0.26, incompatible changes ...
https://dev.mysql.com/doc/refman/8.0/en/replica-io-thread-states.html
When global scope is used, the slow query log contains the old versions of the names. The following list shows the most common states you see in the State column for a replication I/O (receiver) thread on a replica server. This state also appears ...