PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-configurator-workflow-server.html
This includes defining custom file paths for the error log, general log, slow query log (including the configuration of seconds it requires to execute a query), and the binary log. The Logging Options step enables you to define custom file paths for ... MySQL Configurator performs the initial configuration, a reconfiguration, and also functions as part of the uninstallation ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-tzinfo-to-sql.html
The second syntax causes mysql_tzinfo_to_sql to load a single time zone file tz_file that corresponds to a time zone name tz_name: mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql If your time zone needs to account for leap seconds, invoke ... The mysql_tzinfo_to_sql program loads the time zone tables in the mysql ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog.html
The second line starts with a date and time indicating when the statement started on the server where the event originated. When the second mysql process attempts to use the table, the server reports “unknown table.” To avoid problems like this, ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/9.7/en/mysqld-safe.html
mysqld_safe tries to use the sleep and date system utilities to determine how many times per second it has attempted to start. If these utilities are present and the attempted starts per second is greater than 5, mysqld_safe waits 1 full second ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldm-options.html
mysqldm accepts MySQL standard connection options and several mysqldm-specific options. --iterations=numberOfIterations Command-Line Format --iterations=# Type Integer Default Value 10 The number of diagnostic iterations. A temporary directory ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldump-sql-format.html
However, if you replay a second dump file on the target server that contains the same GTIDs (for example, another partial dump from the same source server), any SET @@GLOBAL.gtid_purged statement in the second dump file fails. To avoid this issue, ... This section describes how to use mysqldump to create SQL-format dump ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-transaction-management.html
For example, an application might encounter performance issues if it commits thousands of times per second, and different performance issues if it commits only every 2-3 hours. When each change is followed by a commit (as with the default autocommit ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-processlist-table.html
See Section 7.1.10, “Server Status Variables” TIME The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-statement-digests.html
In this case, the difference in the second column name is lost and both statements are considered the same. Resampling based on age: If the performance_schema_max_digest_sample_age system variable has a value greater than zero and the current sample ... The MySQL server is capable of maintaining statement digest ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-threads-table.html
PROCESSLIST_TIME The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. If a thread ...