Search Results
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
This enables multiple-row inserts to be reproduced correctly on other servers in a replication setup. You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: ...
https://dev.mysql.com/doc/refman/8.4/en/external-locking.html
(This is not done by default because in many setups it is useful to have a mixture of the preceding options.) . External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. External ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
However, MySQL has an AUTO_INCREMENT system, which can also handle inserts in a multi-source replication setup. Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Does MySQL have a NOW() function with fractions of ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage engine. Which versions of the MySQL software support NDB Cluster? Do I have to compile from source? A.10.2. What is the difference ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
In theory, by using a single-source/multiple-replica setup, you can scale the system by adding more replicas until you either run out of network bandwidth, or your update load grows to the point that the source cannot handle it. In the following ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-security.html
Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? A.9.5. Does MySQL include support for Roles Based Access Control (RBAC)? ...
https://dev.mysql.com/doc/refman/8.4/en/federated-description.html
The basic structure of a FEDERATED table setup is shown in Figure 18.2, “FEDERATED Table Structure”. When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition ...
https://dev.mysql.com/doc/refman/8.4/en/general-security-issues.html
For information specifically about the access control system that MySQL uses for setting up user accounts and checking database access, see Section 2.9, “Postinstallation Setup and Testing”. This section describes general security issues to be ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
As with file-per-table tablespaces, the ability to place data files outside of the MySQL data directory allows you to manage performance of critical tables separately, setup RAID or DRBD for specific tables, or bind tables to particular disks, for ... A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
The following list describes thread State values that are associated with general query processing and not more specialized activities such as replication. Many of these are useful only for finding bugs in the server. After create This occurs when ...