Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-partitioning.html
Important You should not use --replicate-do-db for this purpose when using statement-based replication, since statement-based replication causes this option's effects to vary according to the database that is currently selected. There may be ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
The important thing is to have a unified interface for connecting for reads, connecting for writes, doing a read, and doing a write. You can use replication as a scale-out solution; that is, where you want to split up the load of database queries ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
Note This statement takes the place of the old RESET MASTER statement, which is no longer supported. RESET BINARY LOGS AND GTIDS [TO binary_log_file_index_number] Warning Use this statement with caution to ensure you do not lose any wanted binary ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
(This capability can be disabled with the --skip-symbolic-links option.) This is especially important if you run mysqld as root, because anyone that has write access to the server's data directory then could delete any file in the system! See ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Indexes are especially important for queries that reference different tables, using features such as joins and foreign keys. Queries, in the form of SELECT statements, perform all the lookup operations in the database. Tuning these statements is a ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program Options”. The most common methods are to provide options in an option file or on the command line.
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
Important Under some circumstances, SET PASSWORD may be recorded in server logs or on the client side in a history file such as ~/.mysql_history, which means that cleartext passwords may be read by anyone having read access to that information. SET ...
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated and subject to removal in a future MySQL release. It is recommended to use the Performance Schema implementation of SHOW PROCESSLIST instead.
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
This permits use in monitoring and other applications where getting an immediate response from SHOW REPLICA STATUS is more important than ensuring that it returned the latest data. SHOW REPLICA STATUS [FOR CHANNEL channel] This statement provides ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
The functions in this section enable manipulation of geohash values, which provides applications the capabilities of importing and exporting geohash data, and of indexing and searching geohash values. Geohash is a system for encoding latitude and ...