hello everyone,
I'm trying to upgrade OTRS from version 2.2.7 to 3.1.10 while migrating
the system to another server.
I first "cloned" the 2.2.7 system on the new server and successfully
imported the database and all configurations.
then I upgraded the OTRS: 2.2 -> 2.3. -> 2.4. -> 3.0 -> 3.1. I executed
all migration scripts and followed every instruction mentioned in the
documentation.
the system works well, except some very slow mysql queries when I try to
view tickets.
I activated mysql-slow-query-log, example (viewing a ticket):
-------------------
SET timestamp=1347279327;
SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
sa.a_reply_to, sa.a_message_id, sa.a_in_reply_to, sa.a_references,
sa.a_body, st.create_time_unix, st.ticket_state_id, st.queue_id,
sa.create_time, sa.a_content_type, sa.create_by, st.tn,
article_sender_type_id, st.customer_id, st.until_time,
st.ticket_priority_id, st.customer_user_id, st.user_id,
st.responsible_user_id, sa.article_type_id, sa.a_freekey1,
sa.a_freetext1, sa.a_freekey2, sa.a_freetext2, sa.a_freekey3,
sa.a_freetext3, st.ticket_answered, sa.incoming_time, sa.id,
st.freekey1, st.freetext1, st.freekey2, st.freetext2, st.freekey3,
st.freetext3, st.freekey4, st.freetext4, st.freekey5, st.freetext5,
st.freekey6, st.freetext6, st.freekey7, st.freetext7, st.freekey8,
st.freetext8, st.freekey9, st.freetext9, st.freekey10, st.freetext10,
st.freekey11, st.freetext11, st.freekey12, st.freetext12, st.freekey13,
st.freetext13, st.freekey14, st.freetext14, st.freekey15,
st.freetext15, st.freekey16, st.freetext16, st.ticket_lock_id,
st.title, st.escalation_update_time, st.freetime1 , st.freetime2,
st.freetime3, st.freetime4, st.freetime5, st.freetime6, st.type_id,
st.service_id, st.sla_id, st.escalation_response_time,
st.escalation_solution_time, st.escalation_time, st.change_time FROM
article sa, ticket st WHERE sa.ticket_id = '28373' AND sa.ticket_id =
st.id ORDER BY sa.create_time, sa.id ASC;
# Time: 120910 14:15:35
# User@Host: otrs[otrs] @ localhost []
# Query_time: 8.183378 Lock_time: 0.000041 Rows_sent: 3 Rows_examined:
61222
---------------------
the system takes about 5-30 seconds to view a ticket. sometimes it just
works perfectly for a while, the next moment it's slow again.
table "article" has about 68.000 records
table "ticket" has about 28.000 records
if you need to know other data or log files, let me know.
thanks in advance,
chris
--
Bergische Universität Wuppertal
Zentrum für Informations- und Medienverarbeitung
Gaussstr. 20
D-42097 Wuppertal
Germany
Email: [email protected]
Home : http://www.zim.uni-wuppertal.de
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
