website loads sloooooow, MySql problem?

  • kensav

    (@kensav)


    19 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

Viewing 8 replies - 1 through 8 (of 8 total)

  • Try optimizing your datatabase

    vkaryl

    (@vkaryl)

    You can usually do this through phpmyadmin….

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

    Thread Starter kensav

    (@kensav)

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

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

    jonerik

    (@jonerik)

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

    jonerik

    (@jonerik)

    bump..

    Anyone with a command or something ?

    MichaelH

    (@michaelh)

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

    niziol

    (@niziol)

    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!

    jonerik

    (@jonerik)

    Thanks for all help ??

    And i will promis you this, i will NEVER bump again, ever ??

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘website loads sloooooow, MySql problem?’ is closed to new replies.