Q

Finding an OS solution for parsing MySQL databases

MySQL expert Mike Hillyer recommends two open source programs that deal with the export, scanning, searching and sorting od data.

Our company is trying to find an open source solution that we could use to better parse our MySQL databases. We would like to be able to scan, search and sort log files down to a single event using keyword search function. Lastly we would like the ability to export this data into Excel format or a comparable format. What would you recommend?

MySQL Administrator does provide functionality for searching the log files for keywords and saving to a text format which could be imported into Excel.

You may also find the Practical Query Analyzer project to be of use. It is a multi-database query log analyzer that can identify trends in your logfiles.

This was first published in April 2006

Dig deeper on Open source databases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close