{"id":1019,"date":"2026-09-24T19:34:24","date_gmt":"2026-09-24T19:34:24","guid":{"rendered":"https:\/\/azamedia.com\/kb\/docs\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\/"},"modified":"2026-09-24T19:44:25","modified_gmt":"2026-09-24T19:44:25","password":"","slug":"administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk","status":"publish","type":"docs","link":"https:\/\/azamedia.com\/kb\/docs\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\/","title":{"rendered":"Administraci\u00f3n de MySQL\/MariaDB en un servidor Linux con Plesk"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Esta gu\u00eda re\u00fane varias tareas habituales de administraci\u00f3n de MySQL\/MariaDB en un servidor Linux con Plesk.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Los comandos que utilizan <code>\/etc\/psa\/.psa.shadow<\/code> son espec\u00edficos de Plesk y deben ejecutarse con privilegios de administrador. Antes de realizar operaciones de reparaci\u00f3n u optimizaci\u00f3n en producci\u00f3n, es recomendable disponer de una copia de seguridad reciente.<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">En versiones actuales de Plesk tambi\u00e9n puede utilizarse <code>plesk db<\/code> para acceder al cliente de base de datos sin tener que introducir manualmente la contrase\u00f1a administrativa.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Comprobar el estado de MariaDB<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl status mariadb<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">En algunas instalaciones el servicio puede llamarse <code>mysql<\/code> o <code>mysqld<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Reiniciar MariaDB<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl restart mariadb<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Despu\u00e9s del reinicio, compruebe de nuevo el estado:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl status mariadb<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Si el servicio no arranca correctamente, revise los \u00faltimos mensajes del journal:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>journalctl -u mariadb -n 100 --no-pager<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Comprobar y reparar todas las bases de datos<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">En servidores Plesk puede utilizarse la contrase\u00f1a del usuario administrativo almacenada en <code>\/etc\/psa\/.psa.shadow<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqlcheck -u admin -p`cat \/etc\/psa\/.psa.shadow` --check --auto-repair --all-databases<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Este comando comprueba todas las bases de datos e intenta reparar autom\u00e1ticamente las tablas cuando el motor lo permite.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><code>--auto-repair<\/code> no corrige todos los tipos de corrupci\u00f3n posibles, especialmente en tablas InnoDB. Si aparecen errores de corrupci\u00f3n persistentes, no repita reparaciones de forma indiscriminada: revise el error concreto y el estado del servidor antes de continuar.<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">Optimizar todas las bases de datos<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqlcheck -u admin -p`cat \/etc\/psa\/.psa.shadow` --auto-repair --optimize --all-databases<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">La optimizaci\u00f3n puede consumir CPU, disco y generar bloqueos o reconstrucciones de tablas seg\u00fan el motor y su tama\u00f1o. Evite ejecutarla como tarea rutinaria en horario de carga alta.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ver los procesos activos de MySQL\/MariaDB<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqladmin -u admin -p`cat \/etc\/psa\/.psa.shadow` processlist<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Este comando permite revisar conexiones y consultas activas para detectar procesos largos o bloqueados.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Para obtener m\u00e1s detalle desde el cliente SQL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u admin -p`cat \/etc\/psa\/.psa.shadow` -e &quot;SHOW FULL PROCESSLIST;&quot;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Recomendaciones antes de actuar<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Compruebe que dispone de una copia de seguridad reciente.<\/li>\n\n\n\n<li>Si el servidor est\u00e1 bajo carga, revise primero los procesos activos antes de reiniciar MariaDB.<\/li>\n\n\n\n<li>No ejecute optimizaciones masivas sin valorar el tama\u00f1o de las bases de datos y el impacto en producci\u00f3n.<\/li>\n\n\n\n<li>Si aparecen errores de corrupci\u00f3n InnoDB, revise el error espec\u00edfico antes de intentar una reparaci\u00f3n.<\/li>\n\n\n\n<li>Si el servidor est\u00e1 administrado por AZAMedia y tiene dudas sobre el procedimiento, abra un ticket de soporte antes de realizar cambios.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Comandos b\u00e1sicos para comprobar el estado de MariaDB, reiniciar el servicio, revisar procesos y comprobar, reparar u optimizar bases de datos en un servidor Linux con Plesk.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[25],"doc_tag":[],"class_list":["post-1019","docs","type-docs","status-publish","hentry","doc_category-cloud-hosting"],"year_month":"2026-09","word_count":431,"total_views":"2","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"admin","author_nicename":"rellenar_ar9n7pta","author_url":"https:\/\/azamedia.com\/kb\/author\/rellenar_ar9n7pta\/"},"doc_category_info":[{"term_name":"Cloud Hosting","term_url":"https:\/\/azamedia.com\/kb\/docs-category\/cloud-hosting\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Administraci\u00f3n de MySQL\/MariaDB en un servidor Linux con Plesk - Base de conocimientos - AZAMedia<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azamedia.com\/kb\/docs\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\/\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/docs\\\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\\\/\",\"url\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/docs\\\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\\\/\",\"name\":\"Administraci\u00f3n de MySQL\\\/MariaDB en un servidor Linux con Plesk - Base de conocimientos - AZAMedia\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/#website\"},\"datePublished\":\"2026-09-24T19:34:24+00:00\",\"dateModified\":\"2026-09-24T19:44:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/docs\\\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/azamedia.com\\\/kb\\\/docs\\\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/docs\\\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de Conocimientos\",\"item\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/docs\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Administraci\u00f3n de MySQL\\\/MariaDB en un servidor Linux con Plesk\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/\",\"name\":\"Base de conocimientos - AZAMedia\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/#organization\",\"name\":\"Base de conocimientos - AZAMedia\",\"url\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/logo.png\",\"width\":292,\"height\":45,\"caption\":\"Base de conocimientos - AZAMedia\"},\"image\":{\"@id\":\"https:\\\/\\\/azamedia.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Administraci\u00f3n de MySQL\/MariaDB en un servidor Linux con Plesk - Base de conocimientos - AZAMedia","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/azamedia.com\/kb\/docs\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\/","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/azamedia.com\/kb\/docs\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\/","url":"https:\/\/azamedia.com\/kb\/docs\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\/","name":"Administraci\u00f3n de MySQL\/MariaDB en un servidor Linux con Plesk - Base de conocimientos - AZAMedia","isPartOf":{"@id":"https:\/\/azamedia.com\/kb\/#website"},"datePublished":"2026-09-24T19:34:24+00:00","dateModified":"2026-09-24T19:44:25+00:00","breadcrumb":{"@id":"https:\/\/azamedia.com\/kb\/docs\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azamedia.com\/kb\/docs\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/azamedia.com\/kb\/docs\/administracion-de-mysql-mariadb-en-un-servidor-linux-con-plesk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/azamedia.com\/kb\/"},{"@type":"ListItem","position":2,"name":"Base de Conocimientos","item":"https:\/\/azamedia.com\/kb\/docs\/"},{"@type":"ListItem","position":3,"name":"Administraci\u00f3n de MySQL\/MariaDB en un servidor Linux con Plesk"}]},{"@type":"WebSite","@id":"https:\/\/azamedia.com\/kb\/#website","url":"https:\/\/azamedia.com\/kb\/","name":"Base de conocimientos - AZAMedia","description":"","publisher":{"@id":"https:\/\/azamedia.com\/kb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azamedia.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/azamedia.com\/kb\/#organization","name":"Base de conocimientos - AZAMedia","url":"https:\/\/azamedia.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/azamedia.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/azamedia.com\/kb\/wp-content\/uploads\/2024\/07\/logo.png","contentUrl":"https:\/\/azamedia.com\/kb\/wp-content\/uploads\/2024\/07\/logo.png","width":292,"height":45,"caption":"Base de conocimientos - AZAMedia"},"image":{"@id":"https:\/\/azamedia.com\/kb\/#\/schema\/logo\/image\/"}}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/azamedia.com\/kb\/wp-json\/wp\/v2\/docs\/1019","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azamedia.com\/kb\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/azamedia.com\/kb\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/azamedia.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azamedia.com\/kb\/wp-json\/wp\/v2\/comments?post=1019"}],"version-history":[{"count":1,"href":"https:\/\/azamedia.com\/kb\/wp-json\/wp\/v2\/docs\/1019\/revisions"}],"predecessor-version":[{"id":1020,"href":"https:\/\/azamedia.com\/kb\/wp-json\/wp\/v2\/docs\/1019\/revisions\/1020"}],"wp:attachment":[{"href":"https:\/\/azamedia.com\/kb\/wp-json\/wp\/v2\/media?parent=1019"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/azamedia.com\/kb\/wp-json\/wp\/v2\/doc_category?post=1019"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/azamedia.com\/kb\/wp-json\/wp\/v2\/doc_tag?post=1019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}