Can I create index on a table in a MySQL database while in use And if I can, any reason (performance/stability) why I shouldn't?
Note that if your table is using the InnoDB Plugin storage engine (which I highly recommend), if it's a secondary index (almost surely the case), you can still read from the table (i.e. it's non-blocking to SELECT statements).