[Tools]
Datenbank:
`information_schema`
Tabelle: `INNODB_BUFFER_PAGE_LRU`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `information_schema`.`INNODB_BUFFER_PAGE_LRU`
Datensätze 1 - 30 von insgesamt 7148 << < > >>
| Ansicht: kompakt Die Abfrage enthält 20 Spalten | |||||||||||||||||||||
| # |  POOL_ID | LRU_POSITION | SPACE | PAGE_NUMBER | PAGE_TYPE | FLUSH_TYPE | FIX_COUNT | IS_HASHED | NEWEST_MODIFICATION | OLDEST_MODIFICATION | ACCESS_TIME | TABLE_NAME | INDEX_NAME | NUMBER_RECORDS | DATA_SIZE | COMPRESSED_SIZE | COMPRESSED | IO_FIX | IS_OLD | FREE_PAGE_CLOCK | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
  | 1. | 0 | 0 | 3759 | 2780 | INDEX | 0 | 0 | NO | 0 | 0 | 114359840 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15057 | 0 | NO | IO_NONE | YES | 0 |
|
| 2. | 0 | 1 | 3759 | 2781 | INDEX | 0 | 0 | NO | 0 | 0 | 114359840 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15129 | 0 | NO | IO_NONE | YES | 0 |
|
| 3. | 0 | 2 | 3759 | 2782 | INDEX | 0 | 0 | NO | 0 | 0 | 114359841 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15127 | 0 | NO | IO_NONE | YES | 0 |
|
| 4. | 0 | 3 | 3759 | 2783 | INDEX | 0 | 0 | NO | 0 | 0 | 114359841 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15063 | 0 | NO | IO_NONE | YES | 0 |
|
| 5. | 0 | 4 | 3759 | 2784 | INDEX | 0 | 0 | NO | 0 | 0 | 114359842 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15114 | 0 | NO | IO_NONE | YES | 0 |
|
| 6. | 0 | 5 | 3759 | 2785 | INDEX | 0 | 0 | NO | 0 | 0 | 114359842 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15133 | 0 | NO | IO_NONE | YES | 0 |
|
| 7. | 0 | 6 | 3759 | 2786 | INDEX | 0 | 0 | NO | 0 | 0 | 114359842 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15113 | 0 | NO | IO_NONE | YES | 0 |
|
| 8. | 0 | 7 | 3759 | 2787 | INDEX | 0 | 0 | NO | 0 | 0 | 114359843 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15067 | 0 | NO | IO_NONE | YES | 0 |
|
| 9. | 0 | 8 | 3759 | 2788 | INDEX | 0 | 0 | NO | 0 | 0 | 114359843 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15115 | 0 | NO | IO_NONE | YES | 0 |
|
| 10. | 0 | 9 | 3759 | 2789 | INDEX | 0 | 0 | NO | 0 | 0 | 114359844 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15077 | 0 | NO | IO_NONE | YES | 0 |
|
| 11. | 0 | 10 | 3759 | 2790 | INDEX | 0 | 0 | NO | 0 | 0 | 114359844 | `fhem`.`history` | GEN_CLUST_INDEX | 146 | 15086 | 0 | NO | IO_NONE | YES | 0 |
|
| 12. | 0 | 11 | 3759 | 2791 | INDEX | 0 | 0 | NO | 0 | 0 | 114359845 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15055 | 0 | NO | IO_NONE | YES | 0 |
|
| 13. | 0 | 12 | 3759 | 2792 | INDEX | 0 | 0 | NO | 0 | 0 | 114359845 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15134 | 0 | NO | IO_NONE | YES | 0 |
|
| 14. | 0 | 13 | 3759 | 2793 | INDEX | 0 | 0 | NO | 0 | 0 | 114359846 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15146 | 0 | NO | IO_NONE | YES | 0 |
|
| 15. | 0 | 14 | 3759 | 2794 | INDEX | 0 | 0 | NO | 0 | 0 | 114359846 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15059 | 0 | NO | IO_NONE | YES | 0 |
|
| 16. | 0 | 15 | 3759 | 2795 | INDEX | 0 | 0 | NO | 0 | 0 | 114359847 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15130 | 0 | NO | IO_NONE | YES | 0 |
|
| 17. | 0 | 16 | 3759 | 2796 | INDEX | 0 | 0 | NO | 0 | 0 | 114359847 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15119 | 0 | NO | IO_NONE | YES | 0 |
|
| 18. | 0 | 17 | 3759 | 2797 | INDEX | 0 | 0 | NO | 0 | 0 | 114359848 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15063 | 0 | NO | IO_NONE | YES | 0 |
|
| 19. | 0 | 18 | 3759 | 2798 | INDEX | 0 | 0 | NO | 0 | 0 | 114359848 | `fhem`.`history` | GEN_CLUST_INDEX | 170 | 15143 | 0 | NO | IO_NONE | YES | 0 |
|
| 20. | 0 | 19 | 3759 | 3200 | INDEX | 0 | 0 | NO | 0 | 0 | 114359849 | `fhem`.`history` | GEN_CLUST_INDEX | 155 | 15093 | 0 | NO | IO_NONE | YES | 0 |
|
| 21. | 0 | 20 | 3759 | 2799 | INDEX | 0 | 0 | NO | 0 | 0 | 114359849 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15102 | 0 | NO | IO_NONE | YES | 0 |
|
| 22. | 0 | 21 | 3759 | 2800 | INDEX | 0 | 0 | NO | 0 | 0 | 114359850 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15056 | 0 | NO | IO_NONE | YES | 0 |
|
| 23. | 0 | 22 | 3759 | 2801 | INDEX | 0 | 0 | NO | 0 | 0 | 114359850 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15085 | 0 | NO | IO_NONE | YES | 0 |
|
| 24. | 0 | 23 | 3759 | 2802 | INDEX | 0 | 0 | NO | 0 | 0 | 114359851 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15076 | 0 | NO | IO_NONE | YES | 0 |
|
| 25. | 0 | 24 | 3759 | 2803 | INDEX | 0 | 0 | NO | 0 | 0 | 114359851 | `fhem`.`history` | GEN_CLUST_INDEX | 146 | 15114 | 0 | NO | IO_NONE | YES | 0 |
|
| 26. | 0 | 25 | 3759 | 2804 | INDEX | 0 | 0 | NO | 0 | 0 | 114359852 | `fhem`.`history` | GEN_CLUST_INDEX | 148 | 15116 | 0 | NO | IO_NONE | YES | 0 |
|
| 27. | 0 | 26 | 3759 | 2805 | INDEX | 0 | 0 | NO | 0 | 0 | 114359852 | `fhem`.`history` | GEN_CLUST_INDEX | 106 | 15121 | 0 | NO | IO_NONE | YES | 0 |
|
| 28. | 0 | 27 | 3759 | 2806 | INDEX | 0 | 0 | NO | 0 | 0 | 114359853 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15061 | 0 | NO | IO_NONE | YES | 0 |
|
| 29. | 0 | 28 | 3759 | 2807 | INDEX | 0 | 0 | NO | 0 | 0 | 114359853 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15118 | 0 | NO | IO_NONE | YES | 0 |
|
| 30. | 0 | 29 | 3759 | 2808 | INDEX | 0 | 0 | NO | 0 | 0 | 114359854 | `fhem`.`history` | GEN_CLUST_INDEX | 146 | 15133 | 0 | NO | IO_NONE | YES | 0 |
Datensätze 1 - 30 von insgesamt 7148 << < > >>