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/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. That might be useful, for example, after you have made a runtime configuration change. The tables in this group summarize event data in different ways. Each summary ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-memory-tables.html
Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely updated. Benchmark your application against equivalent InnoDB or MyISAM tables under a realistic workload, to confirm that any additional ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-buffer-stats-by-schema.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production system ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-buffer-stats-by-table.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema and table. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-partitioning.html
For example, to support the separation as shown in Figure 16.2, “Replicating Databases to Separate Replicas”, you should configure each replica as follows, before executing START SLAVE: Replica 1 should use --replicate-wild-do-table=databaseA.%.
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-interface.html
rpl_semi_sync_master_timeout A value in milliseconds that controls how long the source waits on a commit for acknowledgment from a replica before timing out and reverting to asynchronous replication. It is 0 if the plugin is not enabled or the ...
https://dev.mysql.com/doc/refman/5.7/en/option-defaults-equals.html
Options having default values always require an equal sign when assigning a value; failing to do so causes an error. For example, the MySQL server --log-error option has the default value host_name.err, where host_name is the name of the host on ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
It is usually executed only once, when first installing MySQL on a system. mysql_tzinfo_to_sql This program loads the time zone tables in the mysql database using the contents of the host system zoneinfo database (the set of files describing time ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-management.html
Sometimes, I/O is postponed until the database is not busy, or until everything needs to be brought to a consistent state, such as during a database restart after a fast shutdown. As a DBA, you must manage disk I/O to keep the I/O subsystem from ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-global-by-current-bytes.html
These views summarize memory use, grouped by allocation type (that is, by event). By default, rows are sorted by descending amount of memory used. The memory_global_by_current_bytes and x$memory_global_by_current_bytes views have these columns: ...