@yaser I don't know if this will help. From what I found in my case,the
issue seems to be caused due to INNODB Buffer pool settings. I have to
make sure by adding these 3 innodb variables in my mysql conf and its
value by following formula:
innodb_buffer_pool_size = innodb_buffer_pool_chunk_size x
Command run to take backup of databases:
for db in $(mysql -e 'show databases;' | grep "DB_PREFIX"); do mysqldump
--no-tablespaces --single-transaction $db > "$db_bk.sql"; done
I have added "--no-tablespaces" argument to avoid slowness and load
during backup which seemed related to bug https://bu
I tried using jemmalloc and tcmalloc libraries for memory allocation.
However, the memory leak is not fixed.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1789343
Title:
mysqldump in MySQL 5.7 runni
Public bug reported:
I have been using MySQL 5.7.23 in Ubuntu 18.04 installed from offical
repo. It is working fine fine until we tried to take a dump of the
databases. The mysql server contains around 500 small databases which I
used to take individual DB dumps using for loop and mysqldump comman
