Mailing List ecs-isp@2rosenthals.com Archived Message #538 previous message next message back to list

From: "Massimo S." <ecs-isp@2rosenthals.com> Full Headers
Undecoded message
Subject: Re: [eCS-ISP] mysql upgrade 5.1.73 -> 5.6.51 (innodb)
Date: Fri, 11 Aug 2023 13:13:08 +0200
To: 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
Subscribe: Feed, Digest, Index.
Unsubscribe
Mail to ListMaster