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-file-instances-table.html
When a file is deleted from the disk, it is also removed from the file_instances table. The file_instances table lists all the files seen by the Performance Schema when executing file I/O instrumentation. If a file on disk has never been opened, it ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-file-summary-tables.html
COUNT_MISC, SUM_TIMER_MISC, MIN_TIMER_MISC, AVG_TIMER_MISC, MAX_TIMER_MISC These columns aggregate all other I/O operations, including CREATE, DELETE, OPEN, CLOSE, STREAM_OPEN, STREAM_CLOSE, SEEK, TELL, FLUSH, STAT, FSTAT, CHSIZE, RENAME, and SYNC.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-instances-table.html
When a connection terminates, the row in socket_instances corresponding to it is deleted. The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. The table contains one row per TCP/IP or Unix socket ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-summary-tables.html
When a connection terminates, the row in socket_summary_by_instance corresponding to it is deleted. These socket summary tables aggregate timer and byte count information for socket operations: socket_summary_by_event_name: Aggregate timer and byte ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Some of the setup tables have columns that can be modified to affect Performance Schema operation; some also permit rows to be inserted or deleted. The name of the performance_schema database is lowercase, as are the names of tables within it. Many ...
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
For this reason, UNINSTALL PLUGIN statement requires the DELETE privilege for the mysql.plugin table. Server plugins must be loaded into the server before they can be used. It is also possible to control the activation state of loaded plugins at ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
If you modify the grant tables directly using statements such as INSERT, UPDATE, or DELETE (which is not recommended), the changes have no effect on privilege checking until you either tell the server to reload the tables or restart it. If the ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-configuration.html
Fragmentation can force the query cache to prune (delete) queries from the cache due to lack of memory. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. The have_query_cache server system variable indicates ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
A table can be changed by many types of statements, such as INSERT, UPDATE, DELETE, TRUNCATE TABLE, ALTER TABLE, DROP TABLE, or DROP DATABASE. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section ...