pastebin - collaborative debugging

pastebin is a collaborative debugging tool allowing you to share and modify code snippets while chatting on IRC, IM or a message board.

This site is developed to XHTML and CSS2 W3C standards. If you see this paragraph, your browser does not support those standards and you need to upgrade. Visit WaSP for a variety of options.

pastebin private pastebin - collaborative debugging tool What's a private pastebin?

Posted by frymaster on Tue 2nd Apr 23:15
download | new post

  1. mysql> EXPLAIN extended SELECT x,DATE, replaced, type, data, playername, signtext, itemtype, itemamount, itemdata FROM `lb-NE-2013` INNER JOIN `lb-players` USING (playerid) LEFT JOIN `lb-NE-2013-SIGN` USING (id) LEFT JOIN `lb-NE-2013-chest` USING (id) WHERE (x = -2308 or x= -2307) AND y = '43' AND z = '-679' ORDER BY DATE DESC, id DESC;
  2. +----+-------------+------------------+--------+-----------------+---------+---------+---------------------------------------------+------+----------+-----------------------------+
  3. | id | select_type | table            | type   | possible_keys   | key     | key_len | ref                                         | rows | filtered | Extra                       |
  4. +----+-------------+------------------+--------+-----------------+---------+---------+---------------------------------------------+------+----------+-----------------------------+
  5. 1 | SIMPLE      | lb-NE-2013       | range  | coords,playerid | coords  | 8       | NULL                                        |  156 |   100.00 | USING WHERE; USING filesort |
  6. 1 | SIMPLE      | lb-players       | eq_ref | PRIMARY         | PRIMARY | 2       | minecraft_logblock_2013.lb-NE-2013.playerid |    1 |   100.00 |                             |
  7. 1 | SIMPLE      | lb-NE-2013-SIGN  | eq_ref | PRIMARY         | PRIMARY | 4       | minecraft_logblock_2013.lb-NE-2013.id       |    1 |   100.00 |                             |
  8. 1 | SIMPLE      | lb-NE-2013-chest | eq_ref | PRIMARY         | PRIMARY | 4       | minecraft_logblock_2013.lb-NE-2013.id       |    1 |   100.00 |                             |
  9. +----+-------------+------------------+--------+-----------------+---------+---------+---------------------------------------------+------+----------+-----------------------------+
  10. 4 rows in SET, 1 warning (0.01 sec)
  11.  
  12.  
  13.  
  14. mysql> EXPLAIN extended SELECT x,DATE, replaced, type, data, playername, signtext, itemtype, itemamount, itemdata FROM `lb-NE-2013` INNER JOIN `lb-players` USING (playerid) LEFT JOIN `lb-NE-2013-SIGN` USING (id) LEFT JOIN `lb-NE-2013-chest` USING (id) WHERE x IN (-2308,-2307) AND y = '43' AND z = '-679' ORDER BY DATE DESC, id DESC;
  15. +----+-------------+------------------+--------+-----------------+---------+---------+---------------------------------------------+------+----------+-----------------------------+
  16. | id | select_type | table            | type   | possible_keys   | key     | key_len | ref                                         | rows | filtered | Extra                       |
  17. +----+-------------+------------------+--------+-----------------+---------+---------+---------------------------------------------+------+----------+-----------------------------+
  18. 1 | SIMPLE      | lb-NE-2013       | range  | coords,playerid | coords  | 8       | NULL                                        |  156 |   100.00 | USING WHERE; USING filesort |
  19. 1 | SIMPLE      | lb-players       | eq_ref | PRIMARY         | PRIMARY | 2       | minecraft_logblock_2013.lb-NE-2013.playerid |    1 |   100.00 |                             |
  20. 1 | SIMPLE      | lb-NE-2013-SIGN  | eq_ref | PRIMARY         | PRIMARY | 4       | minecraft_logblock_2013.lb-NE-2013.id       |    1 |   100.00 |                             |
  21. 1 | SIMPLE      | lb-NE-2013-chest | eq_ref | PRIMARY         | PRIMARY | 4       | minecraft_logblock_2013.lb-NE-2013.id       |    1 |   100.00 |                             |
  22. +----+-------------+------------------+--------+-----------------+---------+---------+---------------------------------------------+------+----------+-----------------------------+
  23. 4 rows in SET, 1 warning (0.00 sec)
  24.  
  25.  
  26.  
  27.  
  28. mysql> EXPLAIN extended SELECT x,DATE, replaced, type, data, playername, signtext, itemtype, itemamount, itemdata FROM `lb-NE-2013` INNER JOIN `lb-players` USING (playerid) LEFT JOIN `lb-NE-2013-SIGN` USING (id) LEFT JOIN `lb-NE-2013-chest` USING (id) WHERE (x BETWEEN -2308 AND -2307) AND y = '43' AND z = '-679' ORDER BY DATE DESC, id DESC;
  29. +----+-------------+------------------+--------+-----------------+---------+---------+---------------------------------------------+------+----------+-----------------------------+
  30. | id | select_type | table            | type   | possible_keys   | key     | key_len | ref                                         | rows | filtered | Extra                       |
  31. +----+-------------+------------------+--------+-----------------+---------+---------+---------------------------------------------+------+----------+-----------------------------+
  32. 1 | SIMPLE      | lb-NE-2013       | range  | coords,playerid | coords  | 8       | NULL                                        | 2440 |   100.00 | USING WHERE; USING filesort |
  33. 1 | SIMPLE      | lb-players       | eq_ref | PRIMARY         | PRIMARY | 2       | minecraft_logblock_2013.lb-NE-2013.playerid |    1 |   100.00 |                             |
  34. 1 | SIMPLE      | lb-NE-2013-SIGN  | eq_ref | PRIMARY         | PRIMARY | 4       | minecraft_logblock_2013.lb-NE-2013.id       |    1 |   100.00 |                             |
  35. 1 | SIMPLE      | lb-NE-2013-chest | eq_ref | PRIMARY         | PRIMARY | 4       | minecraft_logblock_2013.lb-NE-2013.id       |    1 |   100.00 |                             |
  36. +----+-------------+------------------+--------+-----------------+---------+---------+---------------------------------------------+------+----------+-----------------------------+

Submit a correction or amendment below. (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.

Use syntax highlighting

To highlight particular lines, prefix each line with @@


Remember my settings