[
http://opencast.jira.com/browse/MH-8854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=30818#comment-30818
]
David Horwitz commented on MH-8854:
-----------------------------------
mysql> describe SELECT id AS id1, user_ip AS user_ip2, outpoint AS outpoint3,
inpoint AS inpoint4, mediapackage_id AS mediapackage_id5, session_id AS
session_id6, created AS created7, user_id AS user_id8, length AS length9, type
AS type10, is_playing AS is_playing11 FROM user_action WHERE ((session_id =
'1oqq13a558xur') AND (type = 'FOOTPRINT')) ORDER BY created DESC LIMIT 0, 1;
+----+-------------+-------------+------+---------------+------+---------+------+--------+-----------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref
| rows | Extra |
+----+-------------+-------------+------+---------------+------+---------+------+--------+-----------------------------+
| 1 | SIMPLE | user_action | ALL | NULL | NULL | NULL | NULL
| 959991 | Using where; Using filesort |
+----+-------------+-------------+------+---------------+------+---------+------+--------+-----------------------------+
1 row in set (0.01 sec)
> user_action table definition leads to ineficient queries on mysql
> -----------------------------------------------------------------
>
> Key: MH-8854
> URL: http://opencast.jira.com/browse/MH-8854
> Project: Matterhorn Project
> Issue Type: Bug
> Components: Architecture & Services
> Affects Versions: 1.2
> Reporter: David Horwitz
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://opencast.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Matterhorn mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn
To unsubscribe please email
[email protected]
_______________________________________________
