Results 1 to 3 of 3

Thread: MYSQL slowness

  1. #1
    Join Date
    Aug 2004
    Posts
    1

    Smile Unanswered: MYSQL slowness

    Hi,

    I am using MYSQL as back end with PHP CGI-version. I suppose we have around 300 users visiting site every day. At the administration side some times querying database is taking more time and some times it is very fast.I couldn't find what is the problem with the connection. I am using normal mysql_connect(). we are hosted on shared server, would this be any problem for the slowness.

    Can anybody suggest how to fine tune MYSQL for the best results.

    Any help I would be gratefull to you.

    Thanks

  2. #2
    Join Date
    Aug 2004
    Location
    Vancouver BC, Canada
    Posts
    1
    From what i've seen on other sites is that the user connects to the database more than once, since it isnt needed being that you are already connected.
    I've even seen some people connect to the same db around 10 times, it just caused a really slow load time for users.

    Other than that maybey someone else on the host is running scripts or is just really large and is causing your side to be slow.

  3. #3
    Join Date
    Aug 2004
    Posts
    1

    Arrow Check these

    Hi,

    I found these two places to be helpful in troubleshooting slowness:

    http://dev.mysql.com/doc/mysql/en/Se...variables.html
    and
    http://dev.mysql.com/doc/mysql/en/Se...variables.html

    another thing you might check out is your indexes...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •