Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 466
  • 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?
K VDatabase ConsultantCommented:
Initally use mysql tuner to check your server configuration and follow the suggestions.

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

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