On Wed, Aug 27, 2003 at 11:17:36AM -0400, Asif Iqbal wrote: > > Hi Jeremy Zawodny (and all) > > I am using your mytop and this is what I am seeing > > MySQL on localhost (4.0.13-standard-log) > up 0+10:48:22 [11:14:37] > Queries: 85.6k qps: 2 Slow: 207.0 Se/In/Up/De(%): 86/05/05/02 > qps now: 2 Slow qps: 0.0 Threads: 11 ( 2/ 4) 00/00/00/00 > Cache Hits: 37.6k Hits/s: 1.0 Hits now: 0.0 Ratio: 51.0% Ratio now: 0.0% > Key Efficiency: 99.2% Bps in/out: 727.8/ 1.5k Now in/out: 40.8/ 4.2k > > > It seems my mysql is little slow. I have 4 450Mhz with 4 gig RAM and I am using > my-huge.cnf. I don't have any secondary server. > > Wonder if you or anyone else could suggest any place for improvement.
Sorry for the late reply. Have you enabled the slow query log yet? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 159,201,504 queries (438/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]