Re:My experience with WPEngine
by MattRogish on Wednesday October 24, 2012 @12:13PM
(#4693562)
Partition? Why won't a simple DBMS index help?
[ Parent
| on HN ]
Re:My experience with WPEngine
by jacques_chester on Wednesday October 24, 2012 @12:19PM
(#4693593)
From memory, the relevant fields are already indexed.
I'm guessing the recent comments widget is just doing an ORDER BY date DESC LIMIT 10 or something? With an index on date, I don't see how this could be slow.
How long does the query take?
How many rows do you have?
Appears that he has 188590 rows. It definitely sounds like a configuration issue. Maybe the mysql table cache might be bogged down or the query cache is full or malfunctioning. Could be a lot of things.
Sorting that into a temp table, and caching that in memory would be really fast on a server with reasonable RAM and proper indexes.
Re:My experience with WPEngine
by jacques_chester on Wednesday October 24, 2012 @08:56PM
(#4695841)
InnoDB helps a lot. MyISAM likes to perform joins on disk if a table has a TEXT field ... even if you're not using that field in your query.