October 2009
M T W T F S S
« Sep   Jan »
 1234
567891011
12131415161718
19202122232425
262728293031  

Using Dtrace to find queries creating disk temporary tables

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

Reporting Queries with Sphinx

Reporting queries (I will use this term here) are the queries which summaries and groups data over the certain period of time. For example, in Social Network site we want to know how many messages have been sent for the given period of time, group by region and status (sent, received, etc), order by number […]