removing mysql optimization

these break mysql 5.6.  The proposed patch is awful and I probably break tests, but it's worth starting this discussion in PR.