Mysql5.7 on docker

oussamanh · 18 June 2023 20:43

I encountered an issue where the MySQL 5.7 server failed to start due to a configuration check failure. I utilized the following configuration

version: '3.8'
services:
  db:
    image: mysql:5.7
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: your_mysql_root_password
      MYSQL_DATABASE: your_mysql_database
      MYSQL_USER: your_mysql_user
      MYSQL_PASSWORD: your_mysql_password
    ports:
      - 3306:3306
    volumes:
      - ./data:/var/lib/mysql

When I executed sudo docker-compose up --build, the following error occurred:

docker-db-1  | 2023-06-18 20:40:45+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.42-1.el7 started.
docker-db-1  | 2023-06-18 20:40:49+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
docker-db-1  | 	command was: mysqld --verbose --help --log-bin-index=/tmp/tmp.WMB106wfSp
docker-db-1  | 	
docker-db-1 exited with code 1
docker-db-1  | 2023-06-18 20:41:50+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.42-1.el7 started.
docker-db-1  | 2023-06-18 20:41:55+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
docker-db-1  | 	command was: mysqld --verbose --help --log-bin-index=/tmp/tmp.IIZIY3Kw7T
docker-db-1  | 	
docker-db-1 exited with code 1
docker-db-1  | 2023-06-18 20:42:55+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.42-1.el7 started.
docker-db-1  | 2023-06-18 20:43:00+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
docker-db-1  | 	command was: mysqld --verbose --help --log-bin-index=/tmp/tmp.JMV8eUnhAS
docker-db-1  | 	
docker-db-1 exited with code 1
docker-db-1  | 2023-06-18 20:44:01+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.42-1.el7 started.
docker-db-1  | 2023-06-18 20:44:05+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
docker-db-1  | 	command was: mysqld --verbose --help --log-bin-index=/tmp/tmp.fztvKvQRA9
docker-db-1  | 	
docker-db-1 exited with code 1

Note: I encountered an additional issue while trying to install MySQL 5.7 on my Manjaro operating system. However, I will provide details about the problem in a new topic. It is crucial for me to resolve this quickly as my boss requires me to use Windows. I kindly request your prompt assistance. Thank you.

oussamanh · 18 June 2023 22:12

I attempted to install MySQL 5.7 directly on my system due to encountering a problem with MySQL 5.7 in Docker [mysql5-7-on-docker/142641]However, I faced a challenge as the desired version was not available through the Pacman package manager. I then tried using the AUR (Arch User Repository), but I encountered this

-- OPENSSL_INCLUDE_DIR = /usr/include
-- OPENSSL_LIBRARY = /usr/lib/libssl.so
-- CRYPTO_LIBRARY = /usr/lib/libcrypto.so
-- OPENSSL_MAJOR_VERSION = 
-- OPENSSL_MINOR_VERSION = 
-- OPENSSL_FIX_VERSION = 
-- Looking for SHA512_DIGEST_LENGTH
-- Looking for SHA512_DIGEST_LENGTH - found
-- 
Cannot find appropriate system libraries for WITH_SSL=system.
Make sure you have specified a supported SSL version. 
Valid options are : 
system (use the OS openssl library), 
yes (synonym for system), 
</path/to/custom/openssl/installation>

CMake Error at cmake/ssl.cmake:63 (MESSAGE):
  Please install the appropriate openssl developer package.

Call Stack (most recent call first):
  cmake/ssl.cmake:306 (FATAL_SSL_NOT_FOUND_ERROR)
  CMakeLists.txt:568 (MYSQL_CHECK_SSL)


-- Configuring incomplete, errors occurred!
==> ERROR: A failure occurred in build().
    Aborting...

i tried to edit PKGBUILD


