This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

MySQL Memory Leak

I am still waiting on a fix for this. All of my firewalls, run into this after more than 2 weeks of operation. MySQL starts chewing 40-50% of memory and then starts hitting CPU cycles, so the only resolution is to either restart the firewall or issue: service mysql restart at the console. Does anybody out there know when this will be fixed. Kinda bad that a production firewall goes out because an internal process is running away!

This thread was automatically locked due to age.

Parents

0 BarryG over 18 years ago

I was having that problem in 7.00x, but have not seen it since updating to 7.1. (or earlier, 7.008 maybe?)

I don't have much traffic though (at home).

Barry
Cancel
Vote Up 0 Vote Down

Cancel
0 Jalmillategui over 18 years ago in reply to BarryG

The Issue still happens in 7.101. It seems to be related to p2p blocking in the IM/P2P security. I have been able to duplicate the issue when I have the p2p protocols blocked and have several clients trying to use p2p software (Ares and bittorrent). after a few weeks of operation, the mysqld server will start using 40%+ of CPU and lots of memory.
Cancel
Vote Up 0 Vote Down

Cancel
0 Godsbrother over 18 years ago in reply to Hi-con
Logged in as root. When I initiated
crontab -e
it said there were no existing jobs, so it created a new one. I would also give your support heads up that you are doing this. I got the go ahead from Astaro support, but better safe than sorry....(Don't want to be responsible for voiding your warranty or support[:)])

Yea probab;y will have to log a call for other things anyhow. Namely that fact that the daily reports are garbage again.
Cancel
Vote Up 0 Vote Down

Cancel
0 JimmyM over 17 years ago in reply to Godsbrother

I'm having the MySQL memory creep too.
But I'm having difficulty adding the crontab to restart mysql.
As root I execute > crontab -e
Then I get a screen where there's nothing but a string of "~" down the left side.
After entering 0 3 * * * /etc/init.d/mysql restart
What do I do to store the new crontab in root's list of crontabs?
Cancel
Vote Up 0 Vote Down

Cancel
0 andreas over 17 years ago in reply to JimmyM

The default editor is vi; you can use :wq to write, then quit, or :q! to quit without writing.
Cheers,
andreas
Cancel
Vote Up 0 Vote Down

Cancel
0 William Warren over 17 years ago in reply to andreas

let's hope they actually modify mysql's memory usage instead of simply adding a mysql restart nightly as part of 7.3..

Owner: Emmanuel Technology Consulting

http://etc-md.com

Former Sophos SG(Astaro) advocate/researcher/Silver Partner

PfSense w/Suricata, ntopng,

Other addons to follow
Cancel
Vote Up 0 Vote Down

Cancel
0 JimmyM over 17 years ago in reply to andreas

The default editor is vi; you can use :wq to write, then quit, or :q! to quit without writing.
Cheers,
andreas

Oh, I see. I'm basically stupid when it comes to vi. Typically I use joe for editing text files in ASG. Is there any way to specify joe while trying to edit the crontab?
Like > crontab -e|joe
Cancel
Vote Up 0 Vote Down

Cancel
0 drees over 17 years ago in reply to JimmyM

crontab -e|joe

Try:

[FONT="Courier New"]EDITOR=joe crontab -e[/FONT]
Cancel
Vote Up 0 Vote Down

Cancel
0 andreas over 17 years ago in reply to William Warren

let's hope they actually modify mysql's memory usage instead of simply adding a mysql restart nightly as part of 7.3..

This problem will be solved for good, I promise [:)]
Cancel
Vote Up 0 Vote Down

Cancel
0 JimmyM over 17 years ago in reply to drees

Try:

[FONT="Courier New"]EDITOR=joe crontab -e[/FONT]

That did it.
Thanks.
Cancel
Vote Up 0 Vote Down

Cancel
0 JimmyM over 17 years ago in reply to JimmyM

What does ASG use mysql for?
Cancel
Vote Up 0 Vote Down

Cancel
0 BrucekConvergent over 17 years ago in reply to JimmyM

Storing the configuration, basic reporting, etc.

CTO, Convergent Information Security Solutions, LLC

https://www.convergesecurity.com

Advice given as posted on this forum does not construe a support relationship or other relationship with Convergent Information Security Solutions, LLC or its subsidiaries. Use the advice given at your own risk.
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 BrucekConvergent over 17 years ago in reply to JimmyM

Storing the configuration, basic reporting, etc.

CTO, Convergent Information Security Solutions, LLC

https://www.convergesecurity.com

Advice given as posted on this forum does not construe a support relationship or other relationship with Convergent Information Security Solutions, LLC or its subsidiaries. Use the advice given at your own risk.
Cancel
Vote Up 0 Vote Down

Cancel

Children

No Data