added unit tests for kept spike
started to add mysql logging