December 2023
M T W T F S S
« Jul    
 123
45678910
11121314151617
18192021222324
25262728293031

Using MySQL 5.6 to find queries creating disk temporary tables

In my previous post, I’ve showed how to use Dtrace to find queries creating disk temporary tables (only available for OS with dtrace: solaris, freebsd, etc).

In MySQL 5.6 (which is not released yet, use “labs” version for now) we can use new performance_schema table events_statements_history or events_statements_history_long to find all performance metrics for […]

Using Dtrace to find queries creating disk temporary tables

Showed script with Dtrace to find queries creating disk temporary tables (Created_tmp_disk_tables) […]