{"id":491,"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","status":"publish","type":"post","link":"https:\/\/diablo.craem.net\/?p=491","title":{"rendered":"Mysql tunning &amp; Zarafa"},"content":{"rendered":"<p>Estos d\u00ed\u00adas, 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\u00ed\u00ada en picado&#8230;.. al seleccionar emails, tardaba una eternidad y era preocupante.<br \/>\nEl servidor, un ML 110 G5, con 5 Gb de ram y un xeon, dedicado solo a correo, deber\u00ed\u00ada de ir bien&#8230; buscando un poco de info por el amigo google, me dedido a tunear el mysql.<br \/>\nPrimero de todo, paramos los servicios:<br \/>\n<code><br \/>\n# \/etc\/init.d\/zarafa-server stop<br \/>\n# \/etc\/init.d\/mysql stop<br \/>\n<\/code><br \/>\nUna vez parados los servicios, vamos al fichero de configuraci\u00f3n \/etc\/mysql\/my.cnf . debajo de la secci\u00f3n [mysqld], insertamos:<br \/>\n<code><br \/>\ninnodb_buffer_pool_size = 2048M<br \/>\ninnodb_log_file_size = 512M<br \/>\ninnodb_log_buffer_size = 32M<br \/>\nmax_allowed_packet = 16M<br \/>\nmax_connections = 500<br \/>\ninnodb_file_per_table<br \/>\n<\/code><br \/>\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><br \/>\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.<br \/>\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.<br \/>\n<strong>innodb_log_buffer_size = 32M<br \/>\nmax_allowed_packet = 16M<br \/>\nmax_connections = 500<\/strong><br \/>\nLos otros tres, recomiendan dejarlo tal cual.<br \/>\nMovemos los ficheros de logs:<br \/>\n<code><br \/>\n#mv \/var\/lib\/mysql\/ib_logfile0 \/var\/lib\/mysql\/ib_logfile0.bak<br \/>\n#mv \/var\/lib\/mysql\/ib_logfile1 \/var\/lib\/mysql\/ib_logfile1.bak<br \/>\n<\/code><br \/>\nY reiniciamos los servicios:<br \/>\n<code><br \/>\n# \/etc\/init.d\/mysql start<br \/>\n# \/etc\/init.d\/zarafa-server start<br \/>\n<\/code><br \/>\nand enjoy your server \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Estos d\u00ed\u00adas, 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\u00ed\u00ada en picado&#8230;.. al seleccionar emails, tardaba una eternidad y era preocupante. El servidor, un ML 110 G5, con 5 Gb de [&hellip;]<\/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-491","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\/491","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=491"}],"version-history":[{"count":0,"href":"https:\/\/diablo.craem.net\/index.php?rest_route=\/wp\/v2\/posts\/491\/revisions"}],"wp:attachment":[{"href":"https:\/\/diablo.craem.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/diablo.craem.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/diablo.craem.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}