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/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 ...
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/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-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. However, it does need to access the MySQL server on which the database to ...Unlike the other utilities discussed in this section, it does not require access to an NDB Cluster (in fact, there is no reason for it to do ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
This option is on by default, which enables database, table, and column name completion. (Default value is 0.) --database=db_name, -D db_name Command-Line Format --database=dbname Type String The database to use. --one-database, -o Command-Line ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. To add, access, and process data stored in a computer database, you need a database management system such as MySQL ...The MySQL website (http://www.mysql.com/) provides the latest information about MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table options. The effect of the replication filtering options differs between binary logging formats because of the way the database name is ...It is also important ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
If the database on the source contains existing data it is necessary to copy this data to each replica. To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the ...