Investigate slow DB queries

[hassanakbar4]

component_MailArchive: User Interface resolution_fixed type_task | by rcross@amsl.com

---

MySQL slow query log shows many 2+ second queries.

For example:

Tcp port: 3306 Unix socket: /run/mysql/mysql.sock Time Id Command Argument

Time: 201106 15:43:48

User@Host: mailarch[mailarch] @ localhost []

Thread_id: 38 Schema: mailarch QC_hit: No

Query_time: 2.744991 Lock_time: 0.000143 Rows_sent: 1 Rows_examined: 11160

Rows_affected: 0

use mailarch; SET timestamp=1604706228; SELECT archive_message.id, archive_message.base_subject, archive_message.cc, archive_message.date, archive_message.email_list_id, archive_message.frm, archive_message.from_line, archive_message.hashcode, archive_message.in_reply_to_id, archive_message.in_reply_to_value, archive_message.legacy_number, archive_message.msgid, archive_message.references, archive_message.spam_score, archive_message.subject, archive_message.thread_id, archive_message.thread_depth, archive_message.thread_order, archive_message.to, archive_message.updated FROM archive_message WHERE (archive_message.date ># '2020-03-30 00:01:15' AND archive_message.email_list_id 1096 AND NOT (archive_message.id = 2859472)) ORDER BY archive_message.date ASC, archive_message.id ASC LIMIT 1;

---

Issue migrated from trac:3137 at 2021-09-22 16:57:40 +0500

[hassanakbar4]

@hassanakbar4 changed status from new to closed

[hassanakbar4]

@hassanakbar4 changed resolution from ` tofixed`

[hassanakbar4]

@hassanakbar4 commented

---

Fixed in [1066/mailarch]:

Optimize query for message.next_in_list(). Fixes #3137