PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily defined and then altered in Section 13.7.5.18, “SHOW EVENTS Statement”): mysql> SHOW CREATE EVENT myschema.e_daily\G ... SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links.html
You might want to do this, for example, to move a database to a file system with more free space or increase the speed of your system by spreading your tables to different disks. You can move databases or tables from the database directory to other ...To determine the location of your data directory, use this statement: SHOW VARIABLES LIKE ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-unix.html
Note It is common for Yum or APT package installations to configure an error log file location under /var/log with an option like log-error=/var/log/mysqld.log in a server configuration file. If the server writes the error log to the console, it ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-data-manipulation-statements.html
As there are no primary servers (sources) for any particular data set, every server in the group is allowed to execute transactions at any time, even transactions that change state (RW transactions). If they receive it, then they all receive it in ...Any server may execute a transaction without any a priori ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
These checks can be deactivated by setting the option group_replication_enforce_update_everywhere_checks to FALSE. It is not possible to have members of the group deployed in different modes, for example one configured in multi-primary mode while ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-space-requirements.html
A large innodb_online_alter_log_max_size setting permits more DML during an online DDL operation, but it also extends the period of time at the end of the DDL operation when the table is locked to apply logged DML. If the MySQL temporary directory ... Online DDL operations have the following space requirements: Temporary log files: A temporary log file records concurrent DML when an online DDL operation creates an index or alters a ...
https://dev.mysql.com/doc/refman/5.7/en/loop.html
For the rules regarding label use, see Section 13.6.2, “Statement Labels”. Example: CREATE PROCEDURE doiterate(p1 INT) BEGIN label1: LOOP SET p1 = p1 + 1; IF p1 < 10 THEN ITERATE label1; END IF; LEAVE label1; END LOOP label1; SET @x = p1; END; .
https://dev.mysql.com/doc/refman/5.7/en/sys-list-add.html
This function and list_drop() can be useful for manipulating the value of system variables such as sql_mode and optimizer_switch that take a comma-separated list of values. Example mysql> SELECT @@sql_mode; +----------------------------------------+ ... Adds a value to a comma-separated list of values and returns the ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation-pkg.html
To complete the installation, you should set the root password for MySQL as provided in the instructions at the end of the installation. Removal of the package does not delete the existing database information, only the server, binaries and support ... You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary tarball ...The installation package enables you to install the runtime libraries ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-monitor.html
For the set of Oracle Technical Support Policies, visit: https://www.oracle.com/support/policies.html For an explanation of the different support models (like Sustaining Support), visit: https://www.oracle.com/support/lifetime-support/ For customers ... For information about MySQL Enterprise Monitor behavior, see the MySQL Enterprise Monitor manual: ...