PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions.html
For information on using replication in a backup environment, including notes on the setup, backup procedure, and files to back up, see Section 16.3.1, “Using Replication for Backups”. For performance or data distribution reasons, you may want ... Replication can be used in many different environments for a range of ...Using replication as a scale-out solution requires ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-key-cache.html
To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems. It employs a cache mechanism to keep the most frequently accessed table blocks in memory: For index blocks, a special structure ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-limits.html
The maximum number of operations that can be performed per transaction is set using the configuration parameters MaxNoOfConcurrentOperations and MaxNoOfLocalOperations. Instead, the following rules hold true: A DELETE statement on an NDB table makes ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects.html
This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. A procedure does not have a return value but can modify its parameters for later inspection by the caller. It can ...Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
MySQL Workbench provides a graphical tool for working with MySQL servers and databases. Data Modeling: Enables you to create models of your database schema graphically, reverse and forward engineer between a schema and a live database, and edit all ...For more information, see the MySQL Workbench manual, available at ...MySQL Workbench may connect to MySQL Server 8.4 and higher but some ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-ddl.html
If this option is set to a value greater than 1, use READ UNCOMMITTED queries to find rows that were just inserted. If this option is set to a value greater than 1, changes made to the table using SQL are not immediately visible to memcached ... You ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-restrictions.html
As of MySQL 5.7.8, the default value for this directory can be set at build time with the INSTALL_SECURE_FILE_PRIV_EMBEDDEDDIR CMake option. You cannot set this up as a source or a replica (no replication). Very large result sets may be unusable on ... The embedded server has the following limitations: No loadable ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
For full-text indexes, the PAGE_NO column is unused and set to -1 (FIL_NULL) because the full-text index is laid out in several B-trees (auxiliary tables). The INNODB_SYS_INDEXES table provides metadata about InnoDB indexes, equivalent to the ...