PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/firewall-elements.html
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 ...
https://dev.mysql.com/doc/refman/8.0/en/gone-away.html
This section also covers the related Lost connection to server during query error. The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. In this case, you normally get one of the ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. For information about other tables in the system database, see Section 7.3, “The mysql System Schema”. The ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role [, user_or_role] ... These syntax restrictions apply: GRANT cannot mix granting both privileges and roles ...
https://dev.mysql.com/doc/refman/8.0/en/index-extensions.html
InnoDB automatically extends each secondary index by appending the primary key columns to it. Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The SCHEMATA table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. The following statements are equivalent: SELECT SCHEMA_NAME ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. To use the AUTO_INCREMENT mechanism with an InnoDB table, an ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning-monitoring.html
Overall application performance, CPU and I/O utilization and the size of disk files are good indicators of how effective compression is for your application. This section builds on the performance tuning advice from Section 17.9.1.3, “Tuning ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. A full-text index is defined as part of a CREATE TABLE statement or added to an ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-security.html
Caution Consult this section before deploying the daemon_memcached plugin on a production server, or even on a test server if the MySQL instance contains sensitive data. Because memcached does not use an authentication mechanism by default, and the ...