Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/en/converting-tables-to-innodb.html
In the case of a runaway rollback, if you do not have valuable data in your database, it may be advisable to kill the database process rather than wait for millions of disk I/O operations to complete. For example, a personnel database might have ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-information-schema.html
When the underlying data dictionary tables store values previously obtained by directory scans (for example, to enumerate database names or table names within databases) or file-opening operations (for example, to read information from .frm files), ...In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/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 10.5.8, “Optimizing InnoDB Disk ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/en/firewall-elements.html
Tables in the firewall database provide backing storage of firewall data for persistence of profiles across server restarts. The firewall database can be the mysql system database or a custom schema (see Installing MySQL Enterprise Firewall). This ... MySQL Enterprise Firewall is based on a plugin library that includes these elements: A server-side plugin named MYSQL_FIREWALL examines SQL statements before they execute and, based on the registered firewall profiles, renders a decision whether to execute or reject each ...
https://dev.mysql.com/doc/refman/8.4/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 ...