Add support for Skeema through `innodb_adaptive_hash_index` global system variable

[joehorsnell]

Skeema, the declarative SQL-based schema management tool for MySQL/MariaDB, is currently incompatible with Dolt.

This is because in hydrateVars, it tries to read innodb_adaptive_hash_index, which fails, marking the connection as invalid.

My understanding (based on Claude research) is that it would be safe to implement this (default to on), matching other InnoDB settings that don't apply to Dolt.

Would you accept a PR to fix this? It seems an upstream fix in https://github.com/dolthub/go-mysql-server/blob/f5b97c4d91792984518b86e17f0fcee6a6a4f506/sql/variables/system_variables.go#L219 to add innodb_adaptive_hash_index there would be the correct fix?

Thanks.

[elianddb]

Hi @joehorsnell, feel free to experiment with adding this MySQL-specific system variable in go-mysql-server. If the fix does work for you, I'd be more than happy to take a look at your implementation and review.

[joehorsnell]

Hi @joehorsnell, feel free to experiment with adding this MySQL-specific system variable in go-mysql-server. If the fix does work for you, I'd be more than happy to take a look at your implementation and review.

Thanks for the response @elianddb - I'll try and take a look at this some time this week.