How to limit mysql's memory?

[Insua]

Description:

mysql image took my 60 percent memory

Expected Behavior:

mysql use 1G ~ 2G memory was excepted

Context information:

Output of git rev-parse HEAD

06cc77a15623350fb9c595b1b86ced824e870013

Output of docker version

24.0.7

Output of docker-compose version

2.24.2

System info: Mac, Windows or Linux. Include which disto/version

archlinux

Steps to reproduce the issue:

docker-compose up -d mysql

Stacktrace & Additional info:

I change my.cnf

innodb_use_native_aio=0
performance_schema_max_table_instances=400
table_definition_cache=400    
performance_schema=off  
table_open_cache=64    
innodb_buffer_pool_chunk_size=64M  
innodb_buffer_pool_size=64M  

But does't work

[parallels999]

docker-compose build mysql
docker-compose up -d mysql

[Insua]

change version to 8.0 only take 400M memory