Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
There are many reasons why you might want to import tables: To run reports on a non-production MySQL server instance to avoid placing extra load on a production server. To move a data to a server with storage media that is better suited to your ...
https://dev.mysql.com/doc/refman/8.4/en/installing-development-tree.html
To obtain the MySQL Server source code from this repository hosting service, you can set up a local MySQL Git repository. On GitHub, MySQL Server and other MySQL projects are found on the MySQL page. The MySQL Server project is a single repository ... This section describes how to install MySQL from the latest development source code, which is hosted on ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
When the MySQL server halts or restarts, the data in MEMORY tables is lost. Despite the in-memory processing for MEMORY tables, they are not necessarily faster than InnoDB tables on a busy server, for general-purpose queries, or under a read/write ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-multi-source.html
In this section, we discuss failover in a multi-source NDB Cluster replication setup with three NDB Clusters having server IDs 1, 2, and 3. Not all MySQL servers taking part in multi-source replication must act as both source and replica, and a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
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 ...The ndb_binlog_index and ndb_apply_status tables are created in the mysql ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) Disabling mysql Auto-Reconnect mysql Client Parser Versus Server Parser Input-Line Editing mysql ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/crd-ndbmysqldspec.html
NdbMysqldSpec is the specification for any MySQL Servers to be run as NDB Cluster SQL nodes. nodeCount (integer): The number of SQL nodes (that is, MySQL servers or instances of mysqld) running in the NDB Cluster. maxNodeCount (integer): (optional) ...See the description of the mysqld --ndb-cluster-connection-pool option for further ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
Client programs can be written that access NDB Cluster data directly from the NDBCLUSTER storage engine, bypassing any MySQL Servers that may be connected to the cluster, using the NDB API, a high-level C++ API. The “Cluster” portion of NDB ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set explicitly. At server startup, you can specify this variable with no value or a value of ON or 1 to enable it, or with a value ...Performance Schema system variables have the following meanings: performance_schema Command-Line Format --performance-schema[={OFF|ON}] System Variable performance_schema Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value ON The value of this variable is ON or OFF to indicate whether the Performance Schema is ...
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
| @@] system_var_name } SET syntax for variable assignment enables you to assign values to different types of variables that affect the operation of the server or clients: User-defined variables. System variables also can be set at server startup, ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...