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

--- Comment #2 from Andy <[email protected]> ---
Hi!
I've now done a few things that Synology recommends:
- Btrfs is present. Unfortunately, I can no longer create an ext4 volume.
- I recreated the Docker share with the database without enhanced data
integrity.
- innodb_flush_method = O_DIRECT
- An SSD cache is present.

You might also be interested in what the phpMyAdmin Advisor says about
problems?

Here's an example after a short runtime:
Issue:
There are too many joins without indexes.
Recommendation:
This means that joins are doing full table scans. Adding indexes for the
columns being used in the join conditions will greatly speed up table joins.
Justification:
Table joins average: 7.83 per minute, this value should be less than 1 per hour
Used variable / formula:
(Select_range_check + Select_scan + Select_full_join) / Uptime
Test:
value * 60 * 60 > 1


Andy

-- 
You are receiving this mail because:
You are watching all bug changes.

Reply via email to