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/faqs-stored-procs.html
What limitations exist for replicating stored procedure and function actions? A.4.27. You can obtain information about existing stored procedures using the ROUTINES table in the INFORMATION_SCHEMA database (see Section 24.3.21, “The ...Where can I ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
When specifying a file name at startup, the file must exist or InnoDB returns a startup error indicating that there is no such file or directory. Changing the innodb_file_format setting does not affect the file format of existing InnoDB tablespace ... System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
If a session issues a LOCK TABLES statement to acquire a lock while already holding locks, its existing locks are released implicitly before the new locks are granted. If a session begins a transaction (for example, with START TRANSACTION), an ...
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
Multiple simultaneous locks can be acquired and GET_LOCK() does not release any existing locks. Before MySQL 5.7, only a single simultaneous lock can be acquired and GET_LOCK() releases any existing lock. For example, if the statement fails part way ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
To specify this, use the ENGINE=NDBCLUSTER or ENGINE=NDB option when creating the table: CREATE TABLE tbl_name (col_name column_definitions) ENGINE=NDBCLUSTER; Alternatively, for an existing table that uses a different storage engine, use ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
Files relating to existing Disk Data tables continue to use the old format until their tablespaces and undo log file groups are re-created. To avoid problems relating to the changes in format, you should re-create any existing tablespaces and undo ... New features and other important changes in NDB Cluster 7.6 which are likely to be of interest are shown in the following list: New Disk Data table file ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-setup.html
MySQL Installer detects existing MySQL products installed on the host during its initial setup and adds them to the list of products to be managed. Click Next to ignore the conflict and overwrite files in the existing folder. Choosing a Setup Type ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
CREATE FUNCTION GTID_INTERSECTION(gs1 LONGTEXT, gs2 LONGTEXT) RETURNS LONGTEXT RETURN GTID_SUBTRACT(gs1, GTID_SUBTRACT(gs1, gs2)) | This function returns the symmetric difference between two GTID sets, that is, the GTIDs that exist in gs1 but not in ... This section provides examples of stored functions (see Chapter 23, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config.html
(For example, the variable corresponding to the diagnostics.include_raw option is @sys.diagnostics.include_raw.) If the user-defined variable exists in the current session and is non-NULL, the function uses its value in preference to the value in ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist These messages often occur when the MySQL base or data directories are installed in different locations than the default locations (C:\Program Files\MySQL\MySQL ...