Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (root@localhost) [uem_prod]> desc lastlogs;
- +------------+--------------+------+-----+---------------------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +------------+--------------+------+-----+---------------------+----------------+
- | id | bigint(20) | NO | PRI | NULL | auto_increment |
- | procname | varchar(255) | YES | | NULL | |
- | pid | int(11) | YES | | NULL | |
- | operation | varchar(255) | YES | | NULL | |
- | path | text | YES | | NULL | |
- | result | varchar(255) | YES | | NULL | |
- | user | varchar(255) | YES | MUL | NULL | |
- | datetime | datetime | NO | PRI | 0000-00-00 00:00:00 | |
- | eventclass | varchar(255) | YES | | NULL | |
- | cmd | text | YES | | NULL | |
- | category | varchar(255) | YES | | NULL | |
- +------------+--------------+------+-----+---------------------+----------------+
- 11 rows in set (0.01 sec)
- (root@localhost) [uem_prod]> explain select distinct id, procname, operation, path, user, datetime from lastlogs
- -> where user = 'UNITED-TSERVER1\\Serveradmin' and datetime > '2009-5-12 08:00' and datetime < '2009-5-12 09:00';
- +----+-------------+----------+-------+---------------+------+---------+------+---------+-------------+
- | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
- +----+-------------+----------+-------+---------------+------+---------+------+---------+-------------+
- | 1 | SIMPLE | lastlogs | range | user | user | 776 | NULL | 1223112 | Using where |
- +----+-------------+----------+-------+---------------+------+---------+------+---------+-------------+
- 1 row in set (0.00 sec)
Add Comment
Please, Sign In to add comment