PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long time. There are three general ways to invoke mysqlcheck: mysqlcheck [options] db_name [tbl_name ...] ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
These privileges are global because they are not specific to a particular database. Database privileges apply to a database and to all objects within it. These privileges can be granted for specific databases, or globally so that they apply to all ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-db-options.html
In those cases, the database being created, altered, or dropped replaces the default database when determining whether to log or ignore updates. The database that is checked for a match depends on the binary log format of the statement that is being ... When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or --replicate-ignore-db options that ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
If it does, the relative part of the path is replaced with the absolute path set using the --log-bin option. Only those statements are written to the binary log where the default database (that is, the one selected by USE) is db_name. To specify ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
Without this option, mysqldump treats the first name as a database name and those following as table names. With --all-databases or --databases, mysqldump writes CREATE DATABASE and USE statements prior to the dump output for each database. This ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-databases.html
Replacing a database directory with a symbolic link works as long as you do not make a symbolic link between databases. On Unix, the way to symlink a database is first to create a directory on some disk where you have free space and then to create ...If one client updates db1.tbl_a and another client updates db2.tbl_a, problems are likely to ...
https://dev.mysql.com/doc/refman/5.7/en/windows-symbolic-links.html
On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a different location (for example, on a different disk) by setting up a symbolic link to it. Use of database symlinks on Windows is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-database-objects.html
Some database objects such as tables and indexes have different limitations when using the NDBCLUSTER storage engine: Database and table names. When using the NDB storage engine, the maximum allowed length both for database names and for table ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. Note Comparison behavior for database and table names in INFORMATION_SCHEMA queries might differ from what you expect. 1) Try to use constant lookup values for ...Certain types of queries for INFORMATION_SCHEMA tables can be optimized to execute more ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
YourSQL','When comparing databases ...'), -> ('MySQL Security','When configured properly, MySQL ...'), -> ('Database, Database, Database','database database database'), -> ('1001 MySQL Tricks','1. | 0.36289870738983154 | | 1 | MySQL Tutorial | This ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...