Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/synchronous-vs-asynchronous-execution.html
For example, Connector/J can use execute() to return a RowResult or DocResult and executeAsync() to return a CompletableFuture<T> where the type parameter is one of the result types. Traditionally, many MySQL drivers used a synchronous approach ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-audit.html
The log contents include when clients connect and disconnect, and what actions they perform while connected, such as which databases and tables they access. $> cd /usr/local/mysql $> bin/mysql -u root -p < ... MySQL Enterprise Audit enables ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-download.html
The extracted files include those shown in the following table: Table 2.1 MySQL Package and Signature Files for Source files File Type File Name README file README.txt MD5 signature file mysql-commercial-8.0.xx-linux-glibc2.12-x86_64.tar.xz.md5 GPG ... To download the latest MySQL Enterprise Edition for Linux x86-64 generic binary package, perform the following ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-password-validation.html
INSTALL COMPONENT loads the component, and also registers it in the mysql.component system table to cause it to be loaded during subsequent server startups. The validate_password component serves to test user-specified passwords and improve ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-permissions.html
The following table shows directory and file permissions for the generic binary distribution installation of MySQL Enterprise Edition for Linux x86-64 on Oracle Linux that is described in this guide. As a general rule, distributed files and ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/result-set-classes.html
The different types of results are outlined in the following table. The type of result returned depends on the operation that was executed. SqlResult session.sql().execute() Number of rows affected by the operation, auto generated document IDs, last ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/result-set-classes.html
The different types of results are outlined in the following table. The type of result returned depends on the operation that was executed. SqlResult session.sql().execute() Number of rows affected by the operation, auto generated document IDs, last ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
| | Expected time for applying all Index creation suggestions: 25 s | | | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ To ... To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output that includes the following information: New indexes to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-aggregate-functions.html
Table 5.1 Aggregate (GROUP BY) Functions Name VARLEN Support Description AVG() Return the average value of the argument COUNT() Yes Return a count of the number of rows returned COUNT(DISTINCT) Return the count of a number of different values ...The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-dictionary-encoding.html
Dictionary encoding (SORTED) has the following characteristics: Best suited to string columns with a low number of distinct values relative to the cardinality of the table. Load operations for tables with dictionary-encoded string columns that have ...Dictionary encoding reduces the space required for column values on the MySQL HeatWave nodes but requires space on the DB System node for ...