MySQL DB memory usage remain high in idel connection?

Category: Server Usage

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

Hits: 1,170
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.

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
Staff
5,889 Points
2013-06-24 9:44 am EST
Hello CanopyValley!

You can get a copy of your logs by contacting support. Out Second support tier can run them and save them to your home directory. If you have root access you can access them here using shell.

/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 WHM and others require shell access with root. Any change you do need done can be done by our support for you.

Excessive MySQL activity

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?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

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!