All pastes #2083237 Raw Edit

Miscellany

public text v1 · immutable
#2083237 ·published 2011-09-27 10:42 UTC
rendered paste body

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.