G2A Many GEOs
SHARE
TWEET

My tail -n 100 /var/log/mysql/slow.log

a guest Jan 3rd, 2016 5 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2.     # User@Host: cphulkd[cphulkd] @ localhost []
  3.     # Thread_id: 33113  Schema: cphulkd  QC_hit: No
  4.     # Query_time: 0.003485  Lock_time: 0.000067  Rows_sent: 285  Rows_examined: 2835
  5.     SET timestamp=1451849801;
  6.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  7.     # Time: 160103 21:36:43
  8.     # User@Host: cphulkd[cphulkd] @ localhost []
  9.     # Thread_id: 33114  Schema: cphulkd  QC_hit: No
  10.     # Query_time: 0.006589  Lock_time: 0.000073  Rows_sent: 1220  Rows_examined: 3771
  11.     SET timestamp=1451849803;
  12.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  13.     # User@Host: cphulkd[cphulkd] @ localhost []
  14.     # Thread_id: 33115  Schema: cphulkd  QC_hit: No
  15.     # Query_time: 0.004768  Lock_time: 0.000092  Rows_sent: 286  Rows_examined: 2838
  16.     SET timestamp=1451849803;
  17.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  18.     # Time: 160103 21:36:46
  19.     # User@Host: cphulkd[cphulkd] @ localhost []
  20.     # Thread_id: 33116  Schema: cphulkd  QC_hit: No
  21.     # Query_time: 0.004408  Lock_time: 0.000070  Rows_sent: 287  Rows_examined: 2840
  22.     SET timestamp=1451849806;
  23.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  24.     # Time: 160103 21:36:48
  25.     # User@Host: cphulkd[cphulkd] @ localhost []
  26.     # Thread_id: 33117  Schema: cphulkd  QC_hit: No
  27.     # Query_time: 0.004475  Lock_time: 0.000059  Rows_sent: 1221  Rows_examined: 3775
  28.     SET timestamp=1451849808;
  29.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  30.     # Time: 160103 21:36:49
  31.     # User@Host: cphulkd[cphulkd] @ localhost []
  32.     # Thread_id: 33118  Schema: cphulkd  QC_hit: No
  33.     # Query_time: 0.005608  Lock_time: 0.000085  Rows_sent: 288  Rows_examined: 2843
  34.     SET timestamp=1451849809;
  35.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  36.     # Time: 160103 21:36:52
  37.     # User@Host: cphulkd[cphulkd] @ localhost []
  38.     # Thread_id: 33119  Schema: cphulkd  QC_hit: No
  39.     # Query_time: 0.006510  Lock_time: 0.000069  Rows_sent: 1222  Rows_examined: 3778
  40.     SET timestamp=1451849812;
  41.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  42.     # Time: 160103 21:36:56
  43.     # User@Host: cphulkd[cphulkd] @ localhost []
  44.     # Thread_id: 33120  Schema: cphulkd  QC_hit: No
  45.     # Query_time: 0.002198  Lock_time: 0.000058  Rows_sent: 289  Rows_examined: 2846
  46.     SET timestamp=1451849816;
  47.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  48.     # Time: 160103 21:36:57
  49.     # User@Host: cphulkd[cphulkd] @ localhost []
  50.     # Thread_id: 33121  Schema: cphulkd  QC_hit: No
  51.     # Query_time: 0.004659  Lock_time: 0.000071  Rows_sent: 1223  Rows_examined: 3781
  52.     SET timestamp=1451849817;
  53.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  54.     # Time: 160103 21:36:59
  55.     # User@Host: cphulkd[cphulkd] @ localhost []
  56.     # Thread_id: 33122  Schema: cphulkd  QC_hit: No
  57.     # Query_time: 0.004016  Lock_time: 0.000068  Rows_sent: 290  Rows_examined: 2849
  58.     SET timestamp=1451849819;
  59.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  60.     # Time: 160103 21:37:01
  61.     # User@Host: cphulkd[cphulkd] @ localhost []
  62.     # Thread_id: 33123  Schema: cphulkd  QC_hit: No
  63.     # Query_time: 0.004466  Lock_time: 0.000108  Rows_sent: 291  Rows_examined: 2851
  64.     SET timestamp=1451849821;
  65.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  66.     # Time: 160103 21:37:02
  67.     # User@Host: cphulkd[cphulkd] @ localhost []
  68.     # Thread_id: 33124  Schema: cphulkd  QC_hit: No
  69.     # Query_time: 0.008115  Lock_time: 0.000072  Rows_sent: 1224  Rows_examined: 3785
  70.     SET timestamp=1451849822;
  71.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  72.     # Time: 160103 21:37:05
  73.     # User@Host: cphulkd[cphulkd] @ localhost []
  74.     # Thread_id: 33125  Schema: cphulkd  QC_hit: No
  75.     # Query_time: 0.004939  Lock_time: 0.000081  Rows_sent: 292  Rows_examined: 2854
  76.     SET timestamp=1451849825;
  77.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  78.     # Time: 160103 21:37:07
  79.     # User@Host: cphulkd[cphulkd] @ localhost []
  80.     # Thread_id: 33126  Schema: cphulkd  QC_hit: No
  81.     # Query_time: 0.006385  Lock_time: 0.000074  Rows_sent: 1225  Rows_examined: 3788
  82.     SET timestamp=1451849827;
  83.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  84.     # Time: 160103 21:37:08
  85.     # User@Host: cphulkd[cphulkd] @ localhost []
  86.     # Thread_id: 33127  Schema: cphulkd  QC_hit: No
  87.     # Query_time: 0.002580  Lock_time: 0.000055  Rows_sent: 293  Rows_examined: 2857
  88.     SET timestamp=1451849828;
  89.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  90.     # Time: 160103 21:37:11
  91.     # User@Host: cphulkd[cphulkd] @ localhost []
  92.     # Thread_id: 33128  Schema: cphulkd  QC_hit: No
  93.     # Query_time: 0.004067  Lock_time: 0.000073  Rows_sent: 294  Rows_examined: 2859
  94.     SET timestamp=1451849831;
  95.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
  96.     # Time: 160103 21:37:12
  97.     # User@Host: cphulkd[cphulkd] @ localhost []
  98.     # Thread_id: 33129  Schema: cphulkd  QC_hit: No
  99.     # Query_time: 0.005923  Lock_time: 0.000069  Rows_sent: 1226  Rows_examined: 3792
  100.     SET timestamp=1451849832;
  101.     SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
RAW Paste Data
Ledger Nano X - The secure hardware wallet
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top