PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html
| innodb_autoextend_increment | 8 | | innodb_buffer_pool_size | 8388608 | | innodb_commit_concurrency | 0 | | innodb_concurrency_tickets | 500 | | innodb_data_file_path | ibdata1:10M:autoextend | | innodb_data_home_dir | | ... System variables can ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
The database administrator must set these variables at server startup if the key files to use have names that differ from the system variable default values. If the private and public key files are located in the data directory and are named ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
You want specific transactions in your workload to always read up-to-date data from the group, for example whenever sensitive data is updated (such as credentials for a file or similar data) and you want to enforce that reads retrieve the most up to ...This means that as soon as the incoming traffic slows down or stops, all group members have the same data ... In terms of distributed consistency guarantees, ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
The tradeoffs are: An index must be updated when table data is modified. The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The ...The table ...This is needed when reading and parsing histograms from persistent storage into ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-native.html
To start the MySQL server use systemctl: $> systemctl start mysqld The database tables are automatically created for you, if they do not already exist. Note Before installing, make sure that you update your apt-get index files to ensure you are ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-failure-handling.html
For informational purposes, warnings are printed to the server error log to specify when data removal starts and finishes: [Warning] [MY-013453] [InnoDB] Clone removing all user data for provisioning: Started... [Warning] [MY-013453] [InnoDB] Clone ...If a failure occurs during the prerequisite check, the CLONE INSTANCE operation reports an ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
MyISAM supports concurrent inserts: If a table has no free blocks in the middle of the data file, you can INSERT new rows into it at the same time that other threads are reading from the table. You can put the data file and index file in different ...Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes (Compressed MyISAM tables are supported only when using the compressed row ...
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
For distributions that do not do this, you must initialize the data directory manually. (The data directory normally is named data or var and is located under your MySQL installation directory.) Make sure that you have a file named user.MYD in the ...To correct this when you invoke a client program, specify a --port option to indicate the proper port number, or a --socket option to indicate the proper named pipe or Unix socket ...
https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html
Alternatively, if you have a MySQL source distribution, you can test your setup using the demonstration certificate and key files in its mysql-test/std_data directory. (The files need not have been generated automatically; what matters is that they ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-debian.html
Users who want to set a password later can leave the password field blank in the dialogue box and just press OK; in that case, root access to the server is authenticated using the MySQL Socket Peer-Credential Authentication Plugin for connections ...