PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/stop-slave.html
When using the row-based logging format: You should execute STOP SLAVE or STOP SLAVE SQL_THREAD on the replica prior to shutting down the replica server if you are replicating any tables that use a nontransactional storage engine (see the Note later ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
If you are upgrading to MySQL 5.7 from an earlier version, be sure to update your grant tables to make sure that the proc table exists. In such a setup, applications and users would have no access to the database tables directly, but can only ...A ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
MySQL recognizes the escape sequences shown in Table 9.1, “Special Character Escape Sequences”. For the escape sequences that represent each of these characters, see Table 9.1, “Special Character Escape Sequences”. A string is a sequence of ...
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
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 Server Administration Program”, and Section 4.5.7, “mysqlshow — Display ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html
In the preceding discussion, the data set stored in tstable happens to consist of distinct UTC values. If the index is not UNIQUE, it is possible for the table (and the index) to store multiple instances of a given UTC value. Temporal values are ...
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 ...