It is really handy to have a tool that converts pstress thread logs into SQL file which can be directly executed against a running server.

This feature will be helpful in case we find a crash with pstress in single-thread mode. We would need to filter out SQLs from the pstress logs and want to execute it sequentially against a running server.

The objective is to create a script that filters out all the SQLs from the log file.

Usage:

./pstress_log_to_sql_converter.sh <pstress_thread.log>

output: crash_sql.sql