🗃️ BASES / MARIADB

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

🏠 Tres puertas🗃️ Bases📋 Tablas de information_schema
MariaDB/information_schema/ROUTINES
OK
Conexión DB
82
Tablas visibles
information_schema
Nivel actual

🧬 Columnas: information_schema / ROUTINES

31
CampoTipoNullKeyDefaultExtra
SPECIFIC_NAMEvarchar(64)NO
ROUTINE_CATALOGvarchar(512)NO
ROUTINE_SCHEMAvarchar(64)NO
ROUTINE_NAMEvarchar(64)NO
ROUTINE_TYPEvarchar(13)NO
DATA_TYPEvarchar(64)NO
CHARACTER_MAXIMUM_LENGTHint(21)YES
CHARACTER_OCTET_LENGTHint(21)YES
NUMERIC_PRECISIONint(21)YES
NUMERIC_SCALEint(21)YES
DATETIME_PRECISIONbigint(21) unsignedYES
CHARACTER_SET_NAMEvarchar(64)YES
COLLATION_NAMEvarchar(64)YES
DTD_IDENTIFIERlongtextYES
ROUTINE_BODYvarchar(8)NO
ROUTINE_DEFINITIONlongtextYES
EXTERNAL_NAMEvarchar(64)YES
EXTERNAL_LANGUAGEvarchar(64)YES
PARAMETER_STYLEvarchar(8)NO
IS_DETERMINISTICvarchar(3)NO
SQL_DATA_ACCESSvarchar(64)NO
SQL_PATHvarchar(64)YES
SECURITY_TYPEvarchar(7)NO
CREATEDdatetimeNO
LAST_ALTEREDdatetimeNO
SQL_MODEvarchar(8192)NO
ROUTINE_COMMENTlongtextNO
DEFINERvarchar(384)NO
CHARACTER_SET_CLIENTvarchar(32)NO
COLLATION_CONNECTIONvarchar(64)NO
DATABASE_COLLATIONvarchar(64)NO

🔬 Muestra de datos

