Question for everybody: Can I do data analysis in mySql? If not what is the best software solution (R or sth else) to connect my database with? ...my database is ~1M records...