Closed

Process MySQL table records without locking the table

THIS IS FOR MYSQL AND PHP EXPERTS ONLY!

We will evaluate each bid and the work done. If we are satisfied with the results we will need several other scripts to perform more complex tasks.

We are in need of a script able to process the following MySQL table records:

Table 1:

ad_zone_click_id int(11) No

user_id int(11) No

ad_zone_id int(11) No

ad_zone_view_id int(11) No

camp_id int(11) No

ad_zone_click_date datetime No

ad_zone_click_value decimal(10,7) No

ad_zone_click_ip varchar(15) No

Table 2:

ad_zone_id int(11) No

user_id int(11) No

ad_zone_click_date date No

ad_zone_click_count int(11) No

ad_zone_click_value decimal(10,7) No

ad_zone_click_paid tinyint(1) No 0

ad_zone_click_paid_date date No

payment_id int(11) No

We need a script able to take all records for each ad_zone_id when the ad_zone_click_date is older than X. Calculate the total SUM(ad_zone_click_value) and COUNT(*) for each day (one row per day and per ad_zone_id) and then insert or update table 2 with a new row for that specific ad_zone_click_date and that specific ad_zone_id. Once done, delete the records that were processed (one delete per day and zone to avoid table locks).

All SELECT commands to table 1 must NOT lock the table.

We have another option, creating a new table and copy (without locking the table) the records to be processed to avoid table locks on SELECTS.

Once again, ONLY MYSQL AND PHP EXPERTS!

Skills: MySQL, PHP

See more: mysql sum without locking, mysql select locking, php table locking, process x, creating php table, lock bid mysql table, without in, update mysql, TABLE, mysql copy, locks, mysql delete, mysql specific, php insert select, php delete mysql row, mysql row lock, insert mysql table, mysql lock row, datetime, mysql lock table, mysql lock, mysql insert update , php calculate date, mysql update table, script delete row php

About the Employer:
( 82 reviews ) Palmetto Bay, Uruguay

Project ID: #1214736

11 freelancers are bidding on average $70 for this job

kernelbd

Please check pmb, thanks.

$80 USD in 1 day
(97 Reviews)
6.6
shihan033010

Hi i can do it what you need. i have done lot of complex query. Please accept the bid. i am ready to start your work.

$55 USD in 1 day
(230 Reviews)
6.3
dotsaravanan

Kindly have a look at PMB, Thank You

$35 USD in 3 days
(10 Reviews)
5.4
cicika

Hello, please check private messages. Thanks! Kind regards, cicika

$70 USD in 1 day
(4 Reviews)
3.9
codeguild

I have done this. Please check PMB

$30 USD in 1 day
(7 Reviews)
3.5
jegbagus

Hi apoguy, i really interested with your project.

$30 USD in 0 days
(2 Reviews)
2.4
coderbg

I am fully capable of doing this project. During my work experience I have done this kind of scrips several times.

$30 USD in 4 days
(1 Review)
1.0
vpundora

hello sir your task will be done with great ease. With regards vikas

$60 USD in 2 days
(1 Review)
0.0
chanPHP

Hi, i can do this..Having sound knowledge & expertise in PHP and MySQL. Thanks.

$50 USD in 2 days
(0 Reviews)
0.0
nojnish

please refer PMB for details regards Babu

$88 USD in 5 days
(0 Reviews)
0.0
postmakers

Hello, please check PMB for details. Thanks!!

$125 USD in 2 days
(0 Reviews)
0.0
jakit

hi, we understood your requirement.please check pmb for more detail. thanks, jakit

$150 USD in 3 days
(0 Reviews)
0.0