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/host-cache.html
The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined using SELECT statements. It does not use the cache for TCP connections established using a loopback interface address (for example, 127.0.0.1 ... The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
This exception causes the following anomaly: If you update some rows in a table, a SELECT sees the latest version of the updated rows, but it might also see older versions of any rows. If other sessions simultaneously update the same table, the ...
https://dev.mysql.com/doc/refman/5.7/en/load-data-local-security.html
The LOAD DATA statement loads a data file into a table. To avoid connecting to untrusted servers, clients can establish a secure connection and verify the server identity by connecting using the --ssl-mode=VERIFY_IDENTITY option and the appropriate ...The statement can load a file located on the server host, or, if the LOCAL keyword is specified, on the client ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-start.html
The following options to mysqld can be used to change the behavior of MyISAM tables. Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers between writes for any MyISAM table. Note If you do this, you should not access MyISAM ...bulk_insert_buffer_size The size of the tree cache used in bulk insert ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-check-options.html
myisamchk supports the following options for table checking operations: --check, -c Command-Line Format --check Check the table for errors. --check-only-changed, -C Command-Line Format --check-only-changed Check only tables that have changed since ...This is the default operation if you specify no option that selects an operation type ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
ALGORITHM=INPLACE, REORGANIZE PARTITION statement in the mysql client for each NDBCLUSTER table. Exception: For tables created using the MAX_ROWS option, this statement does not work; instead, use ALTER TABLE ... Note This needs to be done only for ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
drop db_name Delete the database named db_name and all its tables. Caution Do not use this command used if the server was started with the --skip-grant-tables option. This is true even if you precede the password command with flush-privileges on the ...You can use it to check the server's configuration and current status, to create and drop databases, and ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. See Section 8.4.7, “Limits on Table Column Count and Row Size”. (The practical limit is less than 3000.) A table can ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
The maximum number of tables that can be referenced in the definition of a view is 61. However, a view that is processed with the temptable algorithm is unable to take advantage of indexes on its underlying tables (although indexes can be used ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
Since the user does not have the INSERT privilege for the table in question, the event has no effect. If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: ...