nixCraft

Hello,

need to save 1 run of mytop when server has load over..

mytop -b would do fine, but it displays only 80 or so columns.

how should be run in script file with more columns, and define terminal type?

tried something like:
#!/bin/sh
COLUMNS=160
mytop -b


but not working.

Regards,

This should be more helpful in debugging the problem:
MySQL :: MySQL 5.1 Reference Manual :: 5.2.5 The Slow Query Log
Also try to place the output in a file like this:
mytop -b > mytop.out 2>&1
and then less mytop.out

Hope it helps

I have used slow log query sometimes it helps.
the output to file is ok but I want to run it on event (when server load is over 8 ) along with ps.and when directing to file:
ESC[0mESC[33m 879478 zimxxx_ag localhost zimxxx_ag 1 Query SELECT * FROM `sa

it shows only part of the query, and would need the whole string to point where is the problem.