OK, merci pour les tuyaux. Voici ce que donne le premier message:
root@stemy:~# tail -n 200 /var/lib/mysql/*.err
180521 18:17:56 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
180521 18:17:58 [Note] InnoDB: 128 rollback segment(s) are active.
180521 18:17:58 [Note] InnoDB: Waiting for purge to start
180521 18:17:58 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 943897510
180521 18:17:58 [Note] Plugin 'FEEDBACK' is disabled.
180521 18:17:58 [Note] Server socket created on IP: '::'.
180521 18:17:58 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.32-MariaDB-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
180522 14:33:12 mysqld_safe Number of processes running now: 0
180522 14:33:12 mysqld_safe mysqld restarted
180522 14:33:14 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 25156 ...
180522 14:33:15 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
180522 14:33:15 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180522 14:33:15 [Note] InnoDB: The InnoDB memory heap is disabled
180522 14:33:15 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180522 14:33:15 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180522 14:33:15 [Note] InnoDB: Compressed tables use zlib 1.2.8
180522 14:33:15 [Note] InnoDB: Using Linux native AIO
180522 14:33:15 [Note] InnoDB: Not using CPU crc32 instructions
180522 14:33:15 [Note] InnoDB: Initializing buffer pool, size = 128.0M
180522 14:33:15 [Note] InnoDB: Completed initialization of buffer pool
180522 14:33:15 [Note] InnoDB: Highest supported file format is Barracuda.
180522 14:33:15 [Note] InnoDB: Starting crash recovery from checkpoint LSN=956425393
180522 14:33:15 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1 row operations to undo
InnoDB: Trx id counter is 17259008
180522 14:33:16 [Note] InnoDB: Starting final batch to recover 1 pages from redo log
180522 14:33:17 [Note] InnoDB: 128 rollback segment(s) are active.
180522 14:33:17 [Note] InnoDB: Starting in background the rollback of recovered transactions
2018-05-22 14:33:17 a67ff420 InnoDB: Rolling back trx with id 17258671, 1 rows to undo
180522 14:33:17 [Note] InnoDB: Waiting for purge to start
180522 14:33:17 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 956425516
180522 14:33:17 [Note] InnoDB: Rollback of trx with id 17258671 completed
180522 14:33:17 [Note] InnoDB: Rollback of non-prepared transactions completed
180522 14:33:17 [Note] Plugin 'FEEDBACK' is disabled.
180522 14:33:17 [Note] Server socket created on IP: '::'.
180522 14:33:17 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.32-MariaDB-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
180522 18:00:54 mysqld_safe Number of processes running now: 0
180522 18:00:55 mysqld_safe mysqld restarted
180522 18:00:56 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 29436 ...
180522 18:00:56 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
180522 18:00:56 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180522 18:00:56 [Note] InnoDB: The InnoDB memory heap is disabled
180522 18:00:56 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180522 18:00:56 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180522 18:00:56 [Note] InnoDB: Compressed tables use zlib 1.2.8
180522 18:00:56 [Note] InnoDB: Using Linux native AIO
180522 18:00:56 [Note] InnoDB: Not using CPU crc32 instructions
180522 18:00:58 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(138149888 bytes) failed; errno 12
180522 18:00:58 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
180522 18:00:58 [ERROR] Plugin 'InnoDB' init function returned error.
180522 18:00:58 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
180522 18:00:58 [ERROR] mysqld: Out of memory (Needed 130760704 bytes)
180522 18:00:58 [Note] Plugin 'FEEDBACK' is disabled.
180522 18:00:58 [ERROR] Unknown/unsupported storage engine: innodb
180522 18:00:58 [ERROR] Aborting
180522 18:00:58 [Note] /usr/sbin/mysqld: Shutdown complete
180522 18:00:59 mysqld_safe mysqld from pid file /var/lib/mysql/stemy.me.pid ended
180522 18:07:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180522 18:07:42 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 29868 ...
180522 18:07:42 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
180522 18:07:42 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180522 18:07:42 [Note] InnoDB: The InnoDB memory heap is disabled
180522 18:07:42 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180522 18:07:42 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180522 18:07:42 [Note] InnoDB: Compressed tables use zlib 1.2.8
180522 18:07:42 [Note] InnoDB: Using Linux native AIO
180522 18:07:42 [Note] InnoDB: Not using CPU crc32 instructions
180522 18:07:42 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(138149888 bytes) failed; errno 12
180522 18:07:42 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
180522 18:07:42 [ERROR] Plugin 'InnoDB' init function returned error.
180522 18:07:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
180522 18:07:42 [ERROR] mysqld: Out of memory (Needed 130760704 bytes)
180522 18:07:42 [Note] Plugin 'FEEDBACK' is disabled.
180522 18:07:42 [ERROR] Unknown/unsupported storage engine: innodb
180522 18:07:42 [ERROR] Aborting
180522 18:07:43 [Note] /usr/sbin/mysqld: Shutdown complete
180522 18:07:43 mysqld_safe mysqld from pid file /var/lib/mysql/stemy.me.pid ended
180522 18:14:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180522 18:14:17 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 30505 ...
180522 18:14:17 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
180522 18:14:17 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180522 18:14:17 [Note] InnoDB: The InnoDB memory heap is disabled
180522 18:14:17 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180522 18:14:17 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180522 18:14:17 [Note] InnoDB: Compressed tables use zlib 1.2.8
180522 18:14:17 [Note] InnoDB: Using Linux native AIO
180522 18:14:17 [Note] InnoDB: Not using CPU crc32 instructions
180522 18:14:17 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(138149888 bytes) failed; errno 12
180522 18:14:17 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
180522 18:14:17 [ERROR] Plugin 'InnoDB' init function returned error.
180522 18:14:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
180522 18:14:17 [ERROR] mysqld: Out of memory (Needed 130760704 bytes)
180522 18:14:17 [Note] Plugin 'FEEDBACK' is disabled.
180522 18:14:17 [ERROR] Unknown/unsupported storage engine: innodb
180522 18:14:17 [ERROR] Aborting
180522 18:14:17 [Note] /usr/sbin/mysqld: Shutdown complete
180522 18:14:17 mysqld_safe mysqld from pid file /var/lib/mysql/stemy.me.pid ended
180522 18:25:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180522 18:25:10 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 1113 ...
180522 18:25:10 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
180522 18:25:10 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180522 18:25:10 [Note] InnoDB: The InnoDB memory heap is disabled
180522 18:25:10 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180522 18:25:10 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180522 18:25:10 [Note] InnoDB: Compressed tables use zlib 1.2.8
180522 18:25:10 [Note] InnoDB: Using Linux native AIO
180522 18:25:10 [Note] InnoDB: Not using CPU crc32 instructions
180522 18:25:10 [Note] InnoDB: Initializing buffer pool, size = 128.0M
180522 18:25:10 [Note] InnoDB: Completed initialization of buffer pool
180522 18:25:11 [Note] InnoDB: Highest supported file format is Barracuda.
180522 18:25:11 [Note] InnoDB: The log sequence numbers 943891780 and 943891780 in ibdata files do not match the log sequence number 959152345 in the ib_logfiles!
180522 18:25:12 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
180522 18:25:14 [Note] InnoDB: 128 rollback segment(s) are active.
180522 18:25:14 [Note] InnoDB: Waiting for purge to start
180522 18:25:14 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 959152345
180522 18:25:14 [Note] Plugin 'FEEDBACK' is disabled.
180522 18:25:14 [Note] Server socket created on IP: '::'.
180522 18:25:14 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.32-MariaDB-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
180522 18:42:53 [Note] /usr/sbin/mysqld: Normal shutdown
180522 18:42:53 [Note] Event Scheduler: Purging the queue. 0 events
180522 18:42:56 [Note] InnoDB: FTS optimize thread exiting.
180522 18:42:56 [Note] InnoDB: Starting shutdown...
180522 18:42:57 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
180522 18:42:59 [Note] InnoDB: Shutdown completed; log sequence number 959395130
180522 18:42:59 [Note] /usr/sbin/mysqld: Shutdown complete
180522 18:42:59 mysqld_safe mysqld from pid file /var/lib/mysql/stemy.me.pid ended
180522 19:00:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180522 19:00:34 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 1092 ...
180522 19:00:35 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
180522 19:00:35 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180522 19:00:35 [Note] InnoDB: The InnoDB memory heap is disabled
180522 19:00:35 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180522 19:00:35 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180522 19:00:35 [Note] InnoDB: Compressed tables use zlib 1.2.8
180522 19:00:35 [Note] InnoDB: Using Linux native AIO
180522 19:00:35 [Note] InnoDB: Not using CPU crc32 instructions
180522 19:00:35 [Note] InnoDB: Initializing buffer pool, size = 128.0M
180522 19:00:35 [Note] InnoDB: Completed initialization of buffer pool
180522 19:00:35 [Note] InnoDB: Highest supported file format is Barracuda.
180522 19:00:37 [Note] InnoDB: 128 rollback segment(s) are active.
180522 19:00:37 [Note] InnoDB: Waiting for purge to start
180522 19:00:37 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 959395130
180522 19:00:37 [Note] Plugin 'FEEDBACK' is disabled.
180522 19:00:37 [Note] Server socket created on IP: '::'.
180522 19:00:38 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.32-MariaDB-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
180522 19:28:21 [Note] /usr/sbin/mysqld: Normal shutdown
180522 19:28:21 [Note] Event Scheduler: Purging the queue. 0 events
180522 19:28:21 [Note] InnoDB: FTS optimize thread exiting.
180522 19:28:21 [Note] InnoDB: Starting shutdown...
180522 19:28:22 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
180522 19:28:24 [Note] InnoDB: Shutdown completed; log sequence number 959805945
180522 19:28:24 [Note] /usr/sbin/mysqld: Shutdown complete
180522 19:28:25 mysqld_safe mysqld from pid file /var/lib/mysql/stemy.me.pid ended
180522 19:30:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180522 19:30:53 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 1087 ...
180522 19:30:53 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
180522 19:30:53 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180522 19:30:53 [Note] InnoDB: The InnoDB memory heap is disabled
180522 19:30:53 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180522 19:30:53 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180522 19:30:53 [Note] InnoDB: Compressed tables use zlib 1.2.8
180522 19:30:53 [Note] InnoDB: Using Linux native AIO
180522 19:30:53 [Note] InnoDB: Not using CPU crc32 instructions
180522 19:30:53 [Note] InnoDB: Initializing buffer pool, size = 128.0M
180522 19:30:54 [Note] InnoDB: Completed initialization of buffer pool
180522 19:30:54 [Note] InnoDB: Highest supported file format is Barracuda.
180522 19:30:54 [Note] InnoDB: The log sequence numbers 959805945 and 959805945 in ibdata files do not match the log sequence number 959811700 in the ib_logfiles!
180522 19:30:56 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
180522 19:30:59 [Note] InnoDB: 128 rollback segment(s) are active.
180522 19:30:59 [Note] InnoDB: Waiting for purge to start
180522 19:30:59 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 959811700
180522 19:30:59 [Note] Plugin 'FEEDBACK' is disabled.
180522 19:30:59 [Note] Server socket created on IP: '::'.
180522 19:31:00 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.32-MariaDB-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
root@stemy:~#
Pour le deuxième, je vais attendre que l’erreur se produise.
Mon hardware est une brique Olinuxino Lime 1. Ce serait bizarre que les dysfonctionnements soient du au manque de mémoire, parce que si c’était le cas, l’association à laquelle j’ai fait appel n’aurait pas proposé d’installer YNH sur ce modèle, mais supposons que ce soit ça, y a-t-il un moyen de connaître à posteriori la quantité de mémoire vive occupée ?
Cordialement.