mysql> create index EzproxyAuthenticationEventAuthenticationEventorganisationName_indx on EzproxyAuthenticationEvent (organisationName); ERROR 1059 (42000): Identifier name 'EzproxyAuthenticationEventAuthenticationEventorganisationName_indx' is too long Also, what I'd done to break stuff: :%s/EzproxyAuthenticationEvent/EzpAuthEvent/ ... but on table names too so I'd not noticed that the old tables were still there (being used) without indexes. Will advise whether tables with indexes perform any better.