mysql hangs on opennig tables

Posted on 2011-05-02
Last Modified: 2012-08-14
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
Question by:_Amanat_
    LVL 24

    Expert Comment

    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?
    LVL 21

    Accepted Solution

    Initally use mysql tuner to check your server configuration and follow the suggestions.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now