PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
The following examples show other common error messages you might encounter when installing MySQL and starting the server for the first time: If the MySQL server cannot find the mysql privileges database or other critical files, it displays these ...
https://dev.mysql.com/doc/refman/5.7/en/system-variable-privileges.html
For some system variables, setting the session value may have effects outside the current session and thus is a restricted operation that can be done only by users who have the SUPER privilege. In contrast to setting global runtime values, setting ...Setting the session value of these variables affects binary logging for the current session, but may also have wider implications for the integrity of server replication and ...
https://dev.mysql.com/doc/refman/5.7/en/security.html
The security is related to the grants for individual users, but you may also wish to restrict MySQL so that it is available only locally on the MySQL server host, or to a limited set of other hosts. These include choosing good passwords, not ...For ... When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-file-context.html
If the SELinux context is not set correctly for these files, access to the files could be denied. If you edit the configuration file to use a different location for the data directory, or for any of the files normally in the data directory (such as ...semanage fcontext -l | grep -i mysql Setting the MySQL Data Directory Context The default data directory location is /var/lib/mysql/; and the SELinux context used is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
16.1.7.3.2.1 Skipping Transactions With SET GLOBAL sql_slave_skip_counter When you have assessed the failing transaction for any other appropriate actions as described previously (such as security considerations), count the number of events that you ...Before skipping a transaction, ensure that the replication I/O thread is stopped as well as the replication SQL ... If replication stops due to an issue ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
The default settings represent a combination of high reliability and the fewest surprises for database applications. For example, default settings avoid uncommitted data on the database side, or stale data returned for memcached get requests. You ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-nodes.html
SINGLEUSER is displayed in the status column for all data nodes when the cluster is in single user mode (see Section 21.6.6, “NDB Cluster Single User Mode”). For example, if you put the cluster in single user mode, you can sometimes see data ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
In addition, the table is compressed periodically at a user-configurable rate; see mysql.gtid_executed Table Compression, for more information. For example, the values stored by the gtid_executed and gtid_purged system variables are GTID sets. The ...If a client transaction is not written to the binary log (for example, because the transaction was filtered out, or the transaction was read-only), it is not assigned a GTID on the server of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
In addition to user data, the page format includes some internal system data that is not compressed. Given these considerations, for many applications, some tables compress more effectively than others, and you might find that your workload performs ...However, because the efficiency of compression depends on the nature of your data, you can make decisions that affect the performance of compressed tables: Which tables to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
(Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents of setup_objects; the row for information_schema.% simply makes this default explicit.) When the Performance Schema checks for a match in setup_objects, it ...