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/mysqldump.html
With --force, mysqldump prints the error message, but it also writes an SQL comment containing the view definition to the dump output and continues executing. The option value is a list of comma-separated error numbers specifying the errors to ...It ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
The maximum expire time is defined as INT_MAX32 or 2147483647 seconds (approximately 68 years). You cannot make a covering index for memcached lookups; InnoDB returns an error if you try to define a composite secondary index over both the key and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was made. After restoring the base backup, do a point-in-time recovery from the binary log files using mysqlbinlog ...Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-flushing.html
However, if the number of page cleaner threads exceeds the number of buffer pool instances, innodb_page_cleaners is automatically set to the same value as innodb_buffer_pool_instances. When table data is stored on a traditional HDD storage device, ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 25.4.1, “Performance Schema Event Timing”. The job of the Performance Schema instrumentation is to provide row count and accumulated ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
Check whether there are any timed messages to be executed; if so, put these into the job buffer as well. Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction coordinator (TC) ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-tablespaces.html
Start with a relatively low value and increase it incrementally over time to examine the effect on performance. The default setting for innodb_rollback_segments is 128, which is also the maximum value. For example: mysql> SET GLOBAL ... Undo ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-perror.html
ndb_perror shows information about an NDB error, given its error code. This includes the error message, the type of error, and whether the error is permanent or temporary. Added to the MySQL NDB Cluster distribution in NDB 7.6, it is intended as a ...--version, -V Command-Line Format --version Introduced 5.7.19-ndb-7.6.4 Print program version information and ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
With the mysql client, to use a character set different from the default, you could explicitly execute a SET NAMES statement every time you connect to the server (see Client Program Connection Character Set Configuration). Connect-Time Error ...The ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-starting.html
NoOfFragmentLogFiles=300 DataDir=path/to/data/node/data/directory MaxNoOfConcurrentOperations=100000 SchedulerSpinTimer=400 SchedulerExecutionTimer=100 RealTimeScheduler=1 # Setting these parameters allows you to take advantage of real-time ...They ...Changes in configuration are also likely to be indicated when changes are made in the platform on which the cluster is run, or in applications that use the NDB Cluster 's ...