Mant MySQL Wiki

Mantenimiento a BDs MySQL de las Wiki Locales manejadas con XAMPP Proyecto ED - Escritorio Digital

---

CONSULTAS

Tamaños BD - MySQL o MariaDB

SELECT 
    table_schema AS "Base de Datos",
    ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Tamaño (MB)"
FROM information_schema.tables
GROUP BY table_schema
ORDER BY 
    CASE 
        WHEN table_schema LIKE '%wiki%' THEN 0
        WHEN table_schema LIKE '%fsf%' THEN 0
        WHEN table_schema LIKE '%ed%' THEN 0
        WHEN table_schema LIKE '%w11%' THEN 0
        WHEN table_schema LIKE '%rye%' THEN 0
        WHEN table_schema LIKE '%era%' THEN 0
        WHEN table_schema LIKE '%05era%' THEN 0
        ELSE 1
    END,
    table_schema ASC;

Ejemplo resultado.

---