full tests for mysql ns