PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
Data definition language (DDL) statements that define or modify database objects. CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. SELECT.) Statements that implicitly use or modify tables in the ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html
Create the database first; its name should not exceed 64 characters. For example: mysql> CREATE DATABASE IF NOT EXISTS database-name; Next, run the script using the alternative database name. $> mysql -u root -p -D database-name < ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-client-commands.html
DROP NODEGROUP nodegroup_id Drops the NDB Cluster node group with the given nodegroup_id. This command can be used to drop a node group from an NDB Cluster. DROP NODEGROUP takes as its sole argument the node group ID of the node group to be dropped.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-objects.html
It is also possible to drop data files from a tablespace (see example later in this section). This is also true for dropping these objects, subject to the following constraints: A log file group cannot be dropped as long as any tablespaces use it. A ... NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-operations.html
Tells the data nodes to drop the original table and then to rename the copy. Operations that add and drop indexes on variable-width columns of NDB tables occur online. ALGORITHM=INPLACE can be used to perform online ADD COLUMN, ADD INDEX (including ... MySQL NDB Cluster 8.0 supports online table schema changes using ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/windows-symbolic-links.html
On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a different location (for example, on a different disk) by setting up a symbolic link to it. Use of database symlinks on Windows is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo.html
ndbinfo is a database containing information specific to NDB Cluster. This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. This is true even when using the ...You can find more detailed information about each of these tables in the next several ...
https://dev.mysql.com/doc/refman/8.0/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump --databases db1 > dump.sql Copy the dump file from Server 1 to Server 2. On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
There may be situations where you have a single source server and want to replicate different databases to different replicas. A sample of this layout is shown in Figure 19.2, “Replicating Databases to Separate Replicas”. Figure 19.2 ...For ...