Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Increasing the InnoDB buffer pool

Discussion in 'Workarounds and Optimization' started by djsami, Jan 24, 2017.

Tags:
  1. djsami

    djsami Member

    Joined:
    May 2, 2010
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    Hello

    Optimize InnoDB - WoltLab®

    innodb_buffer_pool_size 24 gb ?

    2017-01-24_2134.png


    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
     
  2. NOC_Serverpoint

    NOC_Serverpoint Well-Known Member

    Joined:
    Jul 3, 2016
    Messages:
    102
    Likes Received:
    6
    Trophy Points:
    18
    cPanel Access Level:
    Website Owner
    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,
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice