PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html
Each MySQL Instance on a machine should have its own data directory. Warning Normally, you should never have two servers that update data in the same databases. If (despite this warning) you run multiple servers using the same data directory and ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-servers.html
In addition to using different data directories, several other options must have different values for each server instance: --port=port_num --port controls the port number for TCP/IP connections. If you have multiple MySQL installations in different ... In some cases, you might want to run multiple instances of MySQL on a single ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-maintenance-schedule.html
For example, whenever the machine has done a restart in the middle of an update, you usually need to check each table that could have been affected before it is used further. To start with, execute myisamchk -s each night on all tables that have ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-repair.html
Note that when you do mysqladmin shutdown on a remote server, the mysqld server is still available for a while after mysqladmin returns, until all statement-processing has stopped and all index changes have been flushed to disk. Stage 1: Checking ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
mysql> We simply use the MySQL server's root account and assume that you have followed the standard security precautions for installing a MySQL server, including setting a strong root password. Note The information in this section applies to NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-installation.html
The result is that each data node connects to the management server, but cannot tell when any other data nodes have connected, and so the data nodes appear to hang while starting. That is, all four machines in the cluster should have 100 Mbps cards ... This section describes the basics for planning, installing, configuring, and running an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-exclusive-to-cluster.html
All machines used in the cluster must have the same architecture. For example, you cannot have a management node running on a PowerPC which directs a data node that is running on an x86 machine. The following are limitations specific to the NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
Unique key reads have their locks upgraded automatically by NDB to ensure a self-consistent read; BLOB reads also employ extra locking for consistency. Reading via an ordered index makes less efficient use of resources in the cluster, and may have ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-membership.html
The membership table describes the view that each data node has of all the others in the cluster, including node group membership, president node, arbitrator, arbitrator successor, arbitrator connection states, and other information. We determine ...