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/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME USER, CREATE (all forms except CREATE TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. Starting with an efficient database design makes it easier for team members to write high-performing application code, and makes the ...As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the data volume ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
query-start(query, connectionid, database, user, host) query-done(status) query-start: Triggered after the query string has been received from the client. database: The database name on which the query is being executed. database: The database name ... MySQL supports the following static probes, organized into groups of ...
https://dev.mysql.com/doc/refman/5.7/en/database-count-limit.html
The underlying file system may have a limit on the number of directories. The underlying file system may have a limit on the number of files that represent tables.
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-copying-database.html
$> mysqldump db1 > dump.sql $> mysqladmin create db2 $> mysql db2 < dump.sql Do not use --databases on the mysqldump command line because that causes USE db1 to be included in the dump file, which overrides the effect of naming db2 on the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
ndbinfo is a database containing information specific to NDB Cluster. This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. This is true even when using the ...You can find more detailed information about each of these tables in the next several ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
MySQL now enables database administrators to establish a policy for automatic password expiration: Any user who connects to the server using an account for which the password is past its permitted lifetime must change the password. Data masking ...
https://dev.mysql.com/doc/refman/5.7/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump --databases db1 > dump.sql Copy the dump file from Server 1 to Server 2. On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE ...