Hundreds of MySQL statements with LIMIT

pwhooftman

I have been trying to solve bad performance for quite some time now, especially when using the webinterface.

I have enabled 'general_log' in MariaDB10, and i notice hundreds of identical SELECT statements bombarded towards the sql server, just by clicking on a different folder in the webinterface (which then takes tens of seconds to open). I was expecting a single SELECT statement to select all items in that folder, why are there so much, and so much identical SELECT queries all with 'LIMIT' in them so they only produce 1 or 2 results for each query? Just to list a folders contents? No wonder enabling 'slow_query_log' never came up with anything, if hundreds of queries are fired at the database to just retrieve one or two record per query, the queries in itself don't have to be slow , hundreds of small waits add up to one big one. Same thing happens when i initate a sync from my phone by the way.

Synology DS918+ , 12GB RAM

Just one click gives me a multiple amount of this (this is just a part):230830 13:36:09 11 Query SELECT users.id AS users_id, users.primary_email AS users_primary_email, users.password AS users_password, users.domain_id AS users_domain_id, users.address_status AS users_address_status, users.privilege_bits AS users_privilege_bits, users.externid AS users_externid, users.chat_id AS users_chat_id, users.homeserver AS users_homeserver, users.sync_policy AS users_sync_policy, users.max_size AS users_max_size, (SELECT NULL) AS anon_1, (SELECT NULL) AS anon_2, users.group_id AS users_group_id, users.username AS users_username, users.maildir AS users_maildir, users.lang AS users_lang, (SELECT domains.org_id FROM domains WHERE domains.id = users.domain_id) AS anon_3 FROM users WHERE users.username = 'admin' LIMIT 1 11 Query ROLLBACK 230830 13:36:11 17 Query SELECT u.password, dt.propval_str AS dtypx, u.address_status, u.privilege_bits, u.maildir, u.lang, u.externid, op1.value AS ldap_uri, op2.value AS ldap_binddn, op3.value AS ldap_bindpw, op4.value AS ldap_basedn FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN orgs ON u.domain_id=orgs.id LEFT JOIN orgparam AS op1 ON orgs.id=op1.org_id AND op1.key='ldap_uri' LEFT JOIN orgparam AS op2 ON orgs.id=op2.org_id AND op2.key='ldap_binddn' LEFT JOIN orgparam AS op3 ON orgs.id=op3.org_id AND op3.key='ldap_bindpw' LEFT JOIN orgparam AS op4 ON orgs.id=op4.org_id AND op4.key='ldap_basedn' WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.username, u.maildir, up.propval_str FROM secondary_store_hints AS s INNER JOIN users AS u ON s.secondary=u.id LEFT JOIN user_properties AS up ON u.id=up.user_id AND up.proptag=0x3001001f WHERE s.primary=9 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.username, u.maildir, up.propval_str FROM secondary_store_hints AS s INNER JOIN users AS u ON s.secondary=u.id LEFT JOIN user_properties AS up ON u.id=up.user_id AND up.proptag=0x3001001f WHERE s.primary=9 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.username, u.maildir, up.propval_str FROM secondary_store_hints AS s INNER JOIN users AS u ON s.secondary=u.id LEFT JOIN user_properties AS up ON u.id=up.user_id AND up.proptag=0x3001001f WHERE s.primary=9 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.username, u.maildir, up.propval_str FROM secondary_store_hints AS s INNER JOIN users AS u ON s.secondary=u.id LEFT JOIN user_properties AS up ON u.id=up.user_id AND up.proptag=0x3001001f WHERE s.primary=9 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.username, u.maildir, up.propval_str FROM secondary_store_hints AS s INNER JOIN users AS u ON s.secondary=u.id LEFT JOIN user_properties AS up ON u.id=up.user_id AND up.proptag=0x3001001f WHERE s.primary=9 19 Query SELECT u.id FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.maildir='/var/lib/gromox/user/0/3' AND dt.propval_str IN (0,7,8) LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.username, u.maildir, up.propval_str FROM secondary_store_hints AS s INNER JOIN users AS u ON s.secondary=u.id LEFT JOIN user_properties AS up ON u.id=up.user_id AND up.proptag=0x3001001f WHERE s.primary=9 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 230830 13:37:09 17 Query SELECT u.password, dt.propval_str AS dtypx, u.address_status, u.privilege_bits, u.maildir, u.lang, u.externid, op1.value AS ldap_uri, op2.value AS ldap_binddn, op3.value AS ldap_bindpw, op4.value AS ldap_basedn FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN orgs ON u.domain_id=orgs.id LEFT JOIN orgparam AS op1 ON orgs.id=op1.org_id AND op1.key='ldap_uri' LEFT JOIN orgparam AS op2 ON orgs.id=op2.org_id AND op2.key='ldap_binddn' LEFT JOIN orgparam AS op3 ON orgs.id=op3.org_id AND op3.key='ldap_bindpw' LEFT JOIN orgparam AS op4 ON orgs.id=op4.org_id AND op4.key='ldap_basedn' WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.username, u.maildir, up.propval_str FROM secondary_store_hints AS s INNER JOIN users AS u ON s.secondary=u.id LEFT JOIN user_properties AS up ON u.id=up.user_id AND up.proptag=0x3001001f WHERE s.primary=9 20 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 17 Query SELECT u.id, u.domain_id, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 WHERE u.username='pieter@mydomain.nl' LIMIT 2 9 Query SELECT users.id AS users_id, users.primary_email AS users_primary_email, users.password AS users_password, users.domain_id AS users_domain_id, users.address_status AS users_address_status, users.privilege_bits AS users_privilege_bits, users.externid AS users_externid, users.chat_id AS users_chat_id, users.homeserver AS users_homeserver, users.sync_policy AS users_sync_policy, users.max_size AS users_max_size, (SELECT NULL) AS anon_1, (SELECT NULL) AS anon_2, users.group_id AS users_group_id, users.username AS users_username, users.maildir AS users_maildir, users.lang AS users_lang, (SELECT domains.org_id FROM domains WHERE domains.id = users.domain_id) AS anon_3 FROM users WHERE users.username = 'admin' LIMIT 1 20 Query SELECT u2.propval_str AS real_name, u3.propval_str AS nickname, dt.propval_str AS dtypx FROM users AS u LEFT JOIN user_properties AS dt ON u.id=dt.user_id AND dt.proptag=956628995 LEFT JOIN user_properties AS u2 ON u.id=u2.user_id AND u2.proptag=805371935 LEFT JOIN user_properties AS u3 ON u.id=u3.user_id AND u3.proptag=978255903 WHERE u.username='pieter@mydomain.nl' LIMIT 2

Andy

pwhooftman Synology DS918+, 12 GB RAM

Is Grommunio installed natively on the DS and the MariaDB 10 installed as an APP is used as a database? If so, why don't you install a VM in VMM using an ISO or OVA?

jengelh

What you are seeing is MySQL's own query representation after it has parsed/optimized our query. Gromox does not use LIMIT 1 in any mysql statement, and certainly does not use anon_3 as a column name anywhere.

LIMIT 2 is employed as a safe-guard for queries where only one result row is normally expected.

so much identical SELECT queries

MAPI and its data model affect this quite a bit. For example, if you have a message and want to obtain the postal address associated with every recipient, g-web would probably loop over every recipient and issue as many mapi_ab_openentry calls —rather than doing one call (which does not exist currently) with an array of recipients.
You could turn on zcore.cfg's zrpc_debug=2 and, in sql2.cpp, mlog() the query before mysql_query is invoked to correlate g-web's actions with mysql calls.