Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
Default frequency 00:10:00 Default auto-close enabled no Object Changed: Index Has Been Created For development environments, changes to databases and objects may be a normal occurrence, but not for production environments. Default frequency ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-sql-result-sets.html
def print_result(res): if res.has_data(): # SELECT columns = res.get_columns() record = res.fetch_one() while record: index = 0 for column in columns: print("%s: %s \n" % (column.get_column_name(), record[index])) index = index + 1 # Get the next ...
https://dev.mysql.com/doc/refman/8.4/en/estimating-performance.html
For small tables, you can usually find a row in one disk seek (because the index is probably cached). For bigger tables, you can estimate that, using B-tree indexes, you need this many seeks to find a row: log(row_count) / log(index_block_length / 3 ... In most cases, you can estimate query performance by counting disk ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-restrictions.html
Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. Although the use of multiple character sets within a single table is supported, all columns in a FULLTEXT ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--keys-used=val, -k val Command-Line Format --keys-used=val Type Numeric For myisamchk, the option value is a bit value that indicates which indexes to update. Each binary bit of the option value corresponds to a table index, where the first index ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html
Synchronizing models with objects that differ in case may lead to MySQL Workbench producing a DROP statement for that object, before recreating it as lowercase. Also note that clicking on a row will reveal the associated SQL statement, as shown in ...These three types can be the target (destination), source, or ...
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
The connection errors are, by default, propagated to the client, which has to handle them by, for example, recreating the working objects (Statement, ResultSet, etc.) and restarting the processes. This means the client can rely on the same ...A ...
https://dev.mysql.com/doc/connectors/en/connector-j-logging-slf4j.html
Here is output of the program when the SELECT statement failed: [2021-09-05 12:06:19,624] WARN 0[main] - WARN MySQL - Warning: Select failed! . Besides its default logger com.mysql.cj.log.StandardLogger, which logs to stderr, Connector/J supports ...
https://dev.mysql.com/doc/connectors/en/connector-j-query-attributes.html
Attributes are set for a query by using the setAttribute() method of the JdbcStatement interface. Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-load-balancing-failover.html
However, Connector/J can be configured to re-balance after a certain number of statements are executed, when autocommit is enabled. This functionality is dependent upon the following properties: loadBalanceAutoCommitStatementThreshold – defines ...