Problem with my.cnf settings

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:

141015  4:53:47 [Note] /usr/sbin/mysqld: Normal shutdown

141015  4:53:47 [Note] Event Scheduler: Purging the queue. 0 events
141015  4:53:49 [Warning] /usr/sbin/mysqld: Forcing close of thread 57  user: 'leechprotect'

141015  4:53:49 [Warning] /usr/sbin/mysqld: Forcing close of thread 5  user: 'root'

141015  4:53:49 [Warning] /usr/sbin/mysqld: Forcing close of thread 3  user: 'eximstats'
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!

joomla

October 15, 2014 13:10

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! :)

cPanelMichael

October 15, 2014 14:33

Hello :) Does this happen on every MySQL restart? What method are you using to restart MySQL? Thank you.

October 15, 2014 15:04

Yes it happens whenever I restart SQL, I use both method via WHM restart and shell - via Putty.

October 15, 2014 19:34

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.

Problem with my.cnf settings

Comments

Didn't find what you were looking for?