Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2002
    Location
    long beach
    Posts
    207

    Please help mysql sluggish

    Hello,

    The mysql on our shared servers is very sluggish, does anyone know how to improve the speed.

    Anyone feel like giving a step by step on making mysql work better for high bandwidth high volumne accounts.

    I would be more then happy to compinsate if someone could help.

    Thank you very much for any help,

    Charles

  2. #2
    More ram, SCSI Hard Drives, Good Optimization, have a mysql server only be that a mysql server not multiple such as mysql, httpd, etc. That should improve you're performance .

  3. #3
    Oh yea, and another note: wrong place to post it should be in the Technical & Security Issues area.

  4. #4
    Join Date
    Jun 2002
    Location
    long beach
    Posts
    207
    Sorry, you can delete if you like.

    Thank you,

    Charles

  5. #5
    Join Date
    Aug 2002
    Location
    Chandler, Arizona
    Posts
    2,564
    heres some other things you can do...
    always close a mysql connection after your done using it (taking a guess this is a script)....try to do less queries...and remove and useless crap out of your db...
    -Robert Norton
    www.SophMedia.com

  6. #6
    Join Date
    Jul 2002
    Posts
    3,729
    ...and read up on optimizing your databases by setting size limits on tables where you can and using the most efficient table types. That can help a lot.

  7. #7
    Join Date
    May 2001
    Location
    Dayton, Ohio
    Posts
    4,962
    Make sure your my.cnf is also optimized...

    Helps loads..

    But to help more, we need to know more of your server specs
    -Mat Sumpter
    Director, Product Engagement
    Penton Media

  8. #8
    Join Date
    Aug 2002
    Location
    Chandler, Arizona
    Posts
    2,564
    like your ip password...jk how fast is your server though? what os?
    -Robert Norton
    www.SophMedia.com

  9. #9
    Join Date
    Jun 2002
    Location
    long beach
    Posts
    207
    Make sure your my.cnf is also optimized...
    Do you mind telling me where this is located I could only find mysql in the log directories. There where small.cnf and big.cnf Thanks,


    like your ip password...jk how fast is your server though? what os?
    Thanks for asking it's a p4 2 gig processor with 1 gig of ram running Linux and cpanel. It has about 150 shared accounts all running different mysql database's I think I would like to set the maximum allowance for every database, like a server wide setting to tell mysql to go as fast as it wants for every account.

    Thanks again,

    Charles

Posting Permissions

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