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/alter-table-examples.html
For MyISAM tables, you can set the first sequence number by executing SET INSERT_ID=value before ALTER TABLE or by using the AUTO_INCREMENT=value table option. For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 1 row in set (0.01 sec) To change the storage type of an individual column, you can use ALTER TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-starting.html
This section outlines the procedure for starting NDB Cluster replication using a single replication channel. Start the MySQL replication source server by issuing this command, where id is this server's unique ID (see Section 21.7.2, “General ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-tables.html
The setup_timers table contains a row with a NAME value of wait that indicates the unit for wait event timing. The Performance Schema instruments waits, which are events that take time. These tables store wait events: events_waits_current: The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
The statement is always logged in statement format, even if the binary logging format is set to ROW, and it is written even if read_only or super_read_only mode is set on the server. When binlog_format=ROW, you can prevent the replica from stopping ...To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 5.7.32) TRUNCATE TABLE statement for that table to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-pitr.html
To perform point-in-time recovery of NDB Cluster, it is necessary to follow the steps shown here: Back up all NDB databases in the cluster, using the START BACKUP command in the ndb_mgm client (see Section 21.6.8, “Online Backup of NDB Cluster”). 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 ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-profiling-table.html
Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 13.7.5.30, “SHOW PROFILE Statement”). The table is empty unless the profiling session variable is set to 1. Use the Performance ...
https://dev.mysql.com/doc/refman/5.7/en/operator-precedence.html
Section 13.7.4.1, “SET Syntax for Variable Assignment”, and Section 9.4, “User-Defined Variables”, explain how MySQL determines which interpretation of = should apply. For operators that occur at the same precedence level within an ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
MySQL 5.7 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. mysql_upgrade returns an error if a sys schema exists but has no version view, on the assumption that absence of ...sys schema objects can be used for typical tuning and diagnosis use ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
.frm Files MySQL stores data dictionary information for tables in .frm files in database directories. InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ...However, the ENGINE clause is useful if the CREATE TABLE statement is to be replayed on a different MySQL Server instance where the default storage engine is not InnoDB or is ...