You can activate the slow query log and log queries that take longer than e.g. 2s. Then after some time you can check how many slow queries were logged and report them to the bug tracker.
The two script are not so good to find good parameters for the innodb_variables in combination with maria_db. I gave up on the detailed tuning and just gave a generous amount of memory (for a couple of users):
innodb_buffer_pool_size = 3824M
innodb_buffer_pool_instance = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 32M
innodb_log_file_size = 525M
innodb_max_dirty_pages_pct = 99
At some point I might look a bit more into the details, especially on smaller system where you have to manage the little RAM you have, that can be quite challenging.