comment on

I patched and recompiled Term::ReadKey so that it no longer was a CPU hog on FreeBSD so that we could use 'mytop' more often to monitor the DB. Then I reworked it and renamed it as sqltop and taught it how to run as a daemon, logging long-running queries and even killing ones that ran *too* long.

Hi, tye -- Unfortunately we couldn't make head or tail of your chatbox tip, "I just disabled the "compatability test", tim (FreeBSD is certainly compatible even though it fails that test)".

We're running 5.005_03 built for i386-freebsd on FreeBSD 4.9, and mytop-1.4 from freebsd ports. We tried ReadKey-2.21 and ReadKey-2.30, but runing mytop uses loads of system cpu:

PID USERNAME PRI NICE  SIZE    RES STATE  C   TIME   WCPU CPU COMMAND
12587 diamondd  65  10  5660K  4608K CPU0   0   0:13 96.87%           
+  46.34% perl
CPU states:  0.0% user,  3.5% nice, 46.5% system,  0.6%             in
+terrupt, 49.4% idle

ktrace just shows
12587 perl     CALL  read(0,0x814e000,0x1000)
12587 perl     RET   read -1 errno 35 Resource temporarily  unavailabl
+e
12587 perl     CALL  gettimeofday(0xbfbff9d0,0)
12587 perl     RET   gettimeofday 0
12587 perl     CALL  read(0,0x814e000,0x1000)
12587 perl     RET   read -1 errno 35 Resource temporarily unavailable
[download]

Google found this post, but hasn't given us any clues to the patch. If you'd be willing to share it, and allow us (on your behalf, of course) to add it to a patch submitted to update /usr/ports/devel/p5-Term-ReadKey from 2.21, we'd really appreciate it.

I've you'd like to contact me via email I can be reached at tim.hunter atsign eircom dot net. Thanks!

In reply to Re^4: Web servers get hardware upgrade (PM hw) by tim
in thread Web servers get hardware upgrade by tye

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Pathologically Eclectic Rubbish Lister
	PerlMonks