🗃️ 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	mysql	user	select `mysql`.`global_priv`.`Host` AS `Host`,`mysql`.`global_priv`.`User` AS `User`,if(js...	NONE	YES	mariadb.sys@localhost	DEFINER	utf8mb4	utf8mb4_general_ci	UNDEFINED
def	sys	schema_unused_indexes	select `performance_schema`.`table_io_waits_summary_by_index_usage`.`OBJECT_SCHEMA` AS `ob...	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	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	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$io_global_by_file_by_latency	select `performance_schema`.`file_summary_by_instance`.`FILE_NAME` AS `file`,`performance_...	NONE	YES	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE
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	x$host_summary_by_file_io	select if(`performance_schema`.`events_waits_summary_by_host_by_event_name`.`HOST` is null...	NONE	NO	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	TEMPTABLE
def	sys	io_global_by_file_by_bytes	select `sys`.`format_path`(`performance_schema`.`file_summary_by_instance`.`FILE_NAME`) AS...	NONE		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	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	version	select '1.5.1' AS `sys_version`,version() AS `mysql_version`	NONE	NO	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	UNDEFINED
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	waits_global_by_latency	select `performance_schema`.`events_waits_summary_global_by_event_name`.`EVENT_NAME` AS `e...	NONE		mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE
def	sys	statements_with_errors_or_warnings	select `sys`.`format_statement`(`performance_schema`.`events_statements_summary_by_digest`...	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$wait_classes_global_by_avg_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$statements_with_runtimes_in_95th_percentile	select `stmts`.`DIGEST_TEXT` AS `query`,`stmts`.`SCHEMA_NAME` AS `db`,if(`stmts`.`SUM_NO_G...	NONE	YES	mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE
def	sys	schema_index_statistics	select `performance_schema`.`table_io_waits_summary_by_index_usage`.`OBJECT_SCHEMA` AS `ta...	NONE		mariadb.sys@localhost	INVOKER	utf8mb3	utf8mb3_general_ci	MERGE
def	sys	x$user_summary_by_file_io_type	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