
MySQL toolmaker Daniel Nichter provides a look at
10 must-have free and open source tools for MySQL. 'MySQL has attracted a vibrant community of developers who are putting out high-quality open source tools to help with the complexity, performance, and health of MySQL systems, most of which are available for free,' writes Nichter, who was named 2010 MySQL Community Member of the Year for his work on maatkit. From mydumper, to mk-query-digest, to stalk and collect, the list compiles tools to help back up MySQL data, increase performance, guard against data drift, and log pertinent troubleshooting data when problems arise, each of which is a valuable resource for anyone using MySQL, from a stand-alone instance to a multiple-node environment.
Member since:
2009-08-26
you should also revise your understanding of what a relational database is. It should never cross your mind to export the data out of the database to compare or do any analysis. I wouldn't do complex statistical models inside it but most analysis like means and modes, compares any set operations should be done with SQL or what ever database interface your using (unsql, gql orm, pg/*, whatever)