Memory used > 100% ? #260

Open
jppo opened this Issue Oct 21, 2016 · 5 comments

Projects

None yet

2 participants

@jppo
jppo commented Oct 21, 2016

Hello,
I get some strange results with the last version :

[!!] Maximum reached memory usage: 1.1G (111055.85% of installed RAM)
[!!] Maximum possible memory usage: 1.1G (114318.35% of installed RAM)
[!!] Overall possible memory usage with other process exceeded memory
......
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***

System is Debian 8.6
RAM 16Go
CPU core I5 5765
Some disks ...
Mysql version : 5.6.30-1~bpo8+1-log

Two lines of "top" about memory :
KiB Mem: 16174796 total, 15736004 used, 438792 free, 311712 buffers
KiB Swap: 20688888 total, 92488 used, 20596400 free. 4099568 cached Mem

Regards

JP P

@jmrenouard
Collaborator

Hi @jppo
Can you give all information with --debug ?

Thanks

@jppo
jppo commented Oct 25, 2016

Hello,

I enclose the output of a run with "--debug".

Hope this helps, ready to another try ...

Regards

JP P

De: "Jean-Marie Renouard" notifications@github.com
À: "major/MySQLTuner-perl" MySQLTuner-perl@noreply.github.com
Cc: "jppo" jp.pozzi@izzop.net, "Mention" mention@noreply.github.com
Envoyé: Dimanche 23 Octobre 2016 14:24:25
Objet: Re: [major/MySQLTuner-perl] Memory used > 100% ? (#260)

Hi @jppo
Can you give all information with --debug ?

Thanks


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub , or mute the thread .

@jmrenouard
Collaborator

Hi @jppo

Can you push the output result for
mysqltumer.pl --debug

Thanks
@jmrenouard

@jppo
jppo commented Oct 27, 2016

Hello/bonjour,

The result of mysqltuner.pl --debug is attached ...

Regards

JP Pozzi

De: "Jean-Marie Renouard" notifications@github.com
À: "major" MySQLTuner-perl@noreply.github.com
Cc: "jppo" jp.pozzi@izzop.net, "Mention" mention@noreply.github.com
Envoyé: Jeudi 27 Octobre 2016 21:19:16
Objet: Re: [major/MySQLTuner-perl] Memory used > 100% ? (#260)

Hi @jppo

Can you push the output result for
mysqltumer.pl --debug

Thanks
@jmrenouard


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub , or mute the thread .

@jmrenouard jmrenouard added a commit that referenced this issue Nov 2, 2016
@jmrenouard jmrenouard #265 TOP 15 queries with temp table to disk
#260 Memory used > 100% ?
#258
5872fcc
@jmrenouard
Collaborator

Hi @jppo

Sorry, I doesn't get any attachment file.
@jmrenouard

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment