[Bug 274402] New: mysqld process use a lot of IO time to time

[jlj.babydragon at gmail.com]

https://bugs.kde.org/show_bug.cgi?id=274402

           Summary: mysqld process use a lot of IO time to time
           Product: Akonadi
           Version: 4.7
          Platform: Gentoo Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: server
        AssignedTo: kdepim-bugs at kde.org
        ReportedBy: jlj.babydragon at gmail.com


Version:           4.7 (using Devel) 
OS:                Linux

The mysqld process use by akonadi server use a lot of system IO from time to
time.  The sql mysqld execute at that time is:
SELECT PartTable.id, PartTable.pimItemId, PartTable.name, PartTable.data,
PartTable.datasize, PartTable.version, PartTable.external FROM PartTable INNER
JOIN PimItemTable ON ( pimItemId = PimItemTable.id ) WHERE (
PimItemTable.collectionId = ? AND PimItemTable.atime < ? AND PartTable.data IS
NOT NULL AND substr( PartTable.name, 1, 4 ) = ( ? ) AND PimItemTable.dirty = ?
AND PartTable.name NOT IN ( ?, ? ) )

When this sql is executing, the disk read will be 10MB/s to 30MB/s.
I'm not sure if this is caused by kdepim2.
The version of akonadi-server is 1.5.80, and the kdepim2 is cloned from
kdepim-4.6 branch.

Reproducible: Always

Steps to Reproduce:
start akonadi-server

Actual Results:  
mysqld process always read disk

Expected Results:  
reduce system IO

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.