Increasing the InnoDB buffer pool

djsami

• January 24, 2017 12:34

Hello Optimize InnoDB - WoltLab" innodb_buffer_pool_size 24 gb ? 44779 my.cnf [mysqld] default-storage_engine=InnoDB innodb_file_per_table=1 performance-schema=0 innodb_buffer_pool_size=24G max_allowed_packet=2G innodb_flush_log_at_trx_commit=2 open_files_limit=10000

• 

  NOC_Serverpoint

  • January 25, 2017 01:40

  Hi, Check the innodb_buffer size. mysql> show variables like 'innodb_buffer%'; Increase in /et/my.cnf # innodb innodb_buffer_pool_size = 128M innodb_log_file_size = 32M Thanks,

  0
• 

  cPanelMichael

  • January 25, 2017 19:15

  Hello, You may also find this utility helpful if you are attempting to tune your MySQL configuration: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0

Please sign in to leave a comment.