| Fra: |
"Massimo S." <ecs-isp@2rosenthals.com> |
Full Headers
Undecoded message |
| Emne: |
Re: [eCS-ISP] mysql upgrade 5.1.73 -> 5.6.51 (innodb) |
| Dato: |
Fri, 11 Aug 2023 13:13:08 +0200 |
| Til: |
eCS ISP Mailing List <ecs-isp@2rosenthals.com> |
|
|---|
Il 11/08/2023 00:11, Steven Levine ha scritto:
In <list-7643094@2rosenthals.com>, on 08/10/23
at 09:02 PM, "Massimo S." <ecs-isp@2rosenthals.com> said:
Hi Massimo,
this could give slower performances than before?
It's impossible to know without testing and collecting data. What you can
do is use
show engine innodb status;
which will tell you how much of the buffer pool you are actually using.
Steven
log say this
2023-08-11 13:05:45 19085 [Note] InnoDB: The InnoDB memory heap is disabled
2023-08-11 13:05:45 19085 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-08-11 13:05:45 19085 [Note] InnoDB: Memory barrier is not used
2023-08-11 13:05:45 19085 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-08-11 13:05:45 19085 [Note] InnoDB: Not using CPU crc32 instructions
2023-08-11 13:05:45 19085 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-08-11 13:05:45 19085 [Note] InnoDB: Completed initialization of buffer pool
show engine innodb status:
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 136019968; in additional pool allocated 0
Dictionary memory allocated 33251
Buffer pool size 8192
Free buffers 7944
Database pages 248
Old database pages 0
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
massimo
|