Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-debugging-profiling.html
logger The name of a class that implements 'com.mysql.cj.log.Log' that will be used to log messages to. Default Value com.mysql.cj.log.StandardLogger Since Version 3.1.1 profilerEventHandler Name of a class that implements the interface ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log.html
You can add statistics for the time and size of each query to detect outliers. Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Audit, ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
CHECK TABLE Usage Notes for MyISAM Tables The following notes apply to MyISAM tables: CHECK TABLE updates key statistics for MyISAM tables. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for ...
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
Similarly, if no column histogram information is available, generate a histogram (see Section 10.9.6, “Optimizer Statistics”). In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
autocommit=1 is suitable for InnoDB tables when running a sequence of queries for generating reports or analyzing statistics. If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following ...
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
Run the command mysqladmin -i 5 status or mysqladmin -i 5 -r status in a separate window to produce statistics while running other queries. Each MySQL version is tested on many platforms before it is released. This does not mean that there are no ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
By default, GIPKs are shown in the output of SHOW CREATE TABLE, SHOW COLUMNS, and SHOW INDEX, and are visible in the Information Schema COLUMNS and STATISTICS tables. MySQL 8.4 supports generated invisible primary keys for any InnoDB table that is ...
https://dev.mysql.com/doc/refman/8.4/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. Dynamic format is a little more complex than static ...
https://dev.mysql.com/doc/refman/8.4/en/explain-for-connection.html
Because of changes to data (and supporting statistics) it may produce a different result from running EXPLAIN on the equivalent query text. To obtain the execution plan for an explainable statement executing in a named connection, use this ...