Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2007
    Posts
    360

    I have a big forum, and i am guessing mysql is slowing it down

    I have a big forum, and i am guessing mysql is slowing it down

    I think mysql is slowing down my forum load time, as queries probably take time.

    How can i speed up mysql? Any tips?

    I dont know much about server management...so any help appreciated.

    Thanks.

  2. #2
    Join Date
    Feb 2008
    Location
    Houston, Texas, USA
    Posts
    2,955
    Is your server managed by the provider? If that's the case, you might have an easy way out. Otherwise, how familiar are you with the Linux shell (assuming you're running MySQL on Linux).

    Regards
    UNIXy - Fully Managed Servers and Clusters - Established in 2006
    [ cPanel Varnish Nginx Plugin ] - Enhance LiteSpeed and Apache Performance
    www.unixy.net - Los Angeles | Houston | Atlanta | Rotterdam
    Love to help pro bono (time permitting). joe > unixy.net

  3. #3
    Join Date
    Jan 2007
    Posts
    360
    Not very fimiliar...and it is not managed server.

    Any basic things i can do to see some improvements?

    My server load, memory, everything is good...but i am pretty sure its the mysql that is slowing it down.

  4. #4
    'mysqladmin processlist' will show you the queries, which can help you to find the reason for slow performance.

    You can enable the query cache in MySQL which will help to make it perform faster.
    Windows VPS | Linux Hybrid Server | 99.9% Uptime
    http://www.odishahosting.com ( USA DC)
    http://www.odishahosting.in ( INDIA DC)

  5. #5
    Join Date
    Feb 2008
    Location
    Houston, Texas, USA
    Posts
    2,955
    You'll need to be somewhat familiar with the console and tools. Otherwise, you're asking for trouble. There are some third party management firms that can take care of these one offs for you. I can't recommend a fix without looking at a SQL process list dump, process level resource usage, and server accounting report.

    Regards
    UNIXy - Fully Managed Servers and Clusters - Established in 2006
    [ cPanel Varnish Nginx Plugin ] - Enhance LiteSpeed and Apache Performance
    www.unixy.net - Los Angeles | Houston | Atlanta | Rotterdam
    Love to help pro bono (time permitting). joe > unixy.net

Similar Threads

  1. PHP - I'm guessing simple solution
    By Jeanco in forum Programming Discussion
    Replies: 4
    Last Post: 03-26-2005, 03:33 PM
  2. MySQL processes slowing growing in size
    By beet in forum Hosting Security and Technology
    Replies: 8
    Last Post: 06-26-2004, 12:11 AM
  3. Guessing Game
    By Gem Hexen in forum Web Hosting Lounge
    Replies: 0
    Last Post: 07-18-2002, 04:32 AM

Posting Permissions

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