Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F193278
various sql queries for T105964
No One
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Authored By
Reedy
Jul 16 2015, 2:28 PM
2015-07-16 14:28:43 (UTC+0)
Size
2 KB
Referenced Files
None
Subscribers
None
various sql queries for T105964
View Options
mysql:wikiadmin@db1052 [enwiki]> explain select 'en', user_editcount from user where user_name = 'Reedy';
+------+-------------+-------+-------+---------------+-----------+---------+-------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------+-------+---------------+-----------+---------+-------+------+-------+
| 1 | SIMPLE | user | const | user_name | user_name | 257 | const | 1 | |
+------+-------------+-------+-------+---------------+-----------+---------+-------+------+-------+
1 row in set (0.00 sec)
mysql:wikiadmin@db1052 [enwiki]> explain select 'en', user_editcount from user where user_name LIKE 'Reedy';
+------+-------------+-------+-------+---------------+-----------+---------+------+------+-----------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------+-------+---------------+-----------+---------+------+------+-----------------------+
| 1 | SIMPLE | user | range | user_name | user_name | 257 | NULL | 1 | Using index condition |
+------+-------------+-------+-------+---------------+-----------+---------+------+------+-----------------------+
1 row in set (0.01 sec)
mysql:wikiadmin@db1052 [enwiki]> explain select 'en', user_editcount from user where user_name LIKE 'Reedy%';
+------+-------------+-------+-------+---------------+-----------+---------+------+------+-----------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------+-------+---------------+-----------+---------+------+------+-----------------------+
| 1 | SIMPLE | user | range | user_name | user_name | 257 | NULL | 80 | Using index condition |
+------+-------------+-------+-------+---------------+-----------+---------+------+------+-----------------------+
1 row in set (0.00 sec)
mysql:wikiadmin@db1052 [enwiki]>
File Metadata
Details
Attached
Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
184374
Default Alt Text
various sql queries for T105964 (2 KB)
Attached To
Mode
P997 various sql queries for T105964
Attached
Detach File
Event Timeline
Log In to Comment