WordPress.org

1. rodsherwin
   Member
   Posted 3 years ago #

   I would like to optimise the wordpress database by adding some database indexes. I have very little experience with creating indexes and would like an hints on how I go about identify what I should create an index for?

   Thanks,
   Rod

2. MichaelH
   Volunteer
   Posted 3 years ago #

   The developers have done a pretty good job of indexing files where appropriate.

   I guess the question to answer is "What I am trying to achieve by adding more indexes?"

3. rodsherwin
   Member
   Posted 3 years ago #

   I'm getting database timeouts from slow queries and the host suggest creating indexes for some of the more common queries.

   The MySQL Runtime Information report shows the follow items in read:
   Handler_read_rnd 25 k
   The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.

   Handler_read_rnd_next 719 k
   The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.

   Select_full_join 761
   The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.

   All of these suggest that creating some indexes would improve things considerably.

Topic Closed

This topic has been closed to new replies.