Question ib_Buffer buffer_pool
Bonjour,
J'ai ce message en boucle toutes les 2 ou 3 heures:
Code:
1 2 3 4 5
| InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
InnoDB: Buffer pool(s) dump completed at 210531 11:41:30
Got an error reading communication packets
Got an error reading communication packets
Got an error reading communication packets |
ça correspondrait à un paramètre mal configuré/adapté ...? Faut-il augmenter Buffer pool ?
Faut-il augmenter => max_allowed_packet ? value actuellement = 4194503
Ma config: BUFFER POOL AND MEMORY
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| ----------------------
Total large memory allocated 5497159680
Dictionary memory allocated 415979
Buffer pool size 327660
Free buffers 136541
Database pages 184964
Old database pages 68114
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 37, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10902, created 174062, written 1598086
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 184964, unzip_LRU len: 0
I/O sum[0]:cur[24], unzip sum[0]:cur[0] |
Rien d'anormale !
MERCI.
A+