[Expired for mysql-5.7 (Ubuntu) because there has been no activity for
60 days.]
** Changed in: mysql-5.7 (Ubuntu)
Status: Incomplete => Expired
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
Hi,
As this still seems to be an issue I moved the bug report status back to
Incomplete. If this is actually a bug and not a configuration problem
we'd really like to deliver a fix for it, or to get it properly filed
upstream if it belongs tehre, however we first need to reproduce the
issue
@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
I have the same problem but the Ubuntu version is 16 and MySQL 5.7
When I create the daily MySQL backup by mysqldump command the allocated
memory by MySQL changed from 15% to 89% and not released.
It causes many problem on the server.
We have about 10 databases which has about 140 tables with
[Expired for mysql-5.7 (Ubuntu) because there has been no activity for
60 days.]
** Changed in: mysql-5.7 (Ubuntu)
Status: Incomplete => Expired
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
If you have a simple reproducer script, that would help. "400-500 small
databases" is a bit too generic.
** Changed in: mysql-5.7 (Ubuntu)
Status: New => Incomplete
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
Are you saying that the memory usage increases with eacy mysqldump
command, or that perhaps one or a few databases are particularly big and
the OOM happens when those are hit? A t2.small instance has just 2Gb of
memory, isn't that a bit tight for 500 databases?
--
You received this bug
If you have a simple reproducer script, that would help. "400-500 small
databases" is a bit too generic.
** Changed in: mysql-5.7 (Ubuntu)
Status: New => Incomplete
--
You received this bug notification because you are a member of Ubuntu
Server, which is subscribed to mysql-5.7 in
Are you saying that the memory usage increases with eacy mysqldump
command, or that perhaps one or a few databases are particularly big and
the OOM happens when those are hit? A t2.small instance has just 2Gb of
memory, isn't that a bit tight for 500 databases?
--
You received this bug
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
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
** Package changed: ubuntu => mysql-5.7 (Ubuntu)
--
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 running on Ubuntu 18.04 does not release memory
To manage
12 matches
Mail list logo