Search Results
https://dev.mysql.com/doc/refman/8.4/en/ipv6-support.html
Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over IPv6. For example, this command connects over IPv6 to the MySQL server on the local host: $> mysql -h ::1 To use this ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-close.html
Multiple mysqld servers are using the table and one server performed a REPAIR TABLE or CHECK TABLE on the table while it was in use by another server. The counter works as follows: The first time a table is updated in MySQL, a counter in the header ... Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-configuration.html
A MySQL server that is part of an NDB Cluster differs in one chief respect from a normal (nonclustered) MySQL server, in that it employs the NDB storage engine. This MySQL server is a part of the cluster, so it also must know how to access a ...To ...This engine is also referred to sometimes as NDBCLUSTER, although NDB is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication.html
This process is accomplished by a special thread known as the NDB binary log injector thread, which runs on each MySQL server and produces a binary log (binlog). This thread ensures that all changes in the cluster producing the binary log—and not ...We assume some familiarity on the part of the reader with standard MySQL replication as discussed elsewhere in this ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator.html
MySQL Configurator is a standalone application designed to ease the complexity of configuring a MySQL server to run MySQL on Microsoft Windows. It is bundled with the MySQL server, in both the MSI and standalone Zip archive. Methods to Start MySQL ...From the Start Menu: the MSI creates a MySQL Configurator start menu ...
https://dev.mysql.com/doc/refman/8.4/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. For some MySQL installation methods, data directory initialization may be done for you ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. If you modify the grant tables indirectly using an account-management statement, the server notices ...The in-memory tables become effective for access control at that ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table-optimization.html
For example, add these lines to the server my.cnf file: [mysqld] myisam_sort_buffer_size=256M key_buffer_size=1G myisam_max_sort_file_size=100G These settings do not include read_buffer_size. For REPAIR TABLE, the same principle applies, but because ... REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has variables that control memory ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-invoked.html
For example, trying to replicate a loadable function with statement-based replication generates this warning because it currently cannot be determined by the MySQL server whether the function is deterministic. If you rename the events, then when ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
The MySQL server tracks the logging mode that was in effect when each temporary table was created. Use of STOP REPLICA or STOP REPLICA SQL_THREAD prior to shutting down the replica MySQL server helps prevent issues from occurring, and is always ...