Affiliate Disclosure: Some links mentioned below are affiliate links, we may earn some amount if you make a purchase.
Summary Log Analyzer for MySQL tool is used by database administrators to evaluate clean information on what queries your application is really running. It helps to debug MySQL crashes by converting unreadable Log files into readable Tabular format for an in-depth analysis.
Stellar Log Analyzer for MySQL
$599
Overall
User Review
( votes)
- Track Records and Activities in MySQL
- Provide assistance to recover deleted records
- Suitable for Audits in MySQL logs
- Restore Objects from Binary, Redo and General Logs
- Allow to Preview Individual Records
- Save log files in MySQL CSV, HTML and XLS format
- Find Option to locate specific files
- Supports MYSQL 6.x, 5.x, 4.x, and 3.x
Features of MySQL Log Analyzer
Makes Logs in Readable Format
Stellar MySQL Log analyzer is the right fit for Database Forensic users as they can convert the unreadable data of log files in readable tabular format by which they can collect the information to inspect any suspicious activity in the database. The tool works in tough situations like accidental file deletion and system crashes.
Recover Objects from MySQL Logs
The Stellar Log Analyzer for MySQL scans all the logs of the database i.e Binary, Redo, and General logs. The software can automatically create a new database with all the items of MySQL.
Select Logs from Different Locations
There is no need to scan the Redo logs separately from Binary and General logs. Redo files are automatically created and save at the default location while the creation of Binary and General logs is done by user commands. The tool allows to manually select these logs for scanning at a time.
Preview Individual Records
When the software completes the scanning of the MySQL database, the log files are shown in the preview window with a tree-like structure. Users can browse for a particular transaction log and analyze specific data. The log analyzer shows each and every component of MySQL log files.
Find or Search Option
The software allows searching for a particular file or log. Select the transaction type Insert, Delete, and Update to find. The software lets you set the date range filter on log data and log transactions. Users can also look for ‘Other Transactions’ by MySQL.
Support Native JASON Type
As per the MySQL versions the Stellar MySQL Analyser tool supports native JSON types and functions for working with JSON values. The software provides the option to view MySQL versions in the tree-view structure and the tabular form shows the row count detail in each table.
Forensic Study Certification
The Stellar MySQL Log Analyzer is perfect for forensic users and analyzes the transactions. It tracks all the activities and certifies critical Forensic studies. The files can be stored in MySQL CSV, HTML, and XLS format.
Easy to Use Interface
The Stellar MySQL Analyzer tool uses a simple Graphical User Interface which enables users to work easily. the columns, buttons have a field that makes it undebatable and instructs another user.
Support and Compatibility
This software is compatible with the latest version of the Windows Operating system i.e Windows 10. It also supports earlier versions of Windows OS like Windows 8.1/ 8/ 7/ XP. Database supported by this software are MySQL 6.x, 5.x, 4.x, and 3.x
Frequently Asked Questions
Q. How to select General and Binary log files for analysis?
A: Follow the given steps
From the File menu click ‘Select’ option and database window will open
Click on Manual selection of database(s) to analyze and browse button will appear
Click on browse and locate the folder where these files are stored
Click on OK and the file will be loaded.
Q. How to Select Database Automatically in MySQL Log Analyzer?
A. In order to select the database automatically follow the steps:
1. Open Launch Stellar Log Analyzer for MySQL software.
2. Now Click on Select button from File > Menu to select Database .
3. By default, Analyze database(s) stored at the default location of MySQL option is selected. If not, select the same.
4. Click the Analyze button to start the process.
5. After the scanning is complete a list of My SQL Log files is shown
6. Now. Select the log you ant to analyze and proceed.
Q: How can I view transaction data?
A: From the file menu, click on View and then select ‘Data View Checkbox’. It is also available at the bottom of the interface.
Q: In what other formats I can save the files?
A: With Stellar MySQL Database Log Analyzer you can save the transaction logs as well as data in MySQL CSV, HTML and XLS format.
Q: Can I save the transaction log for the date range
A: Yes, while sorting the data in preview window select date range filter and then save the data.