MySQL on localhost (5.5.54-cll) up 1 07:17:54 [11:04:42]
Queries: 30.1M qps: 280 Slow: 89.2k Se/In/Up/De(%): 75/03/10/01
qps now: 277 Slow qps: 0.2 Threads: 251 ( 6/ 1) 68/04/14/01
Cache Hits: 10.1M Hits/s: 93.7 Hits now: 73.4 Ratio: 44.6% Ratio now: 39.1%
Key Efficiency: 93.5% Bps in/out: 42.7k/ 3.0M Now in/out: 48.8k/ 4.3M
Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
1342362 myinstar_ localhost myinstar_r 0 Sleep
1352004 myinstar_ localhost myinstar_r 0 Sleep
1381920 myinstar_ localhost myinstar_r 0 Sleep
1387545 myinstar_ localhost myinstar_r 0 Sleep
1389034 myinstar_ localhost myinstar_r 0 Sleep
1389950 myinstar_ localhost myinstar_r 0 Sleep
1390683 myinstar_ localhost myinstar_r 0 Sleep
1392125 myinstar_ localhost myinstar_r 0 Sleep
1392608 myinstar_ localhost myinstar_r 0 Sleep
1393076 myinstar_ localhost myinstar_r 0 Sleep
1393302 myinstar_ localhost myinstar_r 0 Sleep
1393303 myinstar_ localhost myinstar_r 0 Sleep
1393972 myinstar_ localhost myinstar_r 0 Sleep
1394098 myinstar_ localhost myinstar_r 0 Sleep
1394374 myinstar_ localhost myinstar_r 0 Sleep
1394477 myinstar_ localhost myinstar_r 0 Sleep
1394627 myinstar_ localhost myinstar_r 0 Sleep
1394628 myinstar_ localhost myinstar_r 0 Sleep
1394640 myinstar_ localhost myinstar_r 0 Sleep
1394645 myinstar_ localhost myinstar_r 0 Sleep
1394646 myinstar_ localhost myinstar_r 0 Sleep
1394653 myinstar_ localhost myinstar_r 0 Sleep
1394672 root localhost mysql 0 Query show full processlist
1394723 myinstar_ localhost myinstar_r 0 Sleep
1394729 myinstar_ localhost myinstar_r 0 Sleep
1394738 myinstar_ localhost myinstar_r 0 Sleep
1394739 myinstar_ localhost myinstar_r 0 Query select count(1) as counter FROM status_869 where DATE_FORMAT(`date`, '%Y-
1394744 myinstar_ localhost myinstar_r 0 Sleep
1394745 myinstar_ localhost myinstar_r 0 Sleep
1394754 myinstar_ localhost myinstar_r 0 Sleep
1394755 myinstar_ localhost myinstar_r 0 Sleep
1394796 myinstar_ localhost myinstar_r 0 Sleep
1394835 myinstar_ localhost myinstar_r 0 Sleep
|