20 filas
SPECIFIC_NAMEROUTINE_CATALOGROUTINE_SCHEMAROUTINE_NAMEROUTINE_TYPEDATA_TYPECHARACTER_MAXIMUM_LENGTHCHARACTER_OCTET_LENGTHNUMERIC_PRECISIONNUMERIC_SCALEDATETIME_PRECISIONCHARACTER_SET_NAMECOLLATION_NAMEDTD_IDENTIFIERROUTINE_BODYROUTINE_DEFINITIONEXTERNAL_NAMEEXTERNAL_LANGUAGEPARAMETER_STYLEIS_DETERMINISTICSQL_DATA_ACCESSSQL_PATHSECURITY_TYPECREATEDLAST_ALTEREDSQL_MODEROUTINE_COMMENTDEFINERCHARACTER_SET_CLIENTCOLLATION_CONNECTIONDATABASE_COLLATION
llenar_hasta_un_millondeflista_precios_oracle_pillenar_hasta_un_millonPROCEDURESQLBEGIN DECLARE actuales BIGINT DEFAULT 0; DECLARE faltan BIGINT DEFAULT 0; DECL...SQLNOCONTAINS SQLDEFINER2026-07-04 21:40:582026-07-04 21:40:58STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONprecios_app@localhostutf8mb3utf8mb3_general_ciutf8mb4_unicode_ci
AddGeometryColumndefmysqlAddGeometryColumnPROCEDURESQLbegin set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,'...SQLNOCONTAINS SQLINVOKER2026-07-04 18:34:152026-07-04 18:34:15mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb4_uca1400_ai_ci
DropGeometryColumndefmysqlDropGeometryColumnPROCEDURESQLbegin set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column)...SQLNOCONTAINS SQLINVOKER2026-07-04 18:34:152026-07-04 18:34:15mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb4_uca1400_ai_ci
diagnosticsdefsysdiagnosticsPROCEDURESQLBEGIN DECLARE v_start, v_runtime, v_iter_start, v_sleep DECIMAL(20,2) DEFAULT 0.0; ...SQLNOREADS SQL DATAINVOKER2026-07-04 18:34:242026-07-04 18:34:24 Description Create a report of the current status of the server...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
optimizer_switch_offdefsysoptimizer_switch_offPROCEDURESQLBEGIN call optimizer_switch_choice("off"); ENDSQLNOCONTAINS SQLINVOKER2026-07-04 18:34:242026-07-04 18:34:24return @@optimizer_switch options that are offmariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
optimizer_switch_ondefsysoptimizer_switch_onPROCEDURESQLBEGIN call optimizer_switch_choice("on"); ENDSQLNOCONTAINS SQLINVOKER2026-07-04 18:34:242026-07-04 18:34:24return @@optimizer_switch options that are onmariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
ps_setup_show_disabled_instrumentsdefsysps_setup_show_disabled_instrumentsPROCEDURESQLBEGIN SELECT name AS disabled_instruments, timed FROM performance_schema.setup_i...SQLYESREADS SQL DATAINVOKER2026-07-04 18:34:262026-07-04 18:34:26 Description Shows all currently disabled instruments. ...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
ps_setup_show_enabled_instrumentsdefsysps_setup_show_enabled_instrumentsPROCEDURESQLBEGIN SELECT name AS enabled_instruments, timed FROM performance_schema.setup_in...SQLYESREADS SQL DATAINVOKER2026-07-04 18:34:262026-07-04 18:34:26 Description Shows all currently enabled instruments. ...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
create_synonym_dbdefsyscreate_synonym_dbPROCEDURESQLBEGIN DECLARE v_done bool DEFAULT FALSE; DECLARE v_db_name_check VARCHAR(64); ...SQLNOMODIFIES SQL DATAINVOKER2026-07-04 18:34:232026-07-04 18:34:23 Description Takes a source database name and synonym name, and ...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
ps_statement_avg_latency_histogramdefsysps_statement_avg_latency_histogramPROCEDURESQLBEGIN SELECT CONCAT('\n', '\n . = 1 unit', '\n * = 2 units', '\n #...SQLNOREADS SQL DATAINVOKER2026-07-04 18:34:242026-07-04 18:34:24 Description Outputs a textual histogram graph of the average la...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
ps_thread_trx_infodefsysps_thread_trx_infoFUNCTIONlongtext21474836472147483647utf8mb3utf8mb3_general_cilongtextSQLBEGIN DECLARE v_output LONGTEXT DEFAULT '{}'; DECLARE v_msg_text TEXT DEFAULT ''; ...SQLNOREADS SQL DATAINVOKER2026-07-04 18:34:172026-07-04 18:34:17 Description Returns a JSON object with info on the given thread...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
ps_trace_statement_digestdefsysps_trace_statement_digestPROCEDURESQLBEGIN DECLARE v_start_fresh BOOLEAN DEFAULT false; DECLARE v_auto_enable BOOLEAN D...SQLNOMODIFIES SQL DATAINVOKER2026-07-04 18:34:242026-07-04 18:34:24 Description Traces all instrumentation within Performance Schem...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
ps_trace_threaddefsysps_trace_threadPROCEDURESQLBEGIN DECLARE v_done bool DEFAULT FALSE; DECLARE v_start, v_runtime DECIMAL(20,2) ...SQLNOMODIFIES SQL DATAINVOKER2026-07-04 18:34:242026-07-04 18:34:24 Description Dumps all data within Performance Schema for an ins...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
statement_performance_analyzerdefsysstatement_performance_analyzerPROCEDURESQLBEGIN DECLARE v_table_exists, v_tmp_digests_table_exists, v_custom_view_exists ENUM(''...SQLNOCONTAINS SQLINVOKER2026-07-04 18:34:262026-07-04 18:34:26 Description Create a report of the statements running on the se...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
execute_prepared_stmtdefsysexecute_prepared_stmtPROCEDURESQLBEGIN IF (@sys.debug IS NULL) THEN SET @sys.debug = sys.sys_get_config('debug'...SQLNOREADS SQL DATAINVOKER2026-07-04 18:34:232026-07-04 18:34:23 Description Takes the query in the argument and executes it usi...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
extract_schema_from_file_namedefsysextract_schema_from_file_nameFUNCTIONvarchar64192utf8mb3utf8mb3_general_civarchar(64)SQLBEGIN RETURN LEFT(SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(path, '\', '/'), '/', -2), '...SQLYESNO SQLINVOKER2026-07-04 18:34:152026-07-04 18:34:15 Description Takes a raw file path, and attempts to extract the ...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
extract_table_from_file_namedefsysextract_table_from_file_nameFUNCTIONvarchar64192utf8mb3utf8mb3_general_civarchar(64)SQLBEGIN RETURN LEFT(SUBSTRING_INDEX(REPLACE(SUBSTRING_INDEX(REPLACE(path, '\', '/'), '/'...SQLYESNO SQLINVOKER2026-07-04 18:34:152026-07-04 18:34:15 Description Takes a raw file path, and extracts the table name ...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
format_bytesdefsysformat_bytesFUNCTIONtext6553565535utf8mb3utf8mb3_general_citextSQLBEGIN IF bytes IS NULL THEN RETURN NULL; ELSEIF bytes >= 1125899906842624 THEN RETURN ...SQLYESNO SQLINVOKER2026-07-04 18:34:152026-07-04 18:34:15 Description Takes a raw bytes value, and converts it to a human...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
format_pathdefsysformat_pathFUNCTIONvarchar5121536utf8mb3utf8mb3_general_civarchar(512)SQLBEGIN DECLARE v_dir VARCHAR(1024); DECLARE v_path VARCHAR(512); DECLARE path_separat...SQLYESNO SQLINVOKER2026-07-04 18:34:162026-07-04 18:34:16 Description Takes a raw path value, and strips out the datadir ...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci
format_statementdefsysformat_statementFUNCTIONlongtext21474836472147483647utf8mb3utf8mb3_general_cilongtextSQLBEGIN IF @sys.statement_truncate_len IS NULL THEN SET @sys.statement_truncate_len ...SQLYESNO SQLINVOKER2026-07-04 18:34:162026-07-04 18:34:16 Description Formats a normalized statement, truncating it if it...mariadb.sys@localhostutf8mb3utf8mb3_general_ciutf8mb3_general_ci