search

osheroff / mmtop

Mysql Monitor that can watch multiple hosts
17 stars 6 forks source link

Don't crash when explaining an insert #1

Open osheroff opened 11 years ago

osheroff commented 11 years ago

explain 3 INSERT INTO tag_scores_pending (account_id, tag_name, score) SELECT account_id, tag_name, COUNT(*) AS score FROM taggings FORCE INDEX (index_taggings_on_account_id_and_created_at) WHERE created_at > '2012-10-06 00:00:00 UTC' AND account_id BETWEEN 9500 AND 10000 GROUP BY account_id, tag_name Got error number 1064 /data/zendesk_scripts/releases/beta/vendor/bundle/ruby/1.8/gems/mmtop-0.9.6/lib/mmtop/host.rb:39:in `query': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO tag_scores_pending (account_id, tag_name, score) SELECT account_id, ' at line 1 (Mysql2::Error) from