Hello :)
I need a MYSQL EXPERT.
On my site I run php scripts that gets executed over a million times a day.
A part of this script is written very bad and pressured my server load.
This table is called "all stats".
When I run my mysql processes lis this shows up:
ID USER Host Database Commando Time Status SQL-query
stop proces 403 DELAYED localhost autovisitingnew Delayed_insert 55 Waiting on cond all_stat
stop proces 24689125 DELAYED localhost neverclicking_com Delayed_insert 4118 Waiting on cond all_stat
stop proces 24755629 DELAYED localhost dutchpopups Delayed_insert 1020 Waiting on cond all_stat
Like you can see lotsa troubles,
If you need to know: its not my msql software that is screwing up.
Its the script itselve.
Please use this link to for to the database dump + php script that is related to all_stats
http:/[login to view URL]
I hope this will give you a good impression on what needs to be done.
I want this script to run smooth, maybe its a good idea to update the script only once every 25 times the script gets executed.
But most important it will run fast without troubles.
Thanks!