Bonjour,
Depuis une mise à jour, je constate un changement config mysql.
Sur monit il n’y a plus de supervision:
check process mysql with pidfile /var/run/mysqld/mysqld.pid
group database
start program = "/etc/init.d/mysql start"
stop program = "/etc/init.d/mysql stop"
if failed unix "/var/run/mysqld/mysqld.sock" then restart
if failed host 127.0.0.1 port 3306 then restart
if 5 restarts within 5 cycles then timeout
Lorsque je tape la commande ps aux | grep mysql
root 1789 0.0 0.1 9360 1592 ? S Nov27 0:00 /bin/bash /usr/bin/mysqld_safe
mysql 1978 0.0 7.9 836692 83192 ? Sl Nov27 1:08 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/ndacostasvr.err --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --wsrep_recover --log_error=/var/lib/mysql/wsrep_recovery.G8t4Gq --pid-file=/var/lib/mysql/host-recover.pid
root 23947 0.0 0.0 6264 724 pts/0 S+ 13:36 0:00 grep mysql
je me suis rendu compte que le processus pointe vers /var/lib/mysql/ alors auparavant il semble qu il était dans /var/run/mysqld/
Information mysqld --version
Log
141127 20:21:20 [Note] InnoDB: Using mutexes to ref count buffer pool pages
141127 20:21:20 [Note] InnoDB: The InnoDB memory heap is disabled
141127 20:21:20 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
141127 20:21:20 [Note] InnoDB: Memory barrier is not used
141127 20:21:20 [Note] InnoDB: Compressed tables use zlib 1.2.7
141127 20:21:20 [Note] InnoDB: Using Linux native AIO
141127 20:21:20 [Note] InnoDB: Using CPU crc32 instructions
141127 20:21:20 [Note] InnoDB: Initializing buffer pool, size = 128.0M
141127 20:21:20 [Note] InnoDB: Completed initialization of buffer pool
141127 20:21:21 [Note] InnoDB: Highest supported file format is Barracuda.
141127 20:21:21 [Note] InnoDB: 128 rollback segment(s) are active.
141127 20:21:21 [Note] InnoDB: Waiting for purge to start
141127 20:21:21 [Note] InnoDB: Percona XtraDB ([url]http://www.percona.com[/url]) 5.6.20-68.0 started; log sequence number 1617001
141127 20:21:21 [Note] Plugin 'FEEDBACK' is disabled.
141127 20:21:22 [Note] Server socket created on IP: '127.0.0.1'.
141127 20:21:22 [Note] Event Scheduler: Loaded 0 events
141127 20:21:22 [Note] WSREP: Read nil XID from storage engines, skipping position init
141127 20:21:22 [Note] WSREP: wsrep_load(): loading provider library 'none'
141127 20:21:22 [Note] Reading of all Master_info entries succeded
141127 20:21:22 [Note] Added new Master_info '' to hash table
141127 20:21:22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.1-MariaDB-1~wheezy-wsrep-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution, wsrep_25.10.r4123
N étant pas un expert pouvez vous me dire si cela est normalement ? après plusieurs recherches sur le net j 'ai vu qu’il existait un mod recovery mais dans mon fichier my.cnf il n est pas activé
Merci d’avance pour votre aide.