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.

Problem with my.cnf settings

Discussion in 'Database Discussions' started by joomla, Oct 14, 2014.

  1. joomla

    joomla Well-Known Member

    Joined:
    Jul 23, 2014
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello,

    It seems to me that I omit some settings in my.cnf and I gor warning messages in MySQL error file.

    Here is the output:

    Code:
    141015  4:53:47 [Note] /usr/sbin/mysqld: Normal shutdown
    
    141015  4:53:47 [Note] Event Scheduler: Purging the queue. 0 events
    [B]141015  4:53:49 [Warning] /usr/sbin/mysqld: Forcing close of thread 57  user: 'leechprotect'[/B]
    
    [B]141015  4:53:49 [Warning] /usr/sbin/mysqld: Forcing close of thread 5  user: 'root'[/B]
    
    [B]141015  4:53:49 [Warning] /usr/sbin/mysqld: Forcing close of thread 3  user: 'eximstats'[/B]
    141015  4:53:49  InnoDB: Starting shutdown...
    141015  4:53:50  InnoDB: Shutdown completed; log sequence number 345988635
    141015  4:53:50 [Note] /usr/sbin/mysqld: Shutdown complete
    
    141015 04:53:50 mysqld_safe mysqld from pid file /var/lib/mysql/my.server.com.pid ended
    141015 04:53:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    141015  4:53:50 [Note] Plugin 'FEDERATED' is disabled.
    141015  4:53:50 InnoDB: The InnoDB memory heap is disabled
    141015  4:53:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    141015  4:53:50 InnoDB: Compressed tables use zlib 1.2.3
    141015  4:53:50 InnoDB: Using Linux native AIO
    141015  4:53:50 InnoDB: Initializing buffer pool, size = 128.0M
    141015  4:53:50 InnoDB: Completed initialization of buffer pool
    141015  4:53:50 InnoDB: highest supported file format is Barracuda.
    141015  4:53:50  InnoDB: Waiting for the background threads to start
    141015  4:53:51 InnoDB: 5.5.37 started; log sequence number 345988635
    141015  4:53:51 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    141015  4:53:51 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    141015  4:53:51 [Note] Server socket created on IP: '0.0.0.0'.
    141015  4:53:51 [Note] Event Scheduler: Loaded 0 events
    141015  4:53:51 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.37-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    I please for help, this is shared server. Many thanks in advance!
     
  2. joomla

    joomla Well-Known Member

    Joined:
    Jul 23, 2014
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    I do please for help, is anyone knows what I missing in configuration, I use basic config like this:

    [mysqld]
    local-infile=0
    max_allowed_packet = 256M
    external-locking=FALSE

    max_allowed_packet is set to be managed by cpanel in tweak settings, and also I shose let cpanel determine best value for open_table limits

    Many Thanks! :)
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  4. joomla

    joomla Well-Known Member

    Joined:
    Jul 23, 2014
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Yes it happens whenever I restart SQL, I use both method via WHM restart and shell - via Putty.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page