You are viewing a plain text version of this content. The canonical link for it is here.
Posted to olio-dev@incubator.apache.org by "James Zubb (JIRA)" <ji...@apache.org> on 2010/07/15 23:44:50 UTC
[jira] Created: (OLIO-150) tag index missing from SOCIALEVENTTAG
table
tag index missing from SOCIALEVENTTAG table
-------------------------------------------
Key: OLIO-150
URL: https://issues.apache.org/jira/browse/OLIO-150
Project: Olio
Issue Type: Bug
Components: java-app
Environment: Suse Linux Enterprise 11
Glassfish 2.1
Mysql 5.0
Reporter: James Zubb
Assignee: Shanti Subramanyam
The SOCIALEVETTAG table needs an index for the tag row. It is missing from the Java schema, but it is in the PHP schema. Not sure about Rails
This causes heavy load on mysql with many SOCIALEVENTTAG table scans.
Need to add the following to the schema.sql (copied from PHP schema.sql):
CREATE INDEX SOCIALEVENTTAG_TAG on SOCIALEVENTTAG (tag);
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (OLIO-150) tag index missing from SOCIALEVENTTAG
table
Posted by "Shanti Subramanyam (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OLIO-150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shanti Subramanyam resolved OLIO-150.
-------------------------------------
Fix Version/s: 0.3
Resolution: Fixed
Fixed as described in JIRA
> tag index missing from SOCIALEVENTTAG table
> -------------------------------------------
>
> Key: OLIO-150
> URL: https://issues.apache.org/jira/browse/OLIO-150
> Project: Olio
> Issue Type: Bug
> Components: java-app
> Environment: Suse Linux Enterprise 11
> Glassfish 2.1
> Mysql 5.0
> Reporter: James Zubb
> Assignee: Shanti Subramanyam
> Fix For: 0.3
>
>
> The SOCIALEVETTAG table needs an index for the tag row. It is missing from the Java schema, but it is in the PHP schema. Not sure about Rails
> This causes heavy load on mysql with many SOCIALEVENTTAG table scans.
> Need to add the following to the schema.sql (copied from PHP schema.sql):
> CREATE INDEX SOCIALEVENTTAG_TAG on SOCIALEVENTTAG (tag);
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.