Search Results
https://dev.mysql.com/doc/refman/8.4/en/lock-instance-for-backup.html
REPAIR TABLE TRUNCATE TABLE, OPTIMIZE TABLE, and account management statements are blocked. LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online backup while ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
SET @old_log_state = @@GLOBAL.general_log; SET GLOBAL general_log = 'OFF'; ALTER TABLE mysql.general_log ENGINE = MyISAM; SET GLOBAL general_log = @old_log_state; TRUNCATE TABLE is a valid operation on a log table. MySQL Server provides flexible ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
You should not use ANALYZE TABLE, REPAIR TABLE, OPTIMIZE TABLE, ALTER TABLE, DROP TABLE, DELETE without a WHERE clause, or TRUNCATE TABLE on any of the tables that are mapped into an open MERGE table. The following are known problems with MERGE ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
Use the table description file to create new (empty) data and index files: $> mysql db_name mysql> SET autocommit=1; mysql> TRUNCATE TABLE tbl_name; mysql> quit Copy the old data file back onto the newly created data file. The discussion in this ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-memory.html
The old index file is truncated at the start of the repair operation, so you usually ignore this space. myisamchk uses no more memory than its memory-related variables are set to. If you are going to use myisamchk on very large tables, you should ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-client-commands.html
TRUNCATE TABLE does not work for this purpose because this removes only the table data; the data nodes continue to store an NDBCLUSTER table's definition until a DROP TABLE statement is issued that causes the table metadata to be dropped. In ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-remarks.html
TRUNCATE TABLE does not work for this purpose because the data nodes continue to store the table definitions. This section provides general information about the behavior of and current limitations in adding NDB Cluster nodes online. The ability to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-move-data.html
--lossy-conversions, -l Command-Line Format --lossy-conversions Allow attribute data to be truncated when converted to a smaller type. Usage The program is invoked with the names of the source and target tables; either or both of these may be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-pitr.html
Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was made. Performing point-in-time recovery of NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-mysql-privileges.html
In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster secure. This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE ...