🗃️ BASES / MARIADB

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

Conexión DB

Tablas visibles

information_schema

Nivel actual

🧬 Columnas: information_schema / VIEWS

Campo	Tipo	Null
TABLE_CATALOG	varchar(512)	NO
TABLE_SCHEMA	varchar(64)	NO
TABLE_NAME	varchar(64)	NO
VIEW_DEFINITION	longtext	NO
CHECK_OPTION	varchar(8)	NO
IS_UPDATABLE	varchar(3)	NO
DEFINER	varchar(384)	NO
SECURITY_TYPE	varchar(7)	NO
CHARACTER_SET_CLIENT	varchar(32)	NO
COLLATION_CONNECTION	varchar(64)	NO
ALGORITHM	varchar(10)	NO

🔬 Muestra de datos

20 filas

TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	VIEW_DEFINITION	CHECK_OPTION	IS_UPDATABLE	DEFINER	SECURITY_TYPE	CHARACTER_SET_CLIENT	COLLATION_CONNECTION	ALGORITHM
def	sys	x$processlist	select `pps`.`THREAD_ID` AS `thd_id`,`pps`.`PROCESSLIST_ID` AS `conn_id`,if(`pps`.`NAME` =...	NONE	NO	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	TEMPTABLE
def	sys	statements_with_runtimes_in_95th_percentile	select `sys`.`format_statement`(`stmts`.`DIGEST_TEXT`) AS `query`,`stmts`.`SCHEMA_NAME` AS...	NONE		mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE
def	sys	x$wait_classes_global_by_latency	select substring_index(`performance_schema`.`events_waits_summary_global_by_event_name`.`E...	NONE	NO	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	TEMPTABLE
def	sys	x$ps_digest_avg_latency_distribution	select count(0) AS `cnt`,round(`performance_schema`.`events_statements_summary_by_digest`....	NONE	NO	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	TEMPTABLE
def	sys	version	select '1.5.2' AS `sys_version`,version() AS `mysql_version`	NONE	NO	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	UNDEFINED
def	sys	ps_check_lost_instrumentation	select `performance_schema`.`global_status`.`VARIABLE_NAME` AS `variable_name`,`performanc...	NONE	YES	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE
def	sys	x$ps_digest_95th_percentile_by_avg_us	select `s2`.`avg_us` AS `avg_us`,ifnull(sum(`s1`.`cnt`) / nullif((select count(0) from `pe...	NONE	NO	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	TEMPTABLE
def	sys	x$memory_global_total	select sum(`performance_schema`.`memory_summary_global_by_event_name`.`CURRENT_NUMBER_OF_B...	NONE	NO	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	TEMPTABLE
def	sys	x$waits_by_host_by_latency	select if(`performance_schema`.`events_waits_summary_by_host_by_event_name`.`HOST` is null...	NONE	YES	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE
def	sys	innodb_buffer_stats_by_schema	select if(locate('.',`ibp`.`TABLE_NAME`) = 0,'InnoDB System',replace(substring_index(`ibp`...	NONE		mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	TEMPTABLE
def	sys	innodb_lock_waits	select `r`.`trx_wait_started` AS `wait_started`,timediff(current_timestamp(),`r`.`trx_wait...	NONE		mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	TEMPTABLE
def	sys	waits_by_user_by_latency	select if(`performance_schema`.`events_waits_summary_by_user_by_event_name`.`USER` is null...	NONE	YES	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE
def	sys	session_ssl_status	select `sslver`.`THREAD_ID` AS `thread_id`,`sslver`.`VARIABLE_VALUE` AS `ssl_version`,`ssl...	NONE	YES	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE
def	sys	memory_global_total	select `sys`.`format_bytes`(sum(`performance_schema`.`memory_summary_global_by_event_name`...	NONE		mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	TEMPTABLE
def	sys	schema_redundant_indexes	select `redundant_keys`.`table_schema` AS `table_schema`,`redundant_keys`.`table_name` AS ...	NONE	NO	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	TEMPTABLE
def	sys	session	select `processlist`.`thd_id` AS `thd_id`,`processlist`.`conn_id` AS `conn_id`,`processlis...	NONE		mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	UNDEFINED
def	sys	memory_by_host_by_current_bytes	select if(`performance_schema`.`memory_summary_by_host_by_event_name`.`HOST` is null,'back...	NONE		mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	TEMPTABLE
def	sys	user_summary_by_stages	select if(`performance_schema`.`events_stages_summary_by_user_by_event_name`.`USER` is nul...	NONE	YES	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE
def	sys	statements_with_temp_tables	select `sys`.`format_statement`(`performance_schema`.`events_statements_summary_by_digest`...	NONE		mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE
def	sys	x$statements_with_sorting	select `performance_schema`.`events_statements_summary_by_digest`.`DIGEST_TEXT` AS `query`...	NONE	YES	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE