View Image

Stellar Log Analyzer for MySQL analyzes all the transactions, including the Insert, Delete, and Update operations performed on the server. After completing the analysis, the tool allows the user to select and scan the Redo, Binary, and General Log files, displaying a preview of the log file data, including the databases and tables, in a Tree format. The software allows sorting the information as per the Transaction Type, Transaction Name, Table Name, and Query. The user can view granular details of any transaction by clicking the tables listed in the left pane. The software provides a search bar to locate specific items displayed in the Tree view. Further, Match case and Match whole word options are available to narrow down the search. The tool can save the log file data as Log Record and Log Transactions. It can save the Log Record to a MySQL database or in CSV, HTML, and XLS file formats. For Log Transactions, the tool supports CSV, HTML, and XLS file formats. The user can also choose the date range to save the data for a specific duration. Stellar Log Analyzer for MySQL allows the user to save the log reports of the analysis tasks, accessible via the Log Report option at the bottom of the user interface. The software provides sorted tables in tree-view and the total row count details in each table across all MySQL versions. The software supports native JSON type to allow working with the JSON values associated with the latest version of MySQL Server.