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/use.html
USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. This statement requires some privilege for the database or some object within it. The named database remains the ...
https://dev.mysql.com/doc/refman/5.7/en/cost-model.html
The optimizer also has a database of cost estimates to use during execution plan construction. These estimates are stored in the server_cost and engine_cost tables in the mysql system database and are configurable at any time. Cost Model General ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
The next example creates three accounts and grants them access at lower levels; that is, to specific databases or objects within databases. The 'custom'@'host47.example.com' account has specific database-level privileges to access the expenses ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-reference.html
The firewall database can be the mysql system database or a custom schema (see Installing MySQL Enterprise Firewall). Each mysql system database table is accessible only by accounts that have the SELECT privilege for it. To invoke a firewall stored ...When enabled, the firewall bases operational decisions on the cached ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-show-tables.html
ndb_show_tables displays a list of all NDB database objects in the cluster. --database, -d Specifies the name of the database in which the desired table is found. If this option is given, the name of a table must follow the database name. If this ...By default, this includes not only both user-created tables and NDB system tables, but NDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 4.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/5.7/en/access-control.html
The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE. For example: SHOW GRANTS FOR ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
Is there a way to view all stored procedures and stored functions in a given database? A.4.7. Is there a MySQL equivalent to using mod_plsql as a gateway on Apache to talk directly to a stored procedure in the database? A.4.17. You can obtain ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
InnoDB data-at-rest encryption is designed to transparently apply encryption within the database without impacting existing applications. InnoDB data-at-rest encryption provides the benefit of encryption without the overhead associated with ...Is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
These properties make this compression technique unsuitable for use in an update-intensive database system. Unlike compression performed by an application, or compression features of some other database management systems, InnoDB compression applies ... This section describes some internal implementation details about compression for InnoDB ...