MySql: Show full query in process list
SHOW PROCESSLIST
only shows the first 100 characters of the running SQL query. To get the full SQL query, use:
SHOW FULL PROCESSLIST
Via SO.
Francis T. O'Donovan
Principal Data Scientist at TriNet – Planet discoverer, researcher, developer, geek.
You may also enjoy
Why You’re Not Getting Value from Your Data Science
1 minute read
If companies want to get value from their data, they need to focus on accelerating human understanding of data, scaling the number of modeling questions they...
List only untracked files
less than 1 minute read
Using ls-files
Pandas: Display DataFrames side by side
less than 1 minute read
Using html in a Jupyter Notebook
Pandas: Transforming two DataFrame columns into a dictionary
less than 1 minute read
Using the zip command
Leave a comment