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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page