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/mysqlpump.html
mysqlpump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, and LOCK TABLES if the --single-transaction option is not used. --add-locks Command-Line Format --add-locks Surround each ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam-bulk-data-loading.html
UNLOCK TABLES; This benefits performance because the index buffer is flushed to disk only once, after all INSERT statements have completed. Explicit locking statements are not needed if you can insert all rows with a single INSERT. Locking also ...
https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html
Client programs that use the MySQL client library block SIGPIPE signals by default. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
Transaction-control and locking statements are exceptions: If an implicit commit occurs before execution, another does not occur after. BEGIN, LOCK TABLES, SET autocommit = 1 (if the value is not already 1), START TRANSACTION, UNLOCK TABLES. UNLOCK ... The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl.html
For in-place operations, the ability to adjust the balance between performance and concurrency during DDL operations using the LOCK clause. By default, MySQL performs the operation instantly or in place, as permitted, with as little locking as ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-ro-txn.html
A transaction ID is only needed for a transaction that might perform write operations or locking reads such as SELECT ... You can still make changes to session-specific temporary tables in a read-only transaction, or issue locking queries for them, ... InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 29.1 Performance Schema Tables Table Name Description Introduced accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.html
Possible values for lock_type are: 0: Read lock 1: Read lock with hold 2: Exclusive read lock There is no default value for this option. ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
LOCK TABLES Enables use of explicit LOCK TABLES statements to lock tables for which you have the SELECT privilege. This includes use of write locks, which prevents other sessions from reading the locked table. AUDIT_ABORT_EXEMPT (added in MySQL ...