Search Results
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
On Unix, make sure that they are readable by the user that mysqld runs as (and to you, because you need to access the files you are checking). If you are going to repair a table from the command line, you must first stop the mysqld server. Note that ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/8.4/en/option-file-options.html
Most MySQL programs that support option files handle the following options. Exceptions: Even with --defaults-file, mysqld reads mysqld-auto.cnf and client programs read .mylogin.cnf. For example, the mysql client normally reads the [client] and ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
The SELECT statement in the preceding example could also have been written using explicit row constructors, like this: SELECT ROW(5,10) < ROW(5,12), ROW(5,11) < ROW(5,12), ROW(5,12) < ROW(5,12); For more information about the use of row constructors ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
The connection metadata repository is written to the slave_master_info table in the mysql system schema, and the applier metadata repository is written to the slave_relay_log_info table in the mysql system schema. A warning message is issued if ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-failover.html
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 failover. There are several ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
On the source, released the read lock: mysql> UNLOCK TABLES; On the replica, edited the MySQL configuration. The database updates are automatically propagated to the replicas: $> mysql -h source < fulldb.dump 19.1.2.6.2 Setting Up Replication with ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation-prerequisites.html
To install MySQL from source, the following system requirements must be satisfied, regardless of installation method: CMake, which is used as the build framework on all platforms. On Unix-like systems, including Linux, you can check your system's ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-defining.html
By default, mysql itself recognizes the semicolon as a statement delimiter, so you must redefine the delimiter temporarily to cause mysql to pass the entire stored program definition to the server. This enables the ; delimiter used in the procedure ... Each stored program contains a body that consists of an SQL ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
This section describes how MySQL handles binary logging for stored programs. The conditions on the use of stored functions in MySQL can be summarized as follows. MySQL does not check that a function declared DETERMINISTIC is free of statements that ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
mysql> CALL sys.statement_performance_analyzer('delta', 'mydb.tmp_digests_ini', 'with_runtimes_in_95th_percentile'); +-----------------------------------------+ | Next Output | +-----------------------------------------+ | Queries with Runtime in ...