zhukovaskychina/xmysql-server — reverse-engineered prompt

I want this turned into a usable single node MySQL compatible database server in Go, not just a demo. Please finish the core path so I can start it with the existing config, connect from a normal MySQL client or the included JDBC tests, run basic SQL with tables, indexes, transactions, savepoints, prepared statements, and joins, and have the server behave reliably.

Focus on closing the gap between the current prototype and a cautious P0 gray rollout. That means tightening crash recovery with redo and undo, checking concurrency and lock behavior, making logs and simple metrics good enough to troubleshoot, and adding whatever tests and doc updates are needed so the current status is clear and reproducible. Keep it single machine only, stick with the repo’s current approach, and make the build, test, and startup flow straightforward on the existing scripts and config. If anything is unclear, use the roadmap docs in the repo and look up current MySQL protocol details online if needed.