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/show-procedure-status.html
It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. row *************************** Db: test Name: sp1 Type: PROCEDURE Definer: ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
For example, you cannot have two events in the same database with the names anEvent and AnEvent. This is because of the following: Stored routine definitions are kept in tables in the mysql system database using the MyISAM storage engine, and so do ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
A stored procedure or function is associated with a particular database. This can be used to refer to a routine that is not in the current database. For example, to invoke a stored procedure p or function f that is associated with the test database, ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. These events bring databases up to date from the point of the backup. The term “binary log file” generally denotes ...It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows), unless row-based logging is ...
https://dev.mysql.com/doc/refman/5.7/en/binlog-replication-configuration-overview.html
This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database changes originate) writes updates and changes as “events” to the binary ...Each replica receives a copy of the entire contents of the binary ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-find-table.html
You can check which tables are in the default database with SHOW TABLES. Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase.
https://dev.mysql.com/doc/refman/5.7/en/connecting.html
For mysql, the first nonoption argument is taken as the name of the default database. Because there is no such argument, mysql selects no default database. This section describes use of command-line options to specify how to establish connections ...
https://dev.mysql.com/doc/refman/5.7/en/connectors-apis.html
Connector/J provides driver support for connecting to MySQL from Java applications using the standard Java Database Connectivity (JDBC) API. Connector/ODBC provides driver support for connecting to MySQL using the Open Database Connectivity (ODBC) ... MySQL Connectors provide connectivity to the MySQL server for client ...
https://dev.mysql.com/doc/refman/5.7/en/disk-issues.html
This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database server. For large databases where you access data more or less randomly, you can be sure that you need at least one disk ...For information about optimizing an InnoDB configuration to improve I/O performance, see Section 8.5.8, “Optimizing InnoDB Disk ...