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/events-configuration.html
Starting the MySQL server with the --skip-grant-tables option causes event_scheduler to be set to DISABLED, overriding any other value set either on the command line or in the my.cnf or my.ini file (Bug #26807). Events are executed by a special ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuring-io-capacity.html
You can set the innodb_io_capacity value in the MySQL option file (my.cnf or my.ini) or modify it at runtime using a SET GLOBAL statement, which requires privileges sufficient to set global system variables. You can set the innodb_flush_sync value ... The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing dirty pages from the buffer pool and writing changes from the change buffer to the appropriate secondary ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-unix-servers.html
Note The discussion here uses mysqld_safe to launch multiple instances of MySQL. For MySQL installation using an RPM distribution, server startup and shutdown is managed by systemd on several Linux platforms. On these platforms, mysqld_safe is not ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterbaseconfig.html
In this case, shut down the MySQL server and edit the my.cnf or my.ini file. Note The following options have an impact on this procedure: For the greatest possible durability and consistency in a replication setup using InnoDB with transactions, you ... To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option files). For general instructions on setting parameters at startup or runtime, see Section 5.1.6, ...
https://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html
To start the server as the given user automatically at system startup time, specify the user name by adding a user option to the [mysqld] group of the /etc/my.cnf option file or the my.cnf option file in the server's data directory. On Windows, you ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html
If mysqld does not want to start, verify that you have no my.cnf files that interfere with your setup! You can check your my.cnf arguments with mysqld --print-defaults and avoid using them by starting with mysqld --no-defaults .... If you are using ...
https://dev.mysql.com/doc/refman/5.7/en/host-cache.html
For example, to set the size to 100 at startup, put these lines in the server my.cnf file: [mysqld] host_cache_size=200 To change the size to 300 at runtime, do this: SET GLOBAL host_cache_size=300; Setting host_cache_size to 0, either at server ...