Hello,
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:
05.05.2010 18:45
Connections failed: 1,557k (18.84 %)
Connections aborted: 4,651 (0.06 %)
Connections: 8,264 k
06.05.2010 10:45
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:
Slow_queries 413
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
Select_range_check 8,168
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?
Best regards
Sieben