I have a user_access table (MyISAM) with user access information (like IP, access date,…). New user accesses will be created when user go to the webpage, …and then each minute one user access.
And now my problem, when many users go to the page at the same time then all inserts are locked and this increases the page execution time.
Is it possible to avid this problem? My idea is:
Create a memory drive and on each paga generation create a file with user_access information. After it create a daemon which will be executed in background. This daemon reads each file, create user_access insert (into database) and then delete already processed files.
Do you have any other (better) ideas?