Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-features-flush.html
The FLUSH TABLES, ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements are written to the binary log and thus replicated to replicas. Some forms of the FLUSH statement are not logged because they could cause problems if replicated to a ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-binary-log.html
Typically, the benefits of setting a delay outweigh the drawbacks, but tuning should always be carried out to determine the optimal setting. Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/9.7/en/select-benchmarking.html
The built-in MySQL functions are typically highly optimized, but there may be some exceptions. To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client program. The return value is ...
https://dev.mysql.com/doc/refman/9.7/en/server-shutdown.html
For additional information about thread termination, see Section 15.7.8.4, “KILL Statement”, in particular for the instructions about killed REPAIR TABLE or OPTIMIZE TABLE operations on MyISAM tables. The server shutdown process takes place as ...
https://dev.mysql.com/doc/refman/9.7/en/set-operations.html
If ORDER BY appears without LIMIT within a query block, it is optimized away because it has no effect in any case. Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set ...
https://dev.mysql.com/doc/refman/9.7/en/show-index.html
SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...
https://dev.mysql.com/doc/refman/9.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-prepared-statements.html
The prepared statement API allows supported SQL statements (see SQL Syntax Permitted in Prepared Statements) to be re-executed without incurring the cost of parsing and optimization each time. The question mark or interrogation point (?) is used as ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-regressor.html
Optimization and Scoring Metrics, provides information about metrics compatible with the AutoML regression task. Regressor Constructor Regressor.train() Regressor.fit() Regressor.predict() Regressor.score() Regressor.explain() ...