The problem of slow big data statistics in mysql is as follows: is there any solution? User Access Statistics: There is a data table every month, with about million data records per day. a daily trend chart is generated for the return visits of each user, it will be slow to execute statistics using conventional mysql. Is there any good solution? thank you. ------ Solution ------------------ explore indexes, views, and memory tables ------ solution ------------------- slow big data statistics in mysql. Is there any solution?
User Access Statistics: There is a data table every month, with about million data every day. a daily trend chart is generated for each user's return visit. it will be very slow to execute regular mysql statistics, is there any good solution? thank you.
------ Solution --------------------
Discussion
Indexes, views, and memory tables
------ Solution --------------------
Discussion
Indexes, views, and memory tables