PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/connectors-apis.html
Native drivers are also easier for end users to build and deploy because no copy of the MySQL client libraries is needed to build the native driver components. Connector/J provides driver support for connecting to MySQL from Java applications using ... MySQL Connectors provide connectivity to the MySQL server for client ...APIs provide low-level ...
https://dev.mysql.com/doc/refman/5.7/en/show-collation.html
Default Whether the collation is the default for its character set. To see the default collation for each character set, use the following statement. Charset The name of the character set with which the collation is associated. Sortlen This is ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. A similar statement, SHOW FUNCTION CODE, displays information about stored functions (see Section ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-management.html
More detailed information about NDB Cluster operations is available in real time through an SQL interface using the ndbinfo database. For more information, see Section 21.6.15, “ndbinfo: The NDB Cluster Information Database”. The values of these ...For information about security issues relating to management and deployment of an NDB Cluster, see Section 21.6.18, “NDB Cluster Security ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
For example, to invoke a stored procedure p or function f that is associated with the test database, you can say CALL test.p() or test.f(). A stored procedure or function is associated with a particular database. This has several implications: When ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-server.html
This setting modifies certain aspects of SQL syntax and semantics, for example for compatibility with code from other database systems, or to control the error handling for particular situations. There are performance and reliability considerations ...The following discussion covers these MySQL server configuration topics: Startup options that the server ...
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
The plugins supported by this interface include, but are not limited to, storage engines, INFORMATION_SCHEMA tables, full-text parser plugins, partitioning support, and server extensions. MySQL distributions include several plugins that implement ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.html
--database=db_name, -d Command-Line Format --database=name Type String Default Value [none] Specify the database to find the table in. --ndb-connectstring Command-Line Format --ndb-connectstring=connection_string Type String Default Value [none] Set ... This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
In conjunction with the MySQL binary log, users can perform point-in-time recovery. MySQL Enterprise Backup can also create compressed backup files, and back up subsets of tables and databases. The key to safe database management is making regular ...When mysqlbackup is copying InnoDB tables, reads and writes to InnoDB tables can ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multiple-buffer-pools.html
For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve concurrency, by reducing contention as different threads read and write to cached pages. This feature is typically intended for ...Multiple buffer pool instances are configured using the innodb_buffer_pool_instances configuration option, and you might also adjust the innodb_buffer_pool_size ...