How to test algorithm on huge data?

I have a table with 14 Million records and there are some business algorithm which I have implemented in MySQL store procedures. In future this file can be long like 30 Millions. Now I have implemented all the algorithm and I want to test these algorithm and I need to write test cases urgently. Which is the best tool to test huge data so that it test the algorithm in short time. Can I use spark to test the data because it perform well on huge data? So please guide me to choose the best way or tool for testing because it is my first time to write test cases.