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/mysql-cluster-ndbinfo-operations-per-fragment.html
The table_id column value is unique at any given time, but can be reused if the corresponding object has been deleted. Since NDB does not use single-key access for ordered indexes, the counts for tot_key_reads, tot_key_inserts, tot_key_updates, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
The NDB injector is responsible for capturing all the data events within the cluster, and ensures that all events which change, insert, or delete data are recorded in the ndb_binlog_index table. conflict_fn column The conflict resolution function to ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-setup.html
Open MySQL Installer again from the Start menu and delete the installed product from the host using the Delete operation from the MySQL Installer dashboard. Choosing a Setup Type Path Conflicts Check Requirements MySQL Installer Configuration Files ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
If it is important to be able to do this, consider using the table in ways that avoid deleting rows. Another possibility is to run OPTIMIZE TABLE to defragment the table after you have deleted a lot of rows from it. You can force new rows to be ...
https://dev.mysql.com/doc/refman/5.7/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 ... This statement can be used to ... A number of table and partition maintenance tasks can be carried out using SQL statements intended for such purposes on partitioned tables in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
It is very important to remember that, when you drop a partition, you also delete all the data that was stored in that partition. DROP PARTITION is not reported by the server as it would be by the equivalent DELETE query. However, there is one ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-positions.html
As an example, suppose that around 13:00:00 on May 27, 2020, an SQL statement was executed that deleted a table. You can perform a point-in-time recovery to restore the server up to its state right before the table deletion. In our example, given ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
Because that row has a Host value 'localhost' that is more specific than '%', it is used in preference to the new row when connecting from localhost! The correct procedure is to insert a second row with Host='localhost' and User='some_user', or to ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-relaylog.html
The replication SQL thread automatically deletes each relay log file after it has executed all events in the file and no longer needs it. There is no explicit mechanism for deleting relay logs because the replication SQL thread takes care of doing ... The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, event, view, user, role, or grant. Tables that use the MEMORY storage engine are deleted ...