<html><body><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000"><div id="zimbraEditorContainer" style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2">Hi.</div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2"><br data-mce-bogus="1"></div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2">I'm experiencing a weird situation: userA has info@ mounted in his mailbox. When accessing the mounted Inbox folder it takes minutes to load, killing MySQL. If I open info@ directly (a rather huge mailbox) inbox loads instantly.</div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2"><br data-mce-bogus="1"></div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2">I found in mysql processlist a query running several times with the same parameters:<br></div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2"><div><div><span style="font-family: courier new, courier, monaco, monospace, sans-serif;" data-mce-style="font-family: courier new, courier, monaco, monospace, sans-serif;">SELECT <a href="http://mi.id" title="http://mi.id" rel="nofollow noreferrer noopener" target="_blank" data-mce-href="http://mi.id">mi.id</a>, mi.type, mi.parent_id, mi.folder_id, mi.prev_folders, mi.index_id,mi.imap_id, mi.date, mi.size, mi.locator, mi.blob_digest, mi.unread, mi.flags, mi.tag_names, mi.subject,<a href="http://mi.name" title="http://mi.name" rel="nofollow noreferrer noopener" target="_blank" data-mce-href="http://mi.name">mi.name</a>, mi.metadata, mi.mod_metadata, mi.change_date, mi.mod_content, mi.uuid, mi.unread AS </span><span style="font-family: courier new, courier, monaco, monospace, sans-serif;" data-mce-style="font-family: courier new, courier, monaco, monospace, sans-serif;">sortcol </span></div><div><span style="font-family: courier new, courier, monaco, monospace, sans-serif;" data-mce-style="font-family: courier new, courier, monaco, monospace, sans-serif;">FROM mboxgroup19.mail_item AS mi </span></div><div><span style="font-family: courier new, courier, monaco, monospace, sans-serif;" data-mce-style="font-family: courier new, courier, monaco, monospace, sans-serif;">WHERE mi.mailbox_id = 19 AND ((mi.type = 0x05 OR mi.type = 0x10) AND mi.folder_id = 2) </span></div><div><span style="font-family: courier new, courier, monaco, monospace, sans-serif;" data-mce-style="font-family: courier new, courier, monaco, monospace, sans-serif;">ORDER BY sortcol DESC, <a href="http://mi.id" title="http://mi.id" rel="nofollow noreferrer noopener" target="_blank" data-mce-href="http://mi.id">mi.id</a> DESC LIMIT 9045,2000</span></div></div><br>It's run with different <em>LIMIT</em> values, but what it's weird when it reaches a certain value it starts again from 0, looping through this for several times. </div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2"><br data-mce-bogus="1"></div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2">This is a newly installed server migrated from an old one with Zextras migration tool. No such problem was reported on the old installation (8.0.5). </div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2"><br data-mce-bogus="1"></div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2">I don't know if it was a coincidence, but it has been reported after installing shared-mailbox-toolkit extension. These shares were implemented before this extension's installation and were migrated by the tool. I tried removing s-m-t extensions and restarting Zimbra but the problem still persists so it can be unrelated.</div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2"><br data-mce-bogus="1"></div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2">Any other hint is welcome.</div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt; color: #000000" class="2">thanks<br><div data-marker="__SIG_POST__">-- <br></div><div>Lorenzo Milesi - lorenzo.milesi@yetopen.it<br><br><br></div></div></div>
<br><div>
<a href="https://www.yetopen.it">
<img src="https://logo.ufficyo.com/logo_yetopen_firma_email.png" alt="YetOpen S.r.l." />
</a>
<br />
Via Salerno 18 - 23900 Lecco - ITALY -<br />
Tel +39 0341 220 205 - Fax +39 178 6070 222<br />
<br />
<em><font color="#77bb41">Think green</font> - Non stampare questa e-mail se non necessario / Don't print this email unless necessary</em><br />
<br />
<font style="font-size: 9px; color: rgb(162, 162, 162);">
-------- D.Lgs. 196/2003 e GDPR 679/2016 --------<br />
Tutte le informazioni contenute in questo messaggio sono riservate ed a uso esclusivo del destinatario.
Tutte le informazioni ivi contenute, compresi eventuali allegati, sono da ritenere confidenziali e riservate secondo i termini
del vigente D.Lgs. 196/2003 in materia di privacy e del Regolamento europeo 679/2016 - GDPR - e quindi ne e' proibita l'utilizzazione ulteriore non autorizzata.
Nel caso in cui questo messaggio Le fosse pervenuto per errore, La invitiamo ad eliminarlo senza copiarlo, stamparlo, a non inoltrarlo a terzi e ad avvertirci non appena possibile.
Grazie.<br />
<br />
Confidentiality notice: this email message including any attachment is for the sole use of the intended recipient and may contain confidential and privileged information;
pursuant to Legislative Decree 196/2003 and the European General Data Protection Regulation 679/2016 - GDPR - any unauthorized review, use, disclosure or distribution
is prohibited. If you are not the intended recepient please delete this message without copying, printing or forwarding it to others, and alert us as soon as possible.
Thank you.<br />
</font>
</div>
<br></body></html>