PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Do the preceding limitations affect the ability of MySQL to do point-in-time recovery? A.4.28. If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: ...Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-desc.html
You can check that the ALTER TABLE statement has the desired effect using SHOW CREATE TABLE: mysql> SHOW CREATE TABLE fish\G *************************** 1. You can obtain such information, using the mysql client, from the table_distribution_status, ... ndb_desc provides a detailed description of one or more NDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-init-startup-configuration.html
Normally, InnoDB is initialized when the MySQL server is started for the first time. You can place InnoDB options in the [mysqld] group of any option file that your server reads when it starts. The locations of MySQL option files are described in ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
There are many reasons why you might want to import tables: To run reports on a non-production MySQL server instance to avoid placing extra load on a production server. The page size of the tablespace must match the page size of the destination ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-oci-marketplace-deploy.html
To deploy MySQL EE on Oracle Cloud Infrastructure, do the following: Open the OCI Marketplace and select MySQL. By default, the MySQL server listens on port 3306 and is configured with a single user, root. Important When the deployment is complete, ...See To create a Linux instance for information on how to complete the ...
https://dev.mysql.com/doc/refman/8.0/en/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. Available in MySQL Community Edition and MySQL Enterprise Edition distributions as of MySQL 8.0.24. The ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-prefpane.html
The MySQL Installation Package includes a MySQL preference pane that enables you to start, stop, and control automated startup during boot of your MySQL installation. Figure 2.20 MySQL Preference Pane: Location The MySQL preference pane is ...This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-config.html
mysql_config provides you with useful information for compiling your MySQL client and connecting it to MySQL. Note pkg-config can be used as an alternative to mysql_config for obtaining information such as compiler flags or link libraries required ...It is a shell script, so it is available only on Unix and Unix-like ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-logging.html
The mysql client can do these types of logging for statements executed interactively: On Unix, mysql writes the statements to a history file. By default, this file is named .mysql_history in your home directory. To specify a different file, set the ...On Unix, this is syslog; on Windows, it is the Windows Event ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
This is a MySQL extension to standard SQL, which permits only one of each clause per ALTER TABLE statement. InnoDB in MySQL 8.0.17 and later supports addition of multi-valued indexes on JSON columns using a key_part specification can take the form ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...