• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 470
  • Last Modified:

mysql hangs on opennig tables

i have running mysql db (5.0.51a-24) on debian lenny
cpu :  Intel(R) Xeon(R) CPU E5405  @ 2.00GHz
ram : 4G
around 50-70 mysql connections

and mysql hangs on opening tables

mysql conf attached
1 Solution
What exactly do you mean by "hangs on opening tables" - what's the exact way to replicate the problem and what exactly makes you conclude it's hanging?  Also, how's the server cpu and memory utilization during this time?
theGhost_k8Database ConsultantCommented:
Initally use mysql tuner to check your server configuration and follow the suggestions.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now