InMotion Hosting Support Center

MySQL DB memory usage remain high in idel connection?

Category: Server Usage

2013-06-23 4:11 am EST

Hits: 1,448
Hello team,

May I have some assistant on MySQL DB troubleshooting? 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.

* 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.



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

You can get a copy of your logs by <a href="" target="_blank">contacting support</a>. Out Second support tier can run them and save them to your home directory. If you have <a href="" target="_blank">root access</a> you can access them here using <a href="" target="_blank">shell</a>.


It depends an what you need changed on ho you go about changing the settings. Some settings can be changed in your <a href="" 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="" 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
32 Points
2013-06-24 10:54 am EST
Like this Question?

Need more Help?


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:
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!