build() {
  rm -rf build
  mkdir build
  cd build

  cmake "../${_pkgname}-${pkgver}" \
    -DCMAKE_AR=/usr/bin/gcc-ar \
    -DCMAKE_RANLIB=/usr/bin/gcc-ranlib \
    -DBUILD_CONFIG=mysql_release \
    -DCMAKE_INSTALL_PREFIX=/usr \
    -DSYSCONFDIR=/etc/mysql \
    -DMYSQL_DATADIR=/var/lib/mysql \
    -DMYSQL_UNIX_ADDR=/run/mysqld/mysqld.sock \
    -DDEFAULT_CHARSET=utf8 \
    -DDEFAULT_COLLATION=utf8_general_ci \
    -DENABLED_LOCAL_INFILE=ON \
    -DINSTALL_INFODIR=share/mysql/docs \
    -DINSTALL_MANDIR=share/man \
    -DINSTALL_PLUGINDIR=lib/mysql/plugin \
    -DINSTALL_SCRIPTDIR=bin \
    -DINSTALL_INCLUDEDIR=include/mysql \
    -DINSTALL_DOCREADMEDIR=share/mysql \
    -DINSTALL_SUPPORTFILESDIR=share/mysql \
    -DINSTALL_MYSQLSHAREDIR=share/mysql \
    -DINSTALL_DOCDIR=share/mysql/docs \
    -DINSTALL_SHAREDIR=share/mysql \
    -DWITH_ZLIB=system \
    -DWITH_SSL=yes \  //i replace "sytem" by "yes"
    -DWITH_LIBWRAP=OFF \
    -DCMAKE_EXE_LINKER_FLAGS='-ljemalloc' \
    -DWITH_EXTRA_CHARSETS=complex \
    -DWITH_EMBEDDED_SERVER=ON \
    -DWITH_ARCHIVE_STORAGE_ENGINE=ON \
    -DWITH_BLACKHOLE_STORAGE_ENGINE=ON \
    -DWITH_INNOBASE_STORAGE_ENGINE=ON \
    -DWITH_PARTITION_STORAGE_ENGINE=ON \
    -DWITHOUT_EXAMPLE_STORAGE_ENGINE=ON \
    -DWITHOUT_FEDERATED_STORAGE_ENGINE=ON \
    -DCMAKE_C_FLAGS="-fPIC ${CFLAGS} -fno-strict-aliasing -DBIG_JOINS=1 -fomit-frame-pointer -fno-delete-null-pointer-checks" \
    -DCMAKE_C_LINK_FLAGS="${LDFLAGS},-pie" \
    -DCMAKE_CXX_FLAGS="-fPIC ${CXXFLAGS} -std=gnu++98 -fno-strict-aliasing -DBIG_JOINS=1 -felide-constructors -fno-delete-null-pointer-checks" \
    -DCMAKE_CXX_LINK_FLAGS="${LDFLAGS},-pie" \
    -DWITH_BOOST="../boost_${_boost_ver//./_}"
    -DCMAKE_PREFIX_PATH=/usr/bin/openssl   // i added this line
  make
}

it didnt work, any help?

cscs · 18 June 2023 22:17

Do you have base-devel installed?

megavolt · 18 June 2023 22:37

Maybe this?

docker-compose --file docker-compose.yml up

I just copy and paste your configuration and it works.

Always read the documentation or at least the reference: https://hub.docker.com/_/mysql

xabbu · 18 June 2023 22:45

Common Problem with newer SystemD versions.

For example

github.com/docker-library/mysql

MySQL 5.7 image failed while attempting to check config

opened 06:09PM - 01 Jul 22 UTC

closed 07:07PM - 01 Jul 22 UTC

Enqueued

### Introduction: --- Hello, I am running Fedora 36 and trying to run the dock…er image for MySql 5.7 I had been using an already built container for some time but recently when I tried to start the image I am met with an error saying that it failed when checking config. I have been able to successfully build a docker image for MySQL 8 but I need 5.7 for legacy support. I have read issue #840 about it failing due to a bug in Fedora 35 but it ends at that point. Has there been any way to work around this or has it be completed as of F36? ### Docker Run Command: --- docker run -p 3320:3306 --name dev-mysql -v /home/path/to/logs/sql_docker_conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=super-secret-pass -d 74a6a7ec181f ### Docker Logs: --- 2022-07-01 17:50:59+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.38-1debian10 started. 2022-07-01 17:51:08+00:00 **[ERROR] [Entrypoint]: mysqld failed while attempting to check config command was: mysqld --verbose --help --log-bin-index=/tmp/tmp.wAi7qWrgpp** ### Fetch: --- kernel ~ 5.18.7-200.fc36.x86_64 os ~ Fedora Linux 36 (Workstation Edition) arch ~ x86_64 de/wm ~ GNOME cpu ~ AMD Ryzen 7 4700U with Radeon Graphics 2.00GHz@4.0 gpu ~ AMD/ATI Renoir (rev c2) ram ~ 15246 MiB swap ~ 8191 MiB term ~ kitty shell ~ zsh

