Tracking system using PHP and MySQL -

Tracking system using PHP and MySQL -

background: have 3rd party application building company. i'm building bot supplies automated actions using companies api. have one server, application, tracking system, database, , admin panel sit down on same server , must stay.

how track: whenever user visits 1 of landing pages, save info in mysql table called visits. params include params ($_get) with, auto generated transaction id (random) alongside other server params ($_server) such user ip, browser, landing page landed etc. info beingness saved on cookies in case comes back.

when user signs save transaction id generated on visit alongside sign info in table called users. , that's how can reach visit information.

what problem: using adwords send traffic landing pages, , when increment traffic stage around 3 visits per second, server overloaded , performance drops.

what can optimize?

php mysql