search

joshp23 / YOURLS-Expiry

YOURLS plugin to define conditions under which links will expire - time and click limited links
GNU General Public License v3.0
35 stars 13 forks source link

Change table engine to InnoDB #25

Closed Redneck-prm closed 3 years ago

Redneck-prm commented 4 years ago

MyISAM on MySQL 8 has some performance issue on request: SQL: SELECT * FROM expiry WHERE BINARY keyword = '084BVoNTJR' (0.46792 s)

On MySQL 5.7 time is ~0.1 s On MySQL 8 and InnoDB ~0.1 s

vitalyzhakov commented 4 years ago

Hello, @joshp23 ! Can you merge it?

vitalyzhakov commented 4 years ago

@joshp23 ?