Magento: high MySQL load at_is_active.value_id > 0

High MySQL load, queries like

SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_a

run:

php -f shell/indexer.php reindexall –all