InMotion Hosting Support Center

MySQL Memory Usage Remaining High

Category: Server Usage

CanopyValley
Asked:
2013-06-23 4:11 am EST

Hits: 1,472
Hello team,

Mysql memory usage remaining high on idle connections. I am using Top to monitor MySQLD memory usage remain very high even when the website is offline with no background script running.

I am on a VSP server and notice MySQL took over 400MB to run. It caused Joomla! yield internal server error because of the lack of memory.

Questions:
* how can I get a copy of the MySQL log for review?
* I am using phpMyAdmin for analysis, it provide some hints / tips for mySQL configuration to improve performance, how can I go by implementing them?
* Base on our observation, look like there are some kind of memory leak issue on MySQL and not releasing the memory after the query is done. Any suggestion how we can troubleshoot the issue?

Thanks in advance for your help.

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

jamesr
5,889 Points
2013-06-24 9:44 am EST
Hello CanopyValley!

Thank you for your question about <strong>Mysql memory usage remaining high</strong>.

You can get a copy of your logs by contacting <a href="http://www.inmotionhosting.com/support/website/website-troubleshooting/how-to-get-great-technical-support">Live Support</a>. Out Second support tier can run them and save them to your home directory. If you have <a href="http://www.inmotionhosting.com/support/website/general-server-setup/root-access-faq" target="_blank">root access</a> you can access them here using <a href="http://www.inmotionhosting.com/support/website/general-server-setup/what-is-shell-access" target="_blank">shell</a>.

/var/lib/mysql/hostname.err

It depends an what you need changed on ho you go about changing the settings. Some settings can be changed in your <a href="http://www.inmotionhosting.com/support/website/general-server-setup/whm-web-host-manager" target="_blank">WHM</a> and others require shell access with root. Any change you do need done can be done by our support for you.

<a href="http://www.inmotionhosting.com/support/website/website-troubleshooting/excessive-mysql-activity" target="_blank">Excessive MySQL activity</a>

Best Regards,
James R

You must login before you can post a comment about this answer.

Could you please kindly assist to get a copy of the mySQL error log for review?
Do you guys have any MySQL tuning hints and tips? thanks
CanopyValley
32 Points
2013-06-24 10:54 am EST
Like this Question?

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Social Media Login

   
Social Login Joomla

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!