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/stored-routines-syntax.html
For example, to invoke a stored procedure p or function f that is associated with the test database, you can say CALL test.p() or test.f(). A stored procedure or function is associated with a particular database. This has several implications: When ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/5.7/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
For most operations on InnoDB tables, you should use the setting autocommit=0. SET unique_checks=1; For big tables, this saves disk I/O because InnoDB can use its change buffer to write secondary index records as a batch. In the case of a runaway ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-example.html
This should be similar to what is shown here, where password is the MySQL root password for a given MySQL server instance: $> mysqladmin -uroot -ppassword shutdown 081208 20:19:56 mysqld_safe mysqld from pid file /usr/local/mysql/var/tonfisk.pid ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. If there is no logical unique and non-null column ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-tuning.html
get key_value Using System Memory For best performance, deploy the daemon_memcached plugin on machines that are configured as typical database servers, where the majority of system RAM is devoted to the InnoDB buffer pool, through the ... Because ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
ENGINE sets the storage engine that uses the tablespace, where engine_name is the name of the storage engine. For an InnoDB tablespace, all tables must be dropped from the tablespace prior to a DROP TABLESPACE operation. As with the InnoDB system ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-create.html
If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. The preceding error is a typical message for ...One fix is to start mysqld with the --tmpdir option or to add the option to the [mysqld] section of your option ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-syslog.html
(On Windows, log_syslog is enabled by default.) If log_syslog is enabled, the following system variables can also be used for finer control. Note Using mysqld_safe for syslog error logging is deprecated; you should use the server system variables ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
To check whether disabling use of index extensions improves performance, use this statement: SET optimizer_switch = 'use_index_extensions=off'; Use of index extensions by the optimizer is subject to the usual limits on the number of key parts in an ...This can result in more efficient query execution plans and better ... InnoDB automatically ...