Status/Laufzeitinfo(2):

[steffi]

Anfang Variable  Wert  Beschreibung
Flush_commands  1  Anzahl der ausgeführten FLUSH-Befehle.
Last_query_cost  0  Die Kosten für die zuletzt verarbeitete Abfrage wie vom Abfrage-Optmierer berechnet. Nützlich um verschiedene Formulierungen für eine Abfrage zu vergleichen. Der Wert 0 besagt das bisher keine Abfrage übersetzt wurde.
Slow_queries  0  Anzahl der Anfragen, die länger als long_query_time benötigten. MySQL - Dokumentation
Anfang InnoDB Variable  Wert  Beschreibung
Variablen InnoDB-Status MySQL - Dokumentation
Innodb_buffer_pool_pages_data  0  The number of pages containing data (dirty or clean).
Innodb_buffer_pool_pages_dirty  0  The number of pages currently dirty.
Innodb_buffer_pool_pages_flushed  0  The number of buffer pool pages that have been requested to be flushed.
Innodb_buffer_pool_pages_free  0  The number of free pages.
Innodb_buffer_pool_pages_latched  0  The number of latched pages in InnoDB buffer pool. These are pages currently being read or written or that can't be flushed or removed for some other reason.
Innodb_buffer_pool_pages_misc  0  The number of pages busy because they have been allocated for administrative overhead such as row locks or the adaptive hash index. This value can also be calculated as Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data.
Innodb_buffer_pool_pages_total  0  Total size of buffer pool, in pages.
Innodb_buffer_pool_read_ahead_rnd  0  The number of "random" read-aheads InnoDB initiated. This happens when a query is to scan a large portion of a table but in random order.
Innodb_buffer_pool_read_ahead_seq  0  The number of sequential read-aheads InnoDB initiated. This happens when InnoDB does a sequential full table scan.
Innodb_buffer_pool_read_requests  0  The number of logical read requests InnoDB has done.
Innodb_buffer_pool_reads  0  The number of logical reads that InnoDB could not satisfy from buffer pool and had to do a single-page read.
Innodb_buffer_pool_wait_free  0  Normally, writes to the InnoDB buffer pool happen in the background. However, if it's necessary to read or create a page and no clean pages are available, it's necessary to wait for pages to be flushed first. This counter counts instances of these waits. If the buffer pool size was set properly, this value should be small.
Innodb_buffer_pool_write_requests  0  The number writes done to the InnoDB buffer pool.
Innodb_data_fsyncs  0  The number of fsync() operations so far.
Innodb_data_pending_fsyncs  0  The current number of pending fsync() operations.
Innodb_data_pending_reads  0  The current number of pending reads.
Innodb_data_pending_writes  0  The current number of pending writes.
Innodb_data_read  0  Wieviel Daten bisher gelesen wurden, in Byte.
Innodb_data_reads  0  Wie oft Daten gelesen wurden.
Innodb_data_writes  0  Wie oft Daten geschrieben wurden.
Innodb_data_written  0  Wieviel Daten bisher geschrieben wurden, in Byte.