PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/keyring-okv-component.html
"cache_keys": If the value is true, the keys are cached in memory in plaintext. For example, use a command like this, and enter the encryption password at the prompts: $> openssl rsa -des3 -in key.pem -out key.pem.new Enter PEM pass phrase: ... Note ...
https://dev.mysql.com/doc/refman/9.7/en/keywords.html
This requirement enables the parser to distinguish whether the name is used in a function call or in nonfunction context. Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as ...
https://dev.mysql.com/doc/refman/9.7/en/large-page-support.html
As system root, open the file /etc/sysctl.conf in a text editor, and add the line shown here, where P is the number of large pages obtained in the previous step: vm.nr_hugepages=P Using the actual value obtained previously, the additional line ...
https://dev.mysql.com/doc/refman/9.7/en/merge-table-advantages.html
(You can create FULLTEXT indexes on the underlying MyISAM tables, but you cannot search the MERGE table with a full-text search.) If the MERGE table is nontemporary, all underlying MyISAM tables must be nontemporary. MERGE tables can help you solve ...
https://dev.mysql.com/doc/refman/9.7/en/mle-component-options-variables.html
This value is equal to the size of the stored program's source text, expressed in bytes. The following table lists all MySQL system variables and status variables supported by the ML component. Detailed descriptions of these variables can be found ...
https://dev.mysql.com/doc/refman/9.7/en/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-maintenance-schedule.html
If you are performing many updates to MyISAM tables with dynamic-sized rows (tables with VARCHAR, BLOB, or TEXT columns) or have tables with many deleted rows you may want to defragment/reclaim space from the tables from time to time. It is a good ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-table-formats.html
When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT columns, you can force the table format to FIXED or DYNAMIC with the ROW_FORMAT table option. Two of them, fixed and dynamic format, are chosen automatically depending on ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-table-maintenance.html
myisamchk operations that affect indexes can cause MyISAM FULLTEXT indexes to be rebuilt with full-text parameters that are incompatible with the values used by the MySQL server. This section discusses how to use myisamchk to check or repair MyISAM ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data objects. A tablespace contains one or more data files and one or more undo log file groups. Undo log file: Contains undo ...