Skip Navigation

[Resolved] Do I need to add a index for database?

This thread is resolved. Here is a description of the problem and solution.

Problem:

I also want to confirm if I need to add an index to the wordpress database.

Solution:

Yes, you are right, the WordPress database tables are already indexed, see wordpress document:
https://codex.wordpress.org/Database_Description

So you don't need to setup index to WordPress database tables

Relevant Documentation:

https://codex.wordpress.org/Database_Description

This support ticket is created 6 years, 5 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Our next available supporter will start replying to tickets in about 1.95 hours from now. Thank you for your understanding.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

This topic contains 2 replies, has 2 voices.

Last updated by Jeffrey 6 years, 4 months ago.

Assisted by: Luo Yang.

Author
Posts
#919059

Some slow queries always broke down my host, CPU is very high, Ram is very high as well. but the tables are not too many, the size of database is the only 160M, I think I may need to hire a database expert to optimize the databse server for me. before I do, I also want to confirm if I need to add an index to the database because I read some articles say, The WordPress database is already indexed. so I want to learn some opinions from you guys if I need to index database as well? Thank you!

#919168

Hello,

Yes, you are right, the WordPress database tables are already indexed, see wordpress document:
https://codex.wordpress.org/Database_Description

So you don't need to setup index to WordPress database tables

#920543

Got it, Thank you so much for the information! 🙂