{"id":1387,"date":"2012-05-24T14:47:15","date_gmt":"2012-05-24T12:47:15","guid":{"rendered":"http:\/\/diablo.craem.net\/wordpress\/?p=491"},"modified":"2012-05-24T14:47:15","modified_gmt":"2012-05-24T12:47:15","slug":"mysql-tunning-zarafa-2","status":"publish","type":"post","link":"https:\/\/diablo.craem.net\/?p=1387","title":{"rendered":"Mysql tunning &#038; Zarafa"},"content":{"rendered":"<p>\t\t\t\t<![CDATA[Estos d\u00edas, me ha tocado migrar otro exchange a zarafa. Ha ido todo bien, pero a medida que iba incluyendo buzones y la BBDD se iba haciendo grande (> 15 Gb), el rendimiento ca\u00eda en picado&#8230;.. al seleccionar emails, tardaba una eternidad y era preocupante.\nEl servidor, un ML 110 G5, con 5 Gb de ram y un xeon, dedicado solo a correo, deber\u00eda de ir bien&#8230; buscando un poco de info por el amigo google, me dedido a tunear el mysql.\nPrimero de todo, paramos los servicios:\n<code>\n# \/etc\/init.d\/zarafa-server stop\n# \/etc\/init.d\/mysql stop\n<\/code>\nUna vez parados los servicios, vamos al fichero de configuraci\u00f3n \/etc\/mysql\/my.cnf . debajo de la secci\u00f3n [mysqld], insertamos:\n<code>\ninnodb_buffer_pool_size = 2048M\ninnodb_log_file_size = 512M\ninnodb_log_buffer_size = 32M\nmax_allowed_packet = 16M\nmax_connections = 500\ninnodb_file_per_table\n<\/code>\n<a href=\"https:\/\/www.zarafa.com\/wiki\/index.php\/MySQL_tuning\" title=\"Zarafa Wiki\">Vamos por partes y leyendo la wiki de zarafa:<\/a>\n<strong>innodb_buffer_pool_size<\/strong>: Recomiendan que el tama\u00f1o sea el 50% de la ram que tengas, en mi caso 4096 Mb. Esto reduce los accesos a disco para <em>cachearlo<\/em> en ram.\n<strong>innodb_log_file_size<\/strong>: es el tama\u00f1o de los ficheros de logs. Recomiendan que sea el 25% del tama\u00f1o anterior aprox, pero podemos jugar con los valores y medir el rendimiento.\n<strong>innodb_log_buffer_size = 32M\nmax_allowed_packet = 16M\nmax_connections = 500<\/strong>\nLos otros tres, recomiendan dejarlo tal cual.\nMovemos los ficheros de logs:\n<code>\n#mv \/var\/lib\/mysql\/ib_logfile0 \/var\/lib\/mysql\/ib_logfile0.bak\n#mv \/var\/lib\/mysql\/ib_logfile1 \/var\/lib\/mysql\/ib_logfile1.bak\n<\/code>\nY reiniciamos los servicios:\n<code>\n# \/etc\/init.d\/mysql start\n# \/etc\/init.d\/zarafa-server start\n<\/code>\nand enjoy your server \ud83d\ude42\n]]>\t\t<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\t\t\t\t<![CDATA[]]>\t\t<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[58,102,115,116,201],"class_list":["post-1387","post","type-post","status-publish","format-standard","hentry","category-linux","tag-debian","tag-linux-2","tag-mysql","tag-mysql-tunning","tag-zarafa"],"_links":{"self":[{"href":"https:\/\/diablo.craem.net\/index.php?rest_route=\/wp\/v2\/posts\/1387","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/diablo.craem.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/diablo.craem.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/diablo.craem.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/diablo.craem.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1387"}],"version-history":[{"count":0,"href":"https:\/\/diablo.craem.net\/index.php?rest_route=\/wp\/v2\/posts\/1387\/revisions"}],"wp:attachment":[{"href":"https:\/\/diablo.craem.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/diablo.craem.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/diablo.craem.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}