Reduce the length of lock_id

[gaoyan1998]

Linked issue: close #3012

[sunxiaojian]

@gaoyan1998 The length of the 'lock_id' field in distributed lock tables cannot be reduced on its own. The 'lock_id' is a concatenation of 'catalog_key', 'database_name', and 'table_name'.

[gaoyan1998]

@gaoyan1998 The length of the 'lock_id' field in distributed lock tables cannot be reduced on its own. The 'lock_id' is a concatenation of 'catalog_key', 'database_name', and 'table_name'.

@sunxiaojian Yes, but I think that even these fields together should not need 1000 so long,i cant understand, if there are concerns can also be set to 500 or 700, I think it is also enough, 1000 will lead to mysql table create problems, its exceeded the maximum index limit.

Of course this can be solved by modifying the mysql parameters, but this is a heavier operation, especially in a production environment.

Just a small suggestion when using it, there may be other things I'm not thinking about, and if it really doesn't work I can close this pr

[JingsongLi]

I think it is better to provide a option for this length.

[gaoyan1998]

I think it is better to provide a option for this length.

What kind of option？

[sunxiaojian]

I think it is better to provide a option for this length.

What kind of option？

refer: #3069