Search Results
https://dev.mysql.com/doc/refman/8.4/en/perl-installation.html
For example, to unpack and build a DBI distribution, use a procedure such as this: Unpack the distribution into the current directory: $> gunzip < DBI-VERSION.tar.gz | tar xvf - This command creates a directory named DBI-VERSION. Change location ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
mysqldump A client that dumps a MySQL database into a file as SQL, text, or XML. mysqlimport A client that imports text files into their respective tables using LOAD DATA. Later sections provide a more detailed description of each one, with the ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table-optimization.html
For key_buffer_size, you must take into account that the buffer is shared with those users. REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-skip.html
One event normally corresponds to one SQL statement in the binary log, but note that statements that use AUTO_INCREMENT or LAST_INSERT_ID() count as two events in the binary log. Make sure you do not skip too far forward and go into the next event ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-replica.html
When the feature is active and correctly configured, if the primary that is replicating goes offline or into an error state, the new primary starts replication on the same channel when it is elected. When the mysql_start_failover_channels_if_primary ... Asynchronous connection failover for replicas is activated automatically for a replication channel on a Group Replication primary when you set SOURCE_CONNECTION_AUTO_FAILOVER=1 in the CHANGE REPLICATION SOURCE TO statement for the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-failover.html
The easiest way to reproduce all identifiers and transactions on a new server is to make the new server into the replica of a source that has the entire execution history, and enable global transaction identifiers on both servers. These can be read ... There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new replica which can then be used for scaleout, being promoted to source as necessary for ...
https://dev.mysql.com/doc/refman/8.4/en/resignal.html
Within a condition handler that catches a condition, one use for RESIGNAL alone is to perform some other actions, and then pass on without change the original condition information (the information that existed before entry into the handler).
https://dev.mysql.com/doc/refman/8.4/en/scheduler-component.html
The component service calls each application-provided callback (function pointer) into the same scheduler thread, one at a time and in ascending order, based on the time each requires to run. Developers who wish to incorporate scheduler-queueing ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
Installing SHA-256 Pluggable Authentication The sha256_password (deprecated) plugin exists in server and client forms: The server-side plugin is built into the server, need not be loaded explicitly, and cannot be disabled by unloading it. The ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation-prerequisites.html
You can resolve these problems by installing into a directory that does not contain a space (for example C:\GnuWin32). If you run into problems and need to file a bug report, please use the instructions in Section 1.6, “How to Report Bugs or ...