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/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Whereas a trigger is a database object whose ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or Database? A.1.5. Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or Database? Yes. If the database is I/O-bound (indicated by CPU consumption less than ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-information-schema.html
Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Can I add to or otherwise modify the tables found in the INFORMATION_SCHEMA database? A.7.1. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? ...Where can I find the ANSI SQL 2003 specification for INFORMATION_SCHEMA? ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-sql-modes.html
This makes it easier to use MySQL in different environments and to use MySQL together with other database servers. Is the mode dependent on the database or connection? A mode is not linked to a particular database. What is the default server SQL ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-background.html
Specifically, replicated databases have to deal with the fact that they require maintenance and administration of several servers instead of just one. Therefore, the ultimate challenge is to fuse the logic of the database and data replication with ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
This applies to identifiers in table definitions that are stored in .frm files and to identifiers stored in the grant tables in the mysql database. NDB Cluster imposes a maximum length of 63 characters for names of databases and tables. See Section ... The following table describes the maximum length for each type of ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, and other object names are known as identifiers. Special characters in database and table names are encoded in the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
NAME The name of the table, preceded by the schema (database) name where appropriate (for example, test/t1). Names of databases and user tables are in the same case as they were originally defined, possibly influenced by the lower_case_table_names ... The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information from the SYS_TABLES table in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the database.
https://dev.mysql.com/doc/refman/5.7/en/innodb-checkpoints.html
InnoDB flushes modified database pages from the buffer pool in small batches. It knows that all modifications to the database before the label are present in the disk image of the database. Then InnoDB scans the log files forward from the ... Making ...