Skip to content

Instantly share code, notes, and snippets.

@gabidavila

gabidavila/mysql

Created February 19, 2015 15:21
Show Gist options
  • Save gabidavila/51f2bb550ea9d139af9d to your computer and use it in GitHub Desktop.
Save gabidavila/51f2bb550ea9d139af9d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql
#trans.data_transaction DESC
+----+-------------+---------------+--------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+---------+------------------------------+--------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------------+--------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+---------+------------------------------+--------+----------------------------------------------+
| 1 | SIMPLE | user_sender | index | PRIMARY | un_users_07 | 452 | NULL | 861256 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | trans | ref | ix_date_transaction,,ix_transaction_type,ix_user_transactions | 5 | phpuk.user_sender.id | 1 | Using where |
| 1 | SIMPLE | user_receiver | eq_ref | PRIMARY | PRIMARY | 4 | phpuk.trans.user_receiver_id | 1 | Using where |
+----+-------------+---------------+--------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+---------+------------------------------+--------+----------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment