Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


create an index on a huge mysql production table without table locking using -'mysql,indexing,production,alter-table,table-locking'


create an index on a huge mysql production table without table locking  using -'mysql,indexing,production,alter-table,table-locking'

I need to create an index on a ~5M rows mysql table. It is a production table, i fear a complete block of everything if I run a CREATE INDEX statement...

Is there a way to create that index without blocking inserts and selects ?

Just wondering I have not to stop, create index and restart my system!

Thank you :)
    

asked Sep 7, 2015 by rajesh
0 votes
1 view



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...