Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or ...--relay-log-purge={0|1} Command-Line Format --relay-log-purge[={OFF|ON}] System Variable relay_log_purge Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON Disable or enable automatic purging of relay logs as soon as they are no longer ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
For a brief summary, execute this command: mysqld --help To see the full list, use this command: mysqld --verbose --help Some of the items in the list are actually system variables that can be set at server startup. You can also set the values of ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
Data Dictionary Tables Grant System Tables Object Information System Tables Log System Tables Server-Side Help System Tables Time Zone System Tables Replication System Tables Optimizer System Tables Miscellaneous System Tables The remainder of this ...It contains tables that store information required by the MySQL server as it ...Previously, these ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
https://dev.mysql.com/doc/refman/8.4/en/innodb-system-tablespace.html
Allocating a Raw Disk Partition on Linux and Unix Systems To use a raw device for a new server instance, first prepare the configuration file by setting innodb_data_file_path with the raw keyword. The system tablespace is the storage area for the ...For example: innodb_data_file_path=ibdata1:10M:autoextend When the autoextend attribute is specified, the data file automatically increases in size by 8MB increments as space is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). enforce_gtid_consistency Command-Line Format --enforce-gtid-consistency[=value] System Variable ...This setting ...
https://dev.mysql.com/doc/heatwave-aws/en/hw-aws-ha-enabling-stand-alone-db-systems.html
If they are not, see Editing a DB System on how to enable them. Note:Optionally, if there has been a high write load on the DB System since the last backup, take a manual backup of the DB System before enabling high availability to speed up the ...
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-reference-systems.html
A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are different types of spatial reference systems: A projected SRS is a projection of a globe onto a flat surface; that is, a flat map.
https://dev.mysql.com/doc/refman/8.4/en/mysql-server.html
MySQL distributions on Unix and Unix-like system include a script named mysql.server, which starts the MySQL server using mysqld_safe. In the following discussion, adjust the name mysql.server as appropriate for your system. Note For some Linux ...