5 Queries with over 10,000 ms response times and sample count is over 1000 - within a 30 minute window

[Thomas Kazarian]

Unsure if it's just the machine setup (1 single machine running a crawler/parser/db/webserver/image serving) or it's that these queries can be further optimized...and I'm still using MyISAM.

site: lionseek.com

Please take a look and let me know your thoughts on the top offending queries.

Thanks in advance!


SELECT item.* FROM `item` WHERE item.item_type_id = ? AND ( item.has_photo = ? OR item.has_photo = ? ) ORDER BY normalized_time DESC LIMIT ?,?

SELECT * FROM `item` WHERE item_type_id = ? AND (price BETWEEN ? AND ?) AND brand_id = ? ORDER BY item_id DESC LIMIT ?

SELECT item.* FROM `item` WHERE item.brand_id = ? AND item.item_type_id = ? AND ( item.has_photo = ? OR item.has_photo = ? ) ORDER BY normalized_time DESC LIMIT ?,?

SELECT COUNT(*) FROM `item` WHERE item.item_type_id = ? AND ( item.has_photo = ? OR item.has_photo = ? )

UPDATE `item` SET `photo_file` = ?, `photo_type` = ?, `has_photo` = ? WHERE `item_id` = ?



Edited 1 time(s). Last edit at 07/18/2013 04:41PM by Thomas Kazarian.