🗃️ BASES / MARIADB

Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.

OK
Conexión DB
82
Tablas visibles
information_schema
Nivel actual

🧬 Columnas: information_schema / INNODB_METRICS

17
CampoTipoNullKeyDefaultExtra
NAMEvarchar(193)NO
SUBSYSTEMvarchar(193)NO
COUNTbigint(21)NO
MAX_COUNTbigint(21)YES
MIN_COUNTbigint(21)YES
AVG_COUNTfloatYES
COUNT_RESETbigint(21)NO
MAX_COUNT_RESETbigint(21)YES
MIN_COUNT_RESETbigint(21)YES
AVG_COUNT_RESETfloatYES
TIME_ENABLEDdatetimeYES
TIME_DISABLEDdatetimeYES
TIME_ELAPSEDbigint(21)YES
TIME_RESETdatetimeYES
ENABLEDint(1)NO
TYPEenum('value','status_counter','set_owner','set_member','counter')NO
COMMENTvarchar(193)NO

🔬 Muestra de datos

20 filas
NAMESUBSYSTEMCOUNTMAX_COUNTMIN_COUNTAVG_COUNTCOUNT_RESETMAX_COUNT_RESETMIN_COUNT_RESETAVG_COUNT_RESETTIME_ENABLEDTIME_DISABLEDTIME_ELAPSEDTIME_RESETENABLEDTYPECOMMENT
metadata_table_handles_openedmetadata000counterNumber of table handles opened
lock_deadlockslock0000002026-07-11 14:18:45429581valueNumber of deadlocks
lock_timeoutslock0000002026-07-11 14:18:45429581valueNumber of lock timeouts
lock_rec_lock_waitslock000counterNumber of times enqueued into record lock wait queue
lock_table_lock_waitslock000counterNumber of times enqueued into table lock wait queue
lock_rec_lock_requestslock000counterNumber of record locks requested
lock_rec_lock_createdlock000counterNumber of record locks created
lock_rec_lock_removedlock000counterNumber of record locks removed from the lock queue
lock_rec_lockslock000counterCurrent number of record locks on tables
lock_table_lock_createdlock000counterNumber of table locks created
lock_table_lock_removedlock000counterNumber of table locks removed from the lock queue
lock_table_lockslock000counterCurrent number of table locks on tables
lock_row_lock_current_waitslock0000002026-07-11 14:18:45429581valueNumber of row locks currently being waited for (innodb_row_lock_current_waits)
lock_row_lock_timelock000002026-07-11 14:18:45429581status_counterTime spent in acquiring row locks, in milliseconds (innodb_row_lock_time)
lock_row_lock_time_maxlock0000002026-07-11 14:18:45429581valueThe maximum time to acquire a row lock, in milliseconds (innodb_row_lock_time_max)
lock_row_lock_waitslock000002026-07-11 14:18:45429581status_counterNumber of times a row lock had to be waited for (innodb_row_lock_waits)
lock_row_lock_time_avglock0000002026-07-11 14:18:45429581valueThe average time to acquire a row lock, in milliseconds (innodb_row_lock_time_avg)
buffer_pool_sizeserver8112811281128112811281122026-07-11 14:18:45429581valueServer buffer pool size (all buffer pools) in bytes
buffer_pool_readsbuffer17142171420.39904117142171422026-07-11 14:18:45429581status_counterNumber of reads directly from disk (innodb_buffer_pool_reads)
buffer_pool_read_requestsbuffer14446144460.33628214446144462026-07-11 14:18:45429581status_counterNumber of logical read requests (innodb_buffer_pool_read_requests)