I hope I don´t miss a topic which discuss this point and added a double post.
My Problem is:
I am logging an online shop with approximately 500 visitors per day and thousands of views. When I log in in my dashboard, the refresh rate of the day view seems to be realtime (if no data is dropped). The views for year, month and day are not calculated in realtime and seem to be updated not regular.
I logged my phpMyAdminData:
Connections failed: 1,557k (18.84 %)
Connections aborted: 4,651 (0.06 %)
Connections: 8,264 k
Connections failed: 1,610 k (19.16 %)
Connections aborted: 4,792 (0.06 %)
Connections: 8,403 k
And also these values are red and increase:
Handler_read_rnd 156 M
Handler_read_rnd_next 260 G
Qcache_lowmem_prunes 20 M *
Created_tmp_disk_tables 3,134 k
Key_reads 25 M *
Select_full_join 136 k
Sort_merge_passes 9 *
Opened_tables 2,614 k
Table_locks_waited 529 k
*only red, no increase
My hoster is goneo and all requirements for the installation matched.
Can you help me, please?