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/example-storage-engine.html
When you create an EXAMPLE table, the server creates a table format file in the database directory. mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 ...To ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-view-changes.html
Figure 17.10 Stable Group View Change: a Member Joins Whenever a new member joins the group and therefore a view change is performed, every online server queues a view change log event for execution. This is queued because before the view change, ...
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/show-procedure-status.html
row *************************** Db: test Name: sp1 Type: PROCEDURE Definer: testuser@localhost Modified: 2018-08-08 13:54:11 Created: 2018-08-08 13:54:11 Security_type: DEFINER Comment: character_set_client: utf8 collation_connection: ...It returns ...A similar statement, SHOW FUNCTION STATUS, displays information about stored functions (see Section 13.7.5.20, “SHOW FUNCTION STATUS ...