Hi
I want to search in file such that

suppose file A which has keyword # Query_time: 12.080983
Query_time: 5.233292
Query_time: 5.298892

Any command to search top 10 Query_time

Can you show us the code you have so far, and tell us how it misbehaves?

Regards

It is slow-log file I have to find highest time taken on the basis of query time

so any command that show top n query time

file is as follow

# Query_time: 2.562404 Lock_time: 0.000018 Rows_sent: 509 Rows_examined: 509
use testanalytics;
SET timestamp=1238053872;
SELECT * FROM `testanalytics`.`anlytcs_mt_dt`;

# Query_time: 12.080983 Lock_time: 0.000034 Rows_sent: 1270 Rows_examined: 2540
SET timestamp=1238116828;
SELECT * FROM `anlytcs_mt_dt`

ORDER BY `anl_evnt_id` DESC;

# User@Host: root[root] @ [10.157.205.10]
# Query_time: 18.391643 Lock_time: 0.000017 Rows_sent: 22296 Rows_examined: 22296
use test_analytics;
SET timestamp=1238455961;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `test_analytics`.`dim_tm`;

# Query_time: 17.690604 Lock_time: 0.000018 Rows_sent: 22296 Rows_examined: 22296
use test_analytics;
SET timestamp=1238461385;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `test_analytics`.`dim_tm`;

any command for result top n Query_time:

Query_time: 2.562404

In this field, is there any space, if space is there , u can cut the exact field through
awk command like awk '{print $field name}' <file>

After that u can get the first 10 Query_time by head command.

you want it along with the query or only top 10 time??

only top 10 time

---------- Post updated at 06:38 AM ---------- Previous update was at 05:59 AM ----------

I got command

grep "Query_time" /home/slow-log-new.log | sort -n -k3 -r > /tmp/queries_sorted_by_time &