Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-download.html
A non-root account can be used as long as the account has privileges to create new schemas. As part of this quick-start guide, an example schema is provided which is referred to as the world_x schema. Many of the examples demonstrate Document Store ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-collections.html
When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. Collections contain JSON documents that you can add, find, update, and remove. The examples in this section use the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-modify.html
The first example uses the modify() and set() methods to create a new Airports field in all documents. You can use the modify() method to update one or more documents in a collection. The X DevAPI provides additional methods for use with the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-download.html
A non-root account can be used as long as the account has privileges to create new schemas. As part of this quick-start guide, an example schema is provided which is referred to as the world_x schema. Many of the examples demonstrate Document Store ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
The following examples illustrate how mysqlbinlog displays row events that specify data modifications. These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type codes. The --base64-output=DECODE-ROWS and ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld.html
Invoke this version instead of mysqld for debugging support, memory allocation checking, and trace file support (see Section 7.9.1.2, “Creating Trace Files”). mysqld, also known as MySQL Server, is a single multithreaded program that does most ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-copying-database.html
$> mysqldump db1 > dump.sql $> mysqladmin create db2 $> mysql db2 < dump.sql Do not use --databases on the mysqldump command line because that causes USE db1 to be included in the dump file, which overrides the effect of naming db2 on the mysql ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-upgrade-testing.html
On the production server: $> mysqldump --all-databases --no-create-info > dump-data.sql On the upgraded server: $> mysql < dump-data.sql Now check the table contents and run some test queries. When contemplating a MySQL upgrade, it is prudent to ...
https://dev.mysql.com/doc/refman/8.4/en/online-ddl-parallel-thread-configuration.html
The default setting is calculated by the number of available logical processors on the system divided by 8, with a minimum default value of 4. The maximum setting is 256, which is the maximum number for all sessions. The actual number of threads ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
To create these names, use the QB_NAME hint, which assigns a name to the query block in which it occurs: QB_NAME(name) QB_NAME hints can be used to make explicit in a clear way which query blocks other hints apply to. One means of control over ...