Skip to content

Instantly share code, notes, and snippets.

@duzenko

duzenko/gist:82a1d0b2a390e89a07a09d9c0212664c

Last active February 13, 2025 09:15
Show Gist options
  • Save duzenko/82a1d0b2a390e89a07a09d9c0212664c to your computer and use it in GitHub Desktop.
Save duzenko/82a1d0b2a390e89a07a09d9c0212664c to your computer and use it in GitHub Desktop.
Download ZIP
Analyze mysql dump content and import time
Raw
gistfile1.txt
pv <daily-07.sql.gz | gunzip | mysql -u staging -p DB_NAME -v | grep -oP 'CREATE TABLE .*?\(' --line-buffered | awk '{print "\n",$0}'
@duzenko
Copy link
Author

duzenko commented Feb 13, 2025

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment