CODE EXAMPLE FOR SQL

how to add a index to live table mysql

ALTER TABLE `my_table`  
ADD INDEX `indexname` (`created_at`)
,LOCK=NONE; #add this line to query for live stuff