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/glossary.html
Experienced users can adjust the isolation level, trading off less protection in favor of increased performance and concurrency, when they can be sure that the transactions really do not interfere with each other. Closing an account at an online ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ....frm Files MySQL stores data dictionary information for tables in .frm files in database ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
You can do so by creating tables to hold your data and loading them with the desired information. Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system database. For example: DROP USER 'jeffrey'@'localhost'; ...It removes privilege rows for the account from all grant ...Attempts to access such objects may ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
(This constraint rules out the use of the keyring functions for manipulation of instance-wide keys, such as those created by InnoDB to support tablespace encryption.) To enable multiple users to perform operations on the same key, “wrapper” ...A ... MySQL Server supports a keyring service that enables internal server components and plugins to store sensitive information securely for later ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-security-procedures.html
You should also delete the anonymous user account that is installed by default. First and foremost, you should always run a MySQL Server as the mysql operating system user; this is no different from running MySQL in a standard (non-Cluster) ... In ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
An error occurs if a sys schema exists but has no version view, on the assumption that its absence indicates a user-created schema: A sys schema exists with no sys.version view. If you have a user created sys schema, this must be renamed for the ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
If you start the server as root without using --user=mysql, the server may create root-owned files in the data directory, such as log files, and these may cause permission-related problems for future server startups. This enables anyone to connect ...For instructions on assigning a password, see Section 2.9.4, “Securing the Initial MySQL ... If you have never assigned ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
The accounts table has USER and HOST columns to track connections per user and host combination. The Performance Schema tracks the connections as follows: The accounts table has four rows, for the user1/hosta, user1/hostb, user2/hosta, and ... When ...Each connection table has CURRENT_CONNECTIONS and TOTAL_CONNECTIONS columns to track the current and total number of connections per “tracking value” on which its statistics are ...