Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
MySQL Configurator supports GUI (default) and CLI (by passing in --console) modes using the mysql_configurator.exe executable. Note MySQL Configurator CLI functionality was added in MySQL Configurator 9.2.0. Executing MySQL Configurator requires a ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
Some queries using BETWEEN in the WHERE clause can also take advantage of partition pruning. The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be ...
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the logs. Statement ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF EXISTS] PROXY ON user_or_role FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
You can use the following queries to check for schema and table names containing uppercase characters: mysql> select TABLE_NAME, if(sha(TABLE_NAME) !=sha(lower(TABLE_NAME)),'Yes','No') as UpperCase from information_schema.tables; If ... Before ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
The following statement changes the query limit for francis to 100: mysql> ALTER USER 'francis'@'localhost' WITH MAX_QUERIES_PER_HOUR 100; The statement modifies only the limit value specified and leaves the account otherwise unchanged. Similarly, ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...