Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-install-configuration.html
In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration files. (Create the file if it does not exist.) For example: $> vi /etc/my.cnf Note We show vi being used here to create the file, but ...For our four-node, four-host NDB Cluster (see Cluster nodes and host computers), it is necessary to write four configuration files, one per node ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/9.7/en/replication-snapshot-method.html
To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. 19.1.2.5.1 Creating a Data Snapshot Using mysqldump To create a snapshot of ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/9.7/en/symbolic-links-to-databases.html
On Unix, symlink a database using this procedure: Create the database using CREATE DATABASE: mysql> CREATE DATABASE mydb1; Using CREATE DATABASE creates the database in the MySQL data directory and permits the server to update the data dictionary ...Stop the server to ensure that no activity occurs in the new database while it is being ...
https://dev.mysql.com/doc/refman/9.7/en/with.html
Consider these statements that create a small data set that shows, for each employee in a company, the employee name and ID number, and the ID of the employee's manager. CTEs are similar to tables created with CREATE [TEMPORARY] TABLE but need not ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-ml-retrieve-schema-metadata.html
This output consists of a concise set of abridged CREATE TABLE statements for the tables that are most relevant to a natural-language statement, ranked in order of relevance. To view a copy of this license, visit ... Retrieves the most relevant ...
https://dev.mysql.com/doc/workbench/en/wb-intro.html
MySQL Workbench functionality covers five main topics: SQL Development: Enables you to create and manage connections to database servers. Data Modeling (Design): Enables you to create models of your database schema graphically, reverse and forward ... This chapter provides general information about MySQL Workbench and how it has ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-connection-linux.html
Alternatively, choose ODBC Data Source (FreeTDS) if you defined a DSN when creating the SQL Server driver. Driver: The name of the driver that you created with the ODBC Administrator, as described in the documentation titled Section 10.5.2.2, ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-options-tab.html
See CREATE TABLE Statement for more information on how to use these options. To create a MERGE table, select MERGE as your storage engine and then specify the MyISAM tables you wish to merge in the Union Tables dialog. You may specify the action the ... The Options subtab enables you to set several types of ...
https://dev.mysql.com/doc/connectors/en/connector-net-interceptors.html
An interceptor is a software design pattern that provides a transparent way to extend or modify some aspect of a program, similar to a user exit. You can code an interceptor class and connect it to an existing program without recompiling, and ...