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.

Optimizing my.cnf question

Discussion in 'Workarounds and Optimization' started by zir4k, Jun 19, 2017.

Tags:
  1. zir4k

    zir4k Registered

    Joined:
    Jun 19, 2017
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mashhad
    cPanel Access Level:
    Root Administrator
    Hi, i have a virtual server with this informations:
    Code:
    Processor Information
    Total processors: 4
    
    Processor #1
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz
    
        Speed
            2098.983 MHz
    
        Cache
            20480 KB
    
    Processor #2
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz
    
        Speed
            2098.983 MHz
    
        Cache
            20480 KB
    
    Processor #3
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz
    
        Speed
            2098.983 MHz
    
        Cache
            20480 KB
    
    Processor #4
    
        Vendor
            GenuineIntel
    
        Name
            Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz
    
        Speed
            2098.983 MHz
    
        Cache
            20480 KB
    And This Memory Usage
    Code:
    Current Memory Usage
    
                  total        used        free      shared  buff/cache   available
    Mem:        4914228     2197908      206216      762836     2510104     1638356
    Swap:       5017596        7980     5009616
    Total:      9931824     2205888     5215832
    
    i use from mariadb and have 4 Core CPU And 4GB Memory,Most of the times my avaible memory is to low and i have crash and should be restart my server.
    There Is MY.CNF
    Code:
    [mysqld]
    innodb_file_per_table=1
    default-storage-engine=MyISAM
    performance-schema=0
    innodb_buffer_pool_size=90177536
    max_allowed_packet=268435456
    open_files_limit=10000
    
    i want a best config for this information and help to optimize my server. thanks
    for check my sites speed goto this url - Removed -
     
    #1 zir4k, Jun 19, 2017
    Last edited by a moderator: Jun 19, 2017
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,659
    Likes Received:
    1,428
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
  3. zir4k

    zir4k Registered

    Joined:
    Jun 19, 2017
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mashhad
    cPanel Access Level:
    Root Administrator
    thanks , but i cant find my answer , i just want configuration for my details .
    my.cnf and best value for mysql configs
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,659
    Likes Received:
    1,428
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Advice about tuning specific configuration values typically requires the help of a qualified system administrator. I'll leave this thread open for additional user-feedback, but I did want to note the "mysqladmin processlist" command is helpful if you are noticing bad MySQL performance. The command can help determine if any specific databases are responsible for the poor performance.

    You can also find a list of companies offering system administration services if you do not receive sufficient user-feedback to this thread:

    System Administration Services | cPanel Forums

    Thank you.
     
Loading...

Share This Page