Skip to content

Instantly share code, notes, and snippets.

@studio3104
Created July 3, 2012 03:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save studio3104/3037416 to your computer and use it in GitHub Desktop.
Save studio3104/3037416 to your computer and use it in GitHub Desktop.
mysql.user JSON
{
"lock_time":0.00019899999999999999,
"explain1":{
"key_len":null,
"Extra":"Using where; Using join buffer",
"ref":null,
"table":"b",
"rows":"10",
"key":null,
"select_type":"SIMPLE",
"possible_keys":null,
"type":"ALL",
"id":"1"
},
"sql":"SET timestamp=1341286234; select * from user a,user b where a.user=b.user;",
"time":1341286234,
"host":"localhost",
"database":"mysql",
"explain0":{
"key_len":null,
"Extra":"",
"ref":null,
"table":"a",
"rows":"10",
"key":null,
"select_type":"SIMPLE",
"possible_keys":null,
"type":"ALL",
"id":"1"
},
"user":"ss[ss]",
"rows_sent":26,
"host_ip":"",
"query_time":0.000794,
"rows_examined":10
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment