Autor Subiect: Configurare cache mysql mariadb server  (Citit de 488 ori)

Admin

  • Administrator
  • guru
  • *****
  • Mesaje postate: 54
  • Karma: +0/-0
Configurare cache mysql mariadb server
« : Iunie 30, 2020, 10:50:56 a.m. »
Fisier de modificat /etc/my.cnf

Prima regula este:
innodb_thread_concurrency = 2 * [numberofCPUs] + 2
thread_concurrency = [number of CPUs] * 3

Apoi
innodb_buffer_pool_size = xM
myisam_max_sort_file_size = xM