how to save users visits in an optimized way in Laravel 5.4

I am saving my users visits statistics like this in mySQL database :

• visit_id
• visit_page
• visit_route
• visit_referrer
• visit_ip_address
• visit_device
• created_at
• updated_at

---

my question is will my mySQL database handle this amount of visits like 100,0000 per day? and can it make problems in 5 years being saved like this?(100000 per day)

and if the answers are YES, so what is the optimized way to do this(I don't want to empty my visits table)

via Chebli Mohamed