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/lock-tables.html
Locking MyISAM tables speeds up inserting, updating, or deleting on them because MySQL does not flush the key cache for the locked tables until UNLOCK TABLES is called. LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] ...
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
The metadata_locks row for the lock is deleted when the last lock instance on the name is released. While held by one session, other sessions cannot obtain a lock of the same name. Returns 1 if the lock was obtained successfully, 0 if the attempt ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
INSERT, DELETE, and UPDATE cannot be used on a log table. MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are enabled. Possible destinations for log ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-services.html
To remove multiple services, use SC DELETE mysqld_service_name for each one. On Windows, a MySQL server can run as a Windows service. The procedures for installing, controlling, and removing a single MySQL service are described in Section 2.3.4.8, ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-maintenance-schedule.html
If you are performing many updates to MyISAM tables with dynamic-sized rows (tables with VARCHAR, BLOB, or TEXT columns) or have tables with many deleted rows you may want to defragment/reclaim space from the tables from time to time. It is a good ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-optimization.html
To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery mode: $> myisamchk -r tbl_name You can optimize a table in the same way by using the OPTIMIZE TABLE SQL statement.
https://dev.mysql.com/doc/refman/5.7/en/myisamlog.html
If a recovery is done (-r), all writes and possibly updates and deletes are done and errors are only counted. To create such a file, start the server with a --log-isam=log_file option. Invoke myisamlog like this: myisamlog [options] [file_name ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
Once table ts_1 has been created as shown, you can perform INSERT, SELECT, UPDATE, and DELETE statements on it just as you would with any other MySQL table. NDB Cluster Disk Data storage is implemented using a number of Disk Data objects. These ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-importing-data.html
You may also wish to do this when performing bulk DELETE or UPDATE operations on NDB Cluster tables. It is common when setting up a new instance of NDB Cluster to need to import data from an existing NDB Cluster, instance of MySQL, or other source.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-event-buffer.html
These events consist of operation types (insert, update, delete) and row data (before and after images plus metadata). NDB uses one or more memory buffers for events received from the data nodes. There is one such buffer for each Ndb object ...