Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P4861
(An Untitled Masterwork)
Active
Public
Actions
Authored by
Marostegui
on Feb 1 2017, 3:23 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F5442388:
Feb 1 2017, 3:23 PM
2017-02-01 15:23:13 (UTC+0)
Subscribers
None
MariaDB [test]> SELECT * FROM event ORDER BY timestamp DESC,log_timestamp DESC LIMIT 500\G
<snip>
500 rows in set (19.88 sec)
MariaDB [test]> explain SELECT * FROM event ORDER BY timestamp DESC,log_timestamp DESC LIMIT 500;
+------+-------------+-------+------+---------------+------+---------+------+---------+----------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------+------+---------------+------+---------+------+---------+----------------+
| 1 | SIMPLE | event | ALL | NULL | NULL | NULL | NULL | 3917858 | Using filesort |
+------+-------------+-------+------+---------------+------+---------+------+---------+----------------+
1 row in set (0.00 sec)
MariaDB [test]> alter table event add key timestamp_log_timestamp (`timestamp`,`log_timestamp`);
Query OK, 0 rows affected (44.13 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [test]> explain SELECT * FROM event ORDER BY timestamp DESC,log_timestamp DESC LIMIT 500;
+------+-------------+-------+-------+---------------+-------------------------+---------+------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------+-------+---------------+-------------------------+---------+------+------+-------+
| 1 | SIMPLE | event | index | NULL | timestamp_log_timestamp | 88 | NULL | 500 | |
+------+-------------+-------+-------+---------------+-------------------------+---------+------+------+-------+
1 row in set (0.00 sec)
MariaDB [test]> SELECT * FROM event ORDER BY timestamp DESC,log_timestamp DESC LIMIT 500;
<snip>
500 rows in set (0.01 sec)
Event Timeline
Marostegui
created this paste.
Feb 1 2017, 3:23 PM
2017-02-01 15:23:13 (UTC+0)
Log In to Comment