PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
Note Named time zones can be used only if the time zone information tables in the mysql database have been created and populated. If your system has its own zoneinfo database (the set of files describing time zones), use the mysql_tzinfo_to_sql ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-desc.html
You can obtain such information, using the mysql client, from the table_distribution_status, table_fragments, table_info, and table_replicas tables in the ndbinfo database. --context, -x Show additional contextual information for the table such as ... ndb_desc provides a detailed description of one or more NDB ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-tables.html
Note When you drop a table that is using symlinks, both the symlink and the file to which the symlink points are dropped. This is an extremely good reason not to run mysqld as the root operating system user or permit operating system users to have ... Note Symbolic link support as described here, along with the --symbolic-links option that controls it, and is deprecated; expect these to be removed in a future version of ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
Another use for UNLOCK TABLES is to release the global read lock acquired with the FLUSH TABLES WITH READ LOCK statement, which enables you to lock all tables in all databases. A session holding a WRITE lock can perform table-level operations such ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. Using prepared ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
InnoDB data-at-rest encryption is designed to transparently apply encryption within the database without impacting existing applications. InnoDB data-at-rest encryption provides the benefit of encryption without the overhead associated with ...Is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
These properties make this compression technique unsuitable for use in an update-intensive database system. Unlike compression performed by an application, or compression features of some other database management systems, InnoDB compression applies ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-blob-tool.html
If you need to specify a database, use the --database (-d) option. --database=db_name, -d Command-Line Format --database=name Type String Default Value [none] Specify the database to find the table in. This tool can be used to check for and remove ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
(NDB 8.0.13) This parameter defines the amount of space (in bytes) available for storing database records. For large databases, it may be preferable to use a 64-bit operating system for this reason. An important point for both IndexMemory and ...
https://dev.mysql.com/doc/refman/8.0/en/secure-client-programming.html
Be sure that your application remains secure if a user tries to perform SQL injection by entering something like ; DROP DATABASE mysql; into a form. Sometimes people think that if a database contains only publicly available data, it need not be ...