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/subquery-errors.html
However, you cannot use the same table (in this case, table t1) for both the subquery FROM clause and the update target. Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links.html
You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new locations. You might want to do this, for example, to move a database to a file system with more free space or increase ...The recommended way to do this is to symlink entire database directories to a different ...
https://dev.mysql.com/doc/refman/5.7/en/sys-processlist.html
They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also nonblocking. For additional information, see the description of the Performance Schema threads table at Section ...
https://dev.mysql.com/doc/refman/5.7/en/system-optimization.html
Just remember to take down the server (or lock and flush the relevant tables) before you run myisamchk. The only case in which you cannot disable external locking is when you run multiple MySQL servers (not clients) on the same data, or if you run ... Some system-level factors can affect performance in a major way: If you have enough RAM, you could remove all swap ...
https://dev.mysql.com/doc/refman/5.7/en/testing-server.html
Alternatively, add the bin directory to your PATH environment variable setting. For more information about mysql, mysqladmin, and mysqlshow, see Section 4.5.1, “mysql — The MySQL Command-Line Client”, Section 4.5.2, “mysqladmin — A MySQL ... After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works ...
https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. With --tab, mysqldump produces two output files for each dumped table. The server ... This section describes how to use mysqldump to produce dump files, and how to reload dump ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation.html
Important MySQL Community 5.7 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows platforms. This requirement changed over time: MySQL 5.7.37 and below requires the Microsoft Visual C++ 2013 Redistributable ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-exclusive-to-cluster.html
NDB Cluster has the following limitations or restrictions with regard to binary logging: NDB Cluster cannot produce a binary log for tables having BLOB columns but no primary key. The following are limitations specific to the NDB storage engine: ...
https://dev.mysql.com/doc/refman/5.7/en/view-syntax.html
To alter the definition of a view or drop a view, use ALTER VIEW (see Section 13.1.10, “ALTER VIEW Statement”), or DROP VIEW (see Section 13.1.32, “DROP VIEW Statement”). The CREATE VIEW statement creates a new view (see Section 13.1.21, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
The innodb_api_enable_mdl option can be used to lock the table at the MySQL level, so that the mapped table cannot be dropped or altered by DDL through the SQL interface. Direct access to InnoDB tables, bypassing the SQL parser, the optimizer, and ... The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB storage engine directly, bypassing the MySQL SQL ...