PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/what-is-crashing.html
If you have examined all other possibilities and concluded that the MySQL server or a MySQL client is causing the problem, it is time to create a bug report, see Section 1.5, “How to Report Bugs or Problems”. This can normally be checked by ...
https://dev.mysql.com/doc/refman/5.7/en/windows-extract-archive.html
Make sure that you are logged in as a user with administrator privileges. To install MySQL manually, do the following: If you are upgrading from a previous version please refer to Section 2.10.8, “Upgrading MySQL on Windows”, before beginning ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
Masking functions provide strict and relaxed masking of Primary Account Numbers. Because it cannot be guaranteed that the number generated is not assigned to a legitimate payment account, the result of gen_rnd_pan() should never be displayed, other ... Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 6.5.2, “Installing or Uninstalling MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
You can verify that the UNDO files were created and obtain information about them by querying the Information Schema FILES table. ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
Once a data file has been created, its size cannot be changed; however, you can add more data files to the tablespace using additional ALTER TABLESPACE ... In addition, any data file to be dropped must previously have been added to the tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
When you create an ARCHIVE table, the server creates a table format file in the database directory. The storage engine creates other files, all having names beginning with the table name. Attempting to create an index on any other column results in ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/5.7/en/backup-methods.html
You can also create a binary backup simply by copying all table files, as long as the server is not updating anything. Also, even if the server is not actively updating data, InnoDB may still have modified data cached in memory and not flushed to ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). This type of backup is suitable for smaller amounts of data where you ...
https://dev.mysql.com/doc/refman/5.7/en/cache-index.html
The key cache referred to in a CACHE INDEX statement can be created by setting its size with a parameter setting statement or in the server parameter settings. A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE ...| tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/5.7/en/charset-database.html
The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET charset_name] [[DEFAULT] COLLATE collation_name] ALTER DATABASE db_name ... Every database has a database character set and a database ...