[SOLVED] MySQL Major server slow down

[fenway]

# Time: 071024 23:44:40

# Query_time: 67  Lock_time: 0  Rows_sent: 100  Rows_examined: 489115
use bsdb;
SELECT b.title, b.title_html, b.authors, b.description, b.book_id, b.cover_id, b.publication_date, b.avg_rating AS rating
			FROM books b
			WHERE 1 GROUP BY book_id ORDER BY copies_effective DESC, publication_date DESC  LIMIT 0, 100;

 

Why would this need to examine all 489K rows if I just want to return 100?

Because of the ordering...