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/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...
https://dev.mysql.com/doc/refman/5.7/en/charset-table.html
Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can cause problems if no corresponding directory exists in the replica host's file ...
https://dev.mysql.com/doc/refman/5.7/en/system-optimization.html
Some system-level factors can affect performance in a major way: If you have enough RAM, you could remove all swap devices. Some operating systems use a swap device in some contexts even if you have free memory. The --external-locking and ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
For example: $> docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES a24888f0d6f4 mysql/mysql-server "/entrypoint.sh my..." 14 seconds ago Up 13 seconds (health: starting) 3306/tcp, 33060/tcp mysql1 The container initialization might take ...Because the MYSQL_ONETIME_PASSWORD option is true by default, after you have connected a mysql client to the server, you must reset the server root password by issuing this statement: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; Substitute password with the password of your ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-restrictions.html
The plugin must be installed on each MySQL server that is used to execute SQL on the cluster. MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as memcached, Node.JS, ...
https://dev.mysql.com/doc/refman/5.7/en/loop.html
[begin_label:] LOOP statement_list END LOOP [end_label] LOOP implements a simple loop construct, enabling repeated execution of the statement list, which consists of one or more statements, each terminated by a semicolon (;) statement delimiter.
https://dev.mysql.com/doc/refman/5.7/en/stop-slave.html
When the timeout value is reached, the issuing client returns an error message and stops waiting, but the STOP SLAVE instruction remains in effect. If the replica is stopped unexpectedly (for example due to an error in a worker thread, or another ...
https://dev.mysql.com/doc/refman/5.7/en/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are latin1 and ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-user.html
SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. The statement requires the SELECT privilege for the mysql system database, except to display information for the current user. To name the account, ...