Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: dturner_palomino on May 23rd, 2012  |  syntax: None  |  size: 1.33 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. mysql> source expl.sql
  2. Database changed
  3. +----+-------------+---------------------+------+---------------+------+---------+------+---------+-------------+
  4. | id | select_type | table               | type | possible_keys | key  | key_len | ref  | rows    | Extra       |
  5. +----+-------------+---------------------+------+---------------+------+---------+------+---------+-------------+
  6. |  1 | SIMPLE      | persistent_throttle | ALL  | NULL          | NULL | NULL    | NULL | 1634297 | Using where |
  7. +----+-------------+---------------------+------+---------------+------+---------+------+---------+-------------+
  8. 1 row in set (0.00 sec)
  9.  
  10. +----+-------------+---------------------+-------+-------------------------+-------------------------+---------+------+--------+-------------+
  11. | id | select_type | table               | type  | possible_keys           | key                     | key_len | ref  | rows   | Extra       |
  12. +----+-------------+---------------------+-------+-------------------------+-------------------------+---------+------+--------+-------------+
  13. |  1 | SIMPLE      | persistent_throttle | range | timeOfLastIntervalStart | timeOfLastIntervalStart | 9       | NULL | 817148 | Using where |
  14. +----+-------------+---------------------+-------+-------------------------+-------------------------+---------+------+--------+-------------+
create a new version of this paste RAW Paste Data