Search Results
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. This enables MySQL to determine that address is functionally dependent on name; that is, address is uniquely ...The ...As a result, the address value for rows within each name group is ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
(For information about nonaggregated columns and GROUP BY, see Section 14.19.3, “MySQL Handling of GROUP BY”.) In this case, the server is free to choose any value from this nonaggregated column in summary rows, and this includes the extra rows ...ROLLUP thus enables you to answer questions at multiple levels of analysis with a single ... The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, and mysqldump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect to MySQL. By ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option: CREATE TABLE t (i INT) ENGINE = MYISAM; In MySQL 8.4, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-summary-tables.html
row *************************** ERROR_NUMBER: 1317 ERROR_NAME: ER_QUERY_INTERRUPTED SQL_STATE: 70100 SUM_ERROR_RAISED: 1 SUM_ERROR_HANDLED: 0 FIRST_SEEN: 2016-06-28 11:01:49 LAST_SEEN: 2016-06-28 11:01:49 Each error summary table has one or more ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-networking-category.html
Named Pipe Enabled On Windows only, indicates whether the server supports connections over named pipes. Shared Memory Enabled On Windows only, indicates whether the server the server permits shared-memory connections. Table 7.24 Networking ... Lists ...
https://dev.mysql.com/doc/refman/8.4/en/large-page-support.html
Large page support in the MySQL server is disabled by default. You can also do so by adding the following line to the [mysqld] section of the server my.cnf file: large-pages=ON With this option enabled, InnoDB uses large pages automatically for its ...In MySQL, large pages can be used by InnoDB, to allocate memory for its buffer pool and additional memory ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-event-tables.html
The Performance Schema autosizes the history tables, or the sizes can be configured explicitly at server startup using table-specific system variables, as indicated in the sections that describe the individual history tables. The tables have names ... For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-multiple-queries.html
By default, mysql_real_query() and mysql_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or ...MySQL also supports the execution of a string containing multiple statements separated by semicolon (;) ...Processing these results involves a different approach than for the single-statement case: After handling the result ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-replicationreplica-activity-category.html
Running This is ON if this server is a replication replica that is connected to a replication source, and both the I/O and SQL threads are running; otherwise, it is OFF. Replica Error: Unknown or Incorrect Time Zone In order to use time zone names ...Exec Source Log Pos The position in the current source binary file up to which the SQL thread has read and ...