My Oracle Support Banner

InnoDB Tables Uses More Memory In 5.7 Than 5.6 (Doc ID 2210505.1)

Last updated on FEBRUARY 03, 2019

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Symptoms

For a MySQL instance with many InnoDB tables and/or partitions, after upgrading to MySQL Server 5.7, the memory usage is higher than before the upgrade. Enabling the memory instrumentation in the Performance Schema shows the main memory usage comes from InnoDB's heap usage (memory/innodb/mem0mem):

 

Additionally there are many allocations and deallocations of memory/innodb/mem0mem which together with the added memory usage can cause poor performance of some queries, particularly scans of for example the information_schema.TABLES table which causes many partitioned tables to be opened.

Changes

MySQL was upgraded to MySQL Server 5.7.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.