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!

Null Mysql Daemon Innodb Process

Discussion in 'Database Discussion' started by Mayc, Feb 7, 2018.

  1. Mayc

    Mayc Member

    Joined:
    Oct 11, 2017
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Spain
    cPanel Access Level:
    Root Administrator
    mysql and I suspect it is related to these processes. I put a ticket in support and they tell me it's not a cpanel problem. Does anyone have any idea what it might be or how to eliminate them?
    normally on other servers looks like this
    1.jpg

    but on this machine it looks like this and they have the same configuration in everything.
    2.jpg

    Thanks
    Note to moderator: please remove my old post about this.thanks
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,834
    Likes Received:
    85
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi,

    What you see is the InnoDB settings on the server, which is a custom setting not a regular MySQL setting provided by cPanel by default.. Can you share the output of the below command:
    # cat my.cnf
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Mayc

    Mayc Member

    Joined:
    Oct 11, 2017
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Spain
    cPanel Access Level:
    Root Administrator
    thanks

    Code:
    [client]
    port                            = 3306
    socket                          = /var/lib/mysql/mysql.sock
    
    [mysqld-safe]
    socket                          = /var/lib/mysql/mysql.sock
    nice                            = 0
    
    [mysqld]
    # Basic
    basedir                         = /usr
    bind-address                    = 127.0.0.1 # Comment out if you want remote servers to connect to this server's MySQL instance
    datadir                         = /var/lib/mysql
    lc-messages-dir                 = /usr/share/mysql
    max-allowed-packet              = 128M
    max-connect-errors              = 1000000
    pid-file                        = /var/lib/mysql/mysql.pid
    port                            = 3306
    skip-external-locking
    skip-name-resolve
    socket                          = /var/lib/mysql/mysql.sock
    tmpdir                          = /tmp
    user                            = mysql
    
    # InnoDB Settings
    default-storage-engine          = InnoDB
    innodb-buffer-pool-instances    = 8     # Use 1 instance per 1GB of InnoDB pool size
    innodb-buffer-pool-size         = 100G    # Use up to 70-80% of RAM & optionally check if /proc/sys/vm/swappiness is set to 0
    innodb-file-per-table           = 1
    innodb-flush-log-at-trx-commit  = 0
    innodb-flush-method             = O_DIRECT
    innodb-log-buffer-size          = 16M
    innodb-log-file-size            = 128M
    #innodb-thread-concurrency      = 6     # Optional: Set to the number of CPUs on your system (minus 1 or 2) to better contain CPU usage
                                            # E.g. if your system has 8 CPUs, try 6 or 7 and check the overall load from MySQL.
    
    # MyISAM Query Cache Settings
    query-cache-limit               = 4M    # UPD
    query-cache-size                = 48M   # UPD
    query-cache-type                = 1
    
    key-buffer-size                 = 48M   # UPD
    
    low-priority-updates            = 1
    concurrent-insert               = 2
    
    # Common
    max-connections                 = 100   # UPD
    back-log                        = 512
    
    wait-timeout                    = 90
    interactive-timeout             = 90
    
    join-buffer-size                = 2M    # UPD
    read-buffer-size                = 2M    # UPD
    read-rnd-buffer-size            = 4M    # UPD
    sort-buffer-size                = 4M    # UPD
    
    thread-cache-size               = 100   # UPD (most of the times you probably won't need to change this)
    thread-stack                    = 192K
    
    max-heap-table-size             = 128M
    tmp-table-size                  = 128M
    
    table-definition-cache          = 8000  # UPD
    table-open-cache                = 8000  # UPD
    open-files-limit                = 24000 # UPD
    
    ft-min-word-len                 = 3     # Minimum length of words to be indexed for search results
    
    expire-logs-days                = 7
    log-error                       = /var/lib/mysql/mysql_error.log
    log-queries-not-using-indexes   = 1
    long-query-time                 = 8
    max-binlog-size                 = 100M
    slow-query-log                  = 1
    slow-query-log-file             = /var/lib/mysql/mysql_slow.log
    
    [mysqldump]
    quick
    quote-names
    max-allowed-packet              = 16M
    
    [mysql]
    
    [isamchk]
    key-buffer-size                 = 16M
     
  4. cPWilliamL

    cPWilliamL cP Technical Analyst II
    Staff Member

    Joined:
    May 15, 2017
    Messages:
    257
    Likes Received:
    29
    Trophy Points:
    103
    Location:
    America
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Mayc

    Mayc Member

    Joined:
    Oct 11, 2017
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Spain
    cPanel Access Level:
    Root Administrator
    i
    n both versions is the same version mariadb 10.2.8
    thanks
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,378
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello @Mayc,

    I believe the processes you noted are normal with MariaDB 10.2. Are you experiencing any actual problems, or were you simply concerned about the name of the processes?

    Thank you.
     
    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