Sometimes a simple reboot helps, however increasing the limit is usually better.

The Aur package can’t be built with OpenSSL 3, it needs to be changed to use an older OpenSSL version.

oussamanh · 23 June 2023 13:51

it wasnt , i installed it but still the same problem

oussamanh · 23 June 2023 13:56

i tried that , it didnt work
i think u tried the last version not the 5.7 , if no , can you past your configuration here plz?

megavolt · 23 June 2023 16:42

I used this:

oussamanh:

version: '3.8'
services:
  db:
    image: mysql:5.7
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: your_mysql_root_password
      MYSQL_DATABASE: your_mysql_database
      MYSQL_USER: your_mysql_user
      MYSQL_PASSWORD: your_mysql_password
    ports:
      - 3306:3306
    volumes:
      - ./data:/var/lib/mysql

    /tmp/test  docker-compose -f docker-compose.yml up                                                        ✔ 
[+] Building 0.0s (0/0)                                                                                               
Attaching to test-db-1
test-db-1  | 2023-06-23 17:56:02+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.42-1.el7 started.
test-db-1  | 2023-06-23 17:56:17+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
test-db-1  | 2023-06-23 17:56:17+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.42-1.el7 started.
test-db-1  | 2023-06-23 17:56:32+00:00 [Note] [Entrypoint]: Initializing database files
test-db-1  | 2023-06-23T17:56:34.135931Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
test-db-1  | 2023-06-23T17:56:34.191943Z 0 [Warning] InnoDB: New log files created, LSN=45790
test-db-1  | 2023-06-23T17:56:34.204100Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
test-db-1  | 2023-06-23T17:56:34.205768Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4aa21a86-11ef-11ee-acc1-0242ac120002.
test-db-1  | 2023-06-23T17:56:34.205881Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
test-db-1  | 2023-06-23T17:56:34.386137Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
test-db-1  | 2023-06-23T17:56:34.386148Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
test-db-1  | 2023-06-23T17:56:34.386709Z 0 [Warning] CA certificate ca.pem is self signed.
test-db-1  | 2023-06-23T17:56:34.441052Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
test-db-1  | 2023-06-23 17:56:36+00:00 [Note] [Entrypoint]: Database files initialized
test-db-1  | 2023-06-23 17:56:36+00:00 [Note] [Entrypoint]: Starting temporary server
test-db-1  | 2023-06-23 17:56:36+00:00 [Note] [Entrypoint]: Waiting for server startup
test-db-1  | 2023-06-23T17:56:38.239253Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
test-db-1  | 2023-06-23T17:56:38.240459Z 0 [Note] mysqld (mysqld 5.7.42) starting as process 126 ...
test-db-1  | 2023-06-23T17:56:38.243164Z 0 [Note] InnoDB: PUNCH HOLE support available
test-db-1  | 2023-06-23T17:56:38.243180Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
test-db-1  | 2023-06-23T17:56:38.243183Z 0 [Note] InnoDB: Uses event mutexes
test-db-1  | 2023-06-23T17:56:38.243185Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
test-db-1  | 2023-06-23T17:56:38.243187Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
test-db-1  | 2023-06-23T17:56:38.243189Z 0 [Note] InnoDB: Using Linux native AIO
test-db-1  | 2023-06-23T17:56:38.243490Z 0 [Note] InnoDB: Number of pools: 1
test-db-1  | 2023-06-23T17:56:38.243638Z 0 [Note] InnoDB: Using CPU crc32 instructions
test-db-1  | 2023-06-23T17:56:38.245307Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
test-db-1  | 2023-06-23T17:56:38.251797Z 0 [Note] InnoDB: Completed initialization of buffer pool
test-db-1  | 2023-06-23T17:56:38.253860Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
test-db-1  | 2023-06-23T17:56:38.265341Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
test-db-1  | 2023-06-23T17:56:38.270400Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
test-db-1  | 2023-06-23T17:56:38.270452Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
test-db-1  | 2023-06-23T17:56:38.273817Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
test-db-1  | 2023-06-23T17:56:38.274471Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
test-db-1  | 2023-06-23T17:56:38.274477Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
test-db-1  | 2023-06-23T17:56:38.274750Z 0 [Note] InnoDB: Waiting for purge to start
test-db-1  | 2023-06-23T17:56:38.324872Z 0 [Note] InnoDB: 5.7.42 started; log sequence number 2766912
test-db-1  | 2023-06-23T17:56:38.325068Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
test-db-1  | 2023-06-23T17:56:38.325189Z 0 [Note] Plugin 'FEDERATED' is disabled.
test-db-1  | 2023-06-23T17:56:38.327216Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230623 17:56:38
test-db-1  | 2023-06-23T17:56:38.332025Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
test-db-1  | 2023-06-23T17:56:38.332037Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
test-db-1  | 2023-06-23T17:56:38.332041Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
test-db-1  | 2023-06-23T17:56:38.332043Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
test-db-1  | 2023-06-23T17:56:38.332657Z 0 [Warning] CA certificate ca.pem is self signed.
test-db-1  | 2023-06-23T17:56:38.332698Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
test-db-1  | 2023-06-23T17:56:38.334119Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
test-db-1  | 2023-06-23T17:56:38.344405Z 0 [Note] Event Scheduler: Loaded 0 events
test-db-1  | 2023-06-23T17:56:38.344616Z 0 [Note] mysqld: ready for connections.
test-db-1  | Version: '5.7.42'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server (GPL)
test-db-1  | 2023-06-23 17:56:39+00:00 [Note] [Entrypoint]: Temporary server started.
test-db-1  | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
test-db-1  | 2023-06-23T17:56:59.544931Z 3 [Note] InnoDB: Stopping purge
test-db-1  | 2023-06-23T17:56:59.546949Z 3 [Note] InnoDB: Resuming purge
test-db-1  | 2023-06-23T17:56:59.548125Z 3 [Note] InnoDB: Stopping purge
test-db-1  | 2023-06-23T17:56:59.549372Z 3 [Note] InnoDB: Resuming purge
test-db-1  | 2023-06-23T17:56:59.551091Z 3 [Note] InnoDB: Stopping purge
test-db-1  | 2023-06-23T17:56:59.552968Z 3 [Note] InnoDB: Resuming purge
test-db-1  | 2023-06-23T17:56:59.554764Z 3 [Note] InnoDB: Stopping purge
test-db-1  | 2023-06-23T17:56:59.555815Z 3 [Note] InnoDB: Resuming purge
test-db-1  | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
test-db-1  | Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
test-db-1  | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
test-db-1  | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
test-db-1  | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
test-db-1  | 2023-06-23 17:57:00+00:00 [Note] [Entrypoint]: Creating database your_mysql_database
test-db-1  | 2023-06-23 17:57:00+00:00 [Note] [Entrypoint]: Creating user your_mysql_user
test-db-1  | 2023-06-23 17:57:00+00:00 [Note] [Entrypoint]: Giving user your_mysql_user access to schema your_mysql_database
test-db-1  | 
test-db-1  | 2023-06-23 17:57:00+00:00 [Note] [Entrypoint]: Stopping temporary server
test-db-1  | 2023-06-23T17:57:00.609730Z 0 [Note] Giving 0 client threads a chance to die gracefully
test-db-1  | 2023-06-23T17:57:00.609778Z 0 [Note] Shutting down slave threads
test-db-1  | 2023-06-23T17:57:00.609839Z 0 [Note] Forcefully disconnecting 0 remaining clients
test-db-1  | 2023-06-23T17:57:00.609970Z 0 [Note] Event Scheduler: Purging the queue. 0 events
test-db-1  | 2023-06-23T17:57:00.610182Z 0 [Note] Binlog end
test-db-1  | 2023-06-23T17:57:00.623584Z 0 [Note] Shutting down plugin 'ngram'
test-db-1  | 2023-06-23T17:57:00.623664Z 0 [Note] Shutting down plugin 'partition'
test-db-1  | 2023-06-23T17:57:00.623678Z 0 [Note] Shutting down plugin 'BLACKHOLE'
test-db-1  | 2023-06-23T17:57:00.623686Z 0 [Note] Shutting down plugin 'ARCHIVE'
test-db-1  | 2023-06-23T17:57:00.623691Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
test-db-1  | 2023-06-23T17:57:00.623837Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
test-db-1  | 2023-06-23T17:57:00.623860Z 0 [Note] Shutting down plugin 'MyISAM'
test-db-1  | 2023-06-23T17:57:00.624026Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
test-db-1  | 2023-06-23T17:57:00.624080Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
test-db-1  | 2023-06-23T17:57:00.624088Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
test-db-1  | 2023-06-23T17:57:00.624093Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
test-db-1  | 2023-06-23T17:57:00.624098Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
test-db-1  | 2023-06-23T17:57:00.624103Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
test-db-1  | 2023-06-23T17:57:00.624108Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
test-db-1  | 2023-06-23T17:57:00.624113Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
test-db-1  | 2023-06-23T17:57:00.624118Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
test-db-1  | 2023-06-23T17:57:00.624123Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
test-db-1  | 2023-06-23T17:57:00.624128Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
test-db-1  | 2023-06-23T17:57:00.624133Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
test-db-1  | 2023-06-23T17:57:00.624138Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
test-db-1  | 2023-06-23T17:57:00.624143Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
test-db-1  | 2023-06-23T17:57:00.624148Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
test-db-1  | 2023-06-23T17:57:00.624153Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
test-db-1  | 2023-06-23T17:57:00.624158Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
test-db-1  | 2023-06-23T17:57:00.624163Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
test-db-1  | 2023-06-23T17:57:00.624168Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
test-db-1  | 2023-06-23T17:57:00.624173Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
test-db-1  | 2023-06-23T17:57:00.624178Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
test-db-1  | 2023-06-23T17:57:00.624183Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
test-db-1  | 2023-06-23T17:57:00.624188Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
test-db-1  | 2023-06-23T17:57:00.624194Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
test-db-1  | 2023-06-23T17:57:00.624199Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
test-db-1  | 2023-06-23T17:57:00.624204Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
test-db-1  | 2023-06-23T17:57:00.624208Z 0 [Note] Shutting down plugin 'INNODB_CMP'
test-db-1  | 2023-06-23T17:57:00.624213Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
test-db-1  | 2023-06-23T17:57:00.624218Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
test-db-1  | 2023-06-23T17:57:00.624223Z 0 [Note] Shutting down plugin 'INNODB_TRX'
test-db-1  | 2023-06-23T17:57:00.624228Z 0 [Note] Shutting down plugin 'InnoDB'
test-db-1  | 2023-06-23T17:57:00.624384Z 0 [Note] InnoDB: FTS optimize thread exiting.
test-db-1  | 2023-06-23T17:57:00.624604Z 0 [Note] InnoDB: Starting shutdown...
test-db-1  | 2023-06-23T17:57:00.734861Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
test-db-1  | 2023-06-23T17:57:00.735469Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 230623 17:57:00
test-db-1  | 2023-06-23T17:57:02.391483Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12217883
test-db-1  | 2023-06-23T17:57:02.397378Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
test-db-1  | 2023-06-23T17:57:02.397421Z 0 [Note] Shutting down plugin 'MEMORY'
test-db-1  | 2023-06-23T17:57:02.397431Z 0 [Note] Shutting down plugin 'CSV'
test-db-1  | 2023-06-23T17:57:02.397439Z 0 [Note] Shutting down plugin 'sha256_password'
test-db-1  | 2023-06-23T17:57:02.397445Z 0 [Note] Shutting down plugin 'mysql_native_password'
test-db-1  | 2023-06-23T17:57:02.398339Z 0 [Note] Shutting down plugin 'binlog'
test-db-1  | 2023-06-23T17:57:02.826289Z 0 [Note] mysqld: Shutdown complete
test-db-1  | 
test-db-1  | 2023-06-23 17:57:03+00:00 [Note] [Entrypoint]: Temporary server stopped
test-db-1  | 
test-db-1  | 2023-06-23 17:57:03+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
test-db-1  | 
test-db-1  | 2023-06-23T17:57:05.857313Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
test-db-1  | 2023-06-23T17:57:05.858660Z 0 [Note] mysqld (mysqld 5.7.42) starting as process 1 ...
test-db-1  | 2023-06-23T17:57:05.862207Z 0 [Note] InnoDB: PUNCH HOLE support available
test-db-1  | 2023-06-23T17:57:05.862225Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
test-db-1  | 2023-06-23T17:57:05.862232Z 0 [Note] InnoDB: Uses event mutexes
test-db-1  | 2023-06-23T17:57:05.862235Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
test-db-1  | 2023-06-23T17:57:05.862239Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
test-db-1  | 2023-06-23T17:57:05.862241Z 0 [Note] InnoDB: Using Linux native AIO
test-db-1  | 2023-06-23T17:57:05.862545Z 0 [Note] InnoDB: Number of pools: 1
test-db-1  | 2023-06-23T17:57:05.862661Z 0 [Note] InnoDB: Using CPU crc32 instructions
test-db-1  | 2023-06-23T17:57:05.864297Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
test-db-1  | 2023-06-23T17:57:05.872223Z 0 [Note] InnoDB: Completed initialization of buffer pool
test-db-1  | 2023-06-23T17:57:05.874780Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
test-db-1  | 2023-06-23T17:57:05.886460Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
test-db-1  | 2023-06-23T17:57:05.894407Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
test-db-1  | 2023-06-23T17:57:05.894448Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
test-db-1  | 2023-06-23T17:57:05.898927Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
test-db-1  | 2023-06-23T17:57:05.899675Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
test-db-1  | 2023-06-23T17:57:05.899681Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
test-db-1  | 2023-06-23T17:57:05.900419Z 0 [Note] InnoDB: Waiting for purge to start
test-db-1  | 2023-06-23T17:57:05.950567Z 0 [Note] InnoDB: 5.7.42 started; log sequence number 12217883
test-db-1  | 2023-06-23T17:57:05.950852Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
test-db-1  | 2023-06-23T17:57:05.951060Z 0 [Note] Plugin 'FEDERATED' is disabled.
test-db-1  | 2023-06-23T17:57:05.953038Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230623 17:57:05
test-db-1  | 2023-06-23T17:57:05.956652Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
test-db-1  | 2023-06-23T17:57:05.956672Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
test-db-1  | 2023-06-23T17:57:05.956695Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
test-db-1  | 2023-06-23T17:57:05.956697Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
test-db-1  | 2023-06-23T17:57:05.957458Z 0 [Warning] CA certificate ca.pem is self signed.
test-db-1  | 2023-06-23T17:57:05.957526Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
test-db-1  | 2023-06-23T17:57:05.957954Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
test-db-1  | 2023-06-23T17:57:05.958028Z 0 [Note] IPv6 is available.
test-db-1  | 2023-06-23T17:57:05.958058Z 0 [Note]   - '::' resolves to '::';
test-db-1  | 2023-06-23T17:57:05.958076Z 0 [Note] Server socket created on IP: '::'.
test-db-1  | 2023-06-23T17:57:05.959833Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
test-db-1  | 2023-06-23T17:57:05.970708Z 0 [Note] Event Scheduler: Loaded 0 events
test-db-1  | 2023-06-23T17:57:05.971030Z 0 [Note] mysqld: ready for connections.
test-db-1  | Version: '5.7.42'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)

but note it uses 52% (of ~30GB) of my RAM :

sudo smem -p -t | grep mysqld
280455 999      mysqld                         0.00%   52.70%   52.70%   52.70%

See this to solve that: Really high memory usage · Issue #579 · docker-library/mysql · GitHub

oussamanh · 24 June 2023 17:37

thank u sir
i got the solution by replace LimitNOFILE=infinity by
LimitNOFILE=1048576 in /lib/systemd/system/containerd.service i was think that the value infinity do the job , but it wasn’t

system · 27 June 2023 07:37

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.