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/partitioning-maintenance.html
If you have deleted a large number of rows from a partition or if you have made many changes to a partitioned table with variable-length rows (that is, having VARCHAR, BLOB, or TEXT columns), you can use ALTER TABLE ... You can use ALTER IGNORE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
Tables that use the MEMORY storage engine are deleted automatically the first time they are accessed after the server is started, because rows might have been lost during the shutdown. This also includes no-op transactions when row-based replication ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--max-record-length=len Command-Line Format --max-record-length=len Type Numeric Skip rows larger than the given length if myisamchk cannot allocate memory to hold them. --extend-check, -e Command-Line Format --extend-check Do a repair that tries to ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
The SQL language itself is intended to work independently of any data structures or media underlying the schemas, tables, rows, or columns with which it works. Partitioning takes this notion a step further, by enabling you to distribute portions of ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
Source files that use the locking service should include this header file: #include <mysql/service_locking.h> To acquire one or more locks, call this function: int mysql_acquire_locking_service_locks(MYSQL_THD opaque_thd, const char* lock_namespace, ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-check.html
It first checks all index entries for errors and then reads through all rows. It calculates a checksum for all key values in the rows and verifies that the checksum matches the checksum for the keys in the index tree. It does a check-read of every ... To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-diskpagebuffer.html
row *************************** node_id: 1 thr_no: 1 block_name: PGMAN thread_name: rep pages_written: 0 pages_written_lcp: 0 pages_read: 1 log_waits: 0 page_requests_direct_return: 4 page_requests_wait_queue: 0 page_requests_wait_io: 1 1 row in set ... The diskpagebuffer table provides statistics about disk page buffer usage by NDB Cluster Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Finally, nontransactional tables for which errors occur during large DML actions (such as bulk inserts) may experience replication issues in that a source may be partially updated from DML activity, but no updates are done to the replica because of ...Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
Tested with Purify (a commercial memory leakage detector) as well as with Valgrind, a GPL tool (https://valgrind.org/). Support for DELETE, INSERT, REPLACE, and UPDATE to return the number of rows that were changed (affected), or to return the ...
https://dev.mysql.com/doc/refman/8.0/en/locking-functions.html
In the case that multiple locks are acquired for the same name, only the first lock for the name registers a row in the metadata_locks table. The metadata_locks row for the lock is deleted when the last lock instance on the name is released. Caution ...While held by one session, other sessions cannot obtain a lock of the same ...