Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-customizing.html
MySQL Shell offers these customization options for you to change its behavior and code execution environment to suit your preferences: Create startup scripts that are executed when MySQL Shell is started in JavaScript or Python mode. Set ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-reporting-builtin.html
MySQL Shell includes built-in reports to display the following information: The results of any specified SQL query (query. A listing of the current threads in the connected MySQL server (threads. As with user-defined reports, the built-in reports ...The built-in reports support the standard options for the \show and \watch commands in addition to their report-specific options, unless noted otherwise in their ...
https://dev.mysql.com/doc/internals/en/example-several-mysql-packets.html
64 d Note sending a MySQL Packet of the size 224−5 to 224−1 via compression leads to at least one extra compressed packet. If the uncompressed MySQL Packet is like: fe ff ff 03 ... -- length = 2^24-2, sequence id = 3 compressing it would result ... Executing SELECT repeat("a", 50) results in uncompressed ProtocolText::Resultset like: 01 00 00 01 01 25 00 00 02 03 64 65 66 00 00 00 ...
https://dev.mysql.com/doc/internals/en/running-mysql-test-run-out-of-source.html
When building out of source (see Section 4.4.1, “Create the Build Directory”), use mysql-test-run.pl in the mysql-test directory under the build directory. It is a wrapper script that calls mysql-test-run.pl in the source directory and tells it ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-restrictions.html
MySQL HeatWave on AWS Service Restrictions 3.1.2.8 MySQL HeatWave on AWS Service Restrictions The following items are currently not permitted in MySQL HeatWave on AWS: Custom TLS certificates. To change a shape, you must restore a backup of the DB ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE ...
https://dev.mysql.com/doc/refman/8.4/en/charset-mysql.html
MySQL Server supports multiple character sets, including several Unicode character sets. mysql> SHOW CHARACTER SET; +----------+---------------------------------+---------------------+--------+ | Charset | Description | Default collation | Maxlen | ...To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET ...
https://dev.mysql.com/doc/refman/8.4/en/gis-mysql-specific-functions.html
MySQL provides a set of useful nonstandard functions for creating geometry values. The functions described in this section are MySQL extensions to the OpenGIS specification. Also, functions such as ST_GeomFromText() that accept WKT geometry ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-enterprise-data-masking.html
MySQL Enterprise Edition 5.7 and higher includes MySQL Enterprise Data Masking and De-Identification, implemented as a plugin library containing a plugin and several loadable functions. MySQL Enterprise Data Masking and De-Identification functions ...Data masking hides sensitive information by replacing real values with ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-mysql-sock.html
The default location for the Unix socket file that the server uses for communication with local clients is /tmp/mysql.sock. (For some distribution formats, the directory might be different, such as /var/lib/mysql for RPMs.) On some versions of ...