Francis T. O'Donovan

Francis T. O'Donovan

Data Science Manager at Hospital IQ – Planet discoverer, researcher, developer, geek.

(TIL) MySql: Show full query in process list

less than 1 minute read 

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.

Comments

You May Also Enjoy

Entropy Explained, With Sheep

less than 1 minute read

All Physics students learn the Second Law of Thermodynamics, that entropy always increases. But not all such students understand why this is. To do this, let...

Machine Learning for Product Managers

1 minute read

In a previous post, I discussed the importance of learning how to properly communicate Data Science to maximize the impact of your work. Product Managers are...

Communicating Data Science with impact

less than 1 minute read

One of the major differentiators between a new Data Scientist and a more experienced one is how the more senior practitioner spends a lot of time understandi...