WordPress.org

Ready to get started?Download WordPress

Forums

website loads sloooooow, MySql problem? (9 posts)

  1. kensav
    Member
    Posted 8 years ago #

    My website is loading very slow. Like 10 posts take 8 seconds to load and I think it's all coming from the database. I've deactivated some all plugins and gain a second or 2.

    Is there a way I can optimize my database for faster response?

    The sites as been up running WP for 2 years now with no clean up or optimization.

    THx

  2. Lester Chan
    Member
    Posted 8 years ago #

    Try optimizing your datatabase

  3. vkaryl
    Member
    Posted 8 years ago #

    You can usually do this through phpmyadmin....

    And you could consider installing one of the caching plugins - see Plugins

  4. kensav
    Member
    Posted 8 years ago #

    Thank you once again GamerZ. Can you tell me how to optimize mysql through mysqladmin?

    vkaryl, I'll checkout those plugins for caching. THanks.

  5. jonerik
    Member
    Posted 8 years ago #

    i got the same problem, how do i optimize the db?

  6. jonerik
    Member
    Posted 8 years ago #

    bump..

    Anyone with a command or something ?

  7. MichaelH
    Member
    Posted 8 years ago #

    A search found a nice optimization discussion here:
    http://weblogtoolscollection.com/archives/2005/04/06/optimize-your-database/

  8. niziol
    Member
    Posted 8 years ago #

    I will tell you, only if you promise never to bump again!

    In PHPMyAdmin, select the WordPress database, then at the bottom, there should be a "check all" link, clicking this will place a checkmark beside each table listed above (ie: all the tables in your WP database). Then, there is a drop-down box close by (says "with selected:", from that, you can select the optimize option and it will go at it.

    Good luck!

  9. jonerik
    Member
    Posted 8 years ago #

    Thanks for all help :-)

    And i will promis you this, i will NEVER bump again, ever :D

Topic Closed

This topic has been closed to new replies.

About this Topic