PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
You can get deadlocks even in the case of transactions that just insert or delete a single row. That is because these operations are not really “atomic”; they automatically set locks on the (possibly several) index records of the row inserted or ... This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-dml.html
Benchmarks suggest that the daemon_memcached plugin speeds up DML operations (inserts, updates, and deletes) more than it speeds up queries. INSERT becomes add, UPDATE becomes set, incr or decr, and DELETE becomes delete. Therefore, consider ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
The change buffer is not used, because there are no random-access inserts into the secondary indexes. The next row inserted into the table uses the specified value for its auto-increment column. Online support details, syntax examples, and usage ...
https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html
Table 12.22 JSON Functions Name Description Introduced Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() shows the amount of storage space used by a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
This includes all inserts, updates, writes and deletes, as well as writes performed as part of unique index operations. For inserts and updates, this is proportional to the number of columns written, and the size of their data. The Operations ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Each variable-sized page is reorganized as needed to fit the changing size of variable-sized row parts as they are inserted, updated, and deleted; if a given row part grows too large for the page it is in, it can be moved to a different page.
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
Initially, mysql executes statements in the input because specifying a database db_name on the command line is equivalent to inserting USE db_name at the beginning of the input. The INSERT and CREATE TABLE statements are executed because the default ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 5.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/5.7/en/optimizing-innodb-transaction-management.html
Avoid performing rollbacks after inserting, updating, or deleting huge numbers of rows. Set innodb_change_buffering=all so that update and delete operations are buffered in addition to inserts. Make sure to use this parameter setting on servers that ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...