Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P58
(An Untitled Masterwork)
Active
Public
Actions
Authored by
stwalkerster
on Oct 7 2016, 11:26 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Tags
None
Referenced Files
F2493:
Oct 7 2016, 11:31 PM
2016-10-07 23:31:00 (UTC+0)
F2492:
Oct 7 2016, 11:26 PM
2016-10-07 23:26:52 (UTC+0)
Subscribers
None
| idx_ban_active | active | |
| idx_ban_duration | duration | 765 |
| idx_ban_typeactive | "type,active" | 765 |
| idx_comment_request | request | |
| name | name | 765 |
| address_UNIQUE | address | 135 |
| log_idx_action | action | 765 |
| log_idx_idtype | "objecttype,objectid" | 135 |
| log_idx_objectid | objectid | |
| log_idx_timestamp | timestamp | |
| log_idx_typeuseraction | "objecttype,user,action" | 900 |
| log_idx_user | user | |
| address_UNIQUE | address | 135 |
| acc_pend_status_mailconf | "status,emailconfirm" | 1530 |
| ft_useragent | useragent | 65535 |
| ip | ip | 765 |
| mailconfirm | emailconfirm | 765 |
| pend_email_status | "email,emailconfirm" | 2301 |
| pend_ip_status | "ip,emailconfirm" | 1530 |
| idx_user_lastactive | lastactive | |
| idx_user_status | status | 765 |
| I_username | username | 765 |
| user_email_UNIQUE | email | 765 |
| IDX_xfftrustcache_ip | ip | 45 |
select index_name, group_concat(s.column_name order by s.seq_in_index separator ','), sum(c.character_octet_length)
from statistics s
inner join columns c on s.table_schema = c.table_schema and s.table_name = c.table_name and s.column_name = c.column_name
where s.table_schema = 'production'
group by s.table_name, s.index_name
having index_name <> 'PRIMARY';
Event Timeline
stwalkerster
created this paste.
Oct 7 2016, 11:26 PM
2016-10-07 23:26:52 (UTC+0)
stwalkerster
edited the content of this paste.
(Show Details)
Oct 7 2016, 11:30 PM
2016-10-07 23:30:59 (UTC+0)
•
import-bot
changed the edit policy from "All Users" to "
Community
(Project)".
Feb 3 2017, 3:03 PM
2017-02-03 15:03:37 (UTC+0)
Log In to Comment