Improve my MySQL stored procedure

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

Hi there,

I'm looking for a MySQL and PHP expert to improve a stored procedure running on my database. This stored procedure checks two values in a table, and if one value is less than another value, it increases the lesser value every second using a sleep statement until it equals the greater value, then quits.

The scripts and functionality do work currently, however there is a problem: in some scenarios too many threads are created when the stored procedure runs, and they are not killed at the end of the stored procedure.

Also, there are some scenarios where the stored procedure simply doesn't run due to an "incrementing" column I have in the database, which it checks first before running. Unfortunately if incrementing == true, but the two values are not the same, the stored procedure never runs.

I have some requirements for this project. Please read them carefully and ensure you only bid if you can comply with the following:

- I need this solution to work on a shared host, not a VPS or my own server

- You must use your own environment to develop and test your code - I cannot give you any access to my servers

- I would prefer that the solution uses a stored procedure and works similarly to the logic already defined

- The solution MUST close all database connections when the stored procedure terminates

- The solution MUST close all PHP threads/processes associated with the scripts

- The solution MUST close all MySQL threads/processes on completion

- The logic must ensure no conflicts are possible (e.g. the incrementing script should never run twice)

- The solution must have graceful error handling and fall-back

I will supply the winning bidder with the relevant parts of the client code (HTML5/JavaScript) as well as the PHP scripts, SQL stored procedure and database table schemas. You should read the scripts and understand what the functionality is trying to do. My preference is that you fix and improve my scripts, however if you have a better solution that is guaranteed to work, I am open to using it - as long as there is not too much integration required on my end.

Good luck, and happy bidding!

Database Administration Database Development Database Programming MySQL PHP

Project ID: #15644552

About the project

22 proposals Remote project Active 6 years ago

Awarded to:

rinsadsl

hi... we have done many project in PHP / MySQL as well as in Stored procedure. We can help you on this Relevant Skills and Experience MySQL stored procedure, PHP Proposed Milestones $100 AUD - Initial $163 AUD - On c More

$263 AUD in 5 days
(1204 Reviews)
9.4

22 freelancers are bidding on average $177 for this job

monitrix

Hi, Would help you to improve stored procedure as per given requirement. Can we discuss your requirement in brief so that I clear my queries. Lets have a chat for detail discussion. ThankS Relevant Skills and Experien More

$250 AUD in 6 days
(518 Reviews)
9.2
OutsourceMan

Yes, We have 10+ years experience with MySQL and PHP Surely, We are ready to help you with improve a stored procedure running on your database. Let discuss little more? We will offer you the best. Relevant Skills and More

$171 AUD in 3 days
(525 Reviews)
8.8
saritamahar

Hello, I have 6+ years exp in WordPress, PHP, and MySQL. Please enable chat to share more details. Eagerly waiting for your response. Regards: Sarita Mahar Relevant Skills and Experience WordPress, PHP Proposed Mi More

$150 AUD in 5 days
(93 Reviews)
6.3
i2software

hi There is no problem with your requirements. I can do the work. I have extensive experience in mysql development

$222 AUD in 3 days
(81 Reviews)
6.3
rajan6533

i will do it Relevant Skills and Experience mysql Proposed Milestones $45 AUD - sone

$45 AUD in 2 days
(11 Reviews)
3.2
suninfolabs

Dear sir, I have a team of expert developer and designer who can give make any kind of application with their skill set. I have seen requirements and I am 100 % sure that I can make it happened with latest design More

$150 AUD in 7 days
(9 Reviews)
3.5
ashishkathiriya

Hello sir, I have good experience in php and mysql. I have more than 5 years experience in this field. Looking forward to hear from you. Thanks Ashish Relevant Skills and Experience PHP Mysql Proposed Milestones $1 More

$138 AUD in 4 days
(9 Reviews)
2.5
reddysir2016

We have done so many data base administration projects Relevant Skills and Experience Database Administration, Database Development, Database Programming, MySQL, PHP Proposed Milestones $155 AUD - on chat

$155 AUD in 3 days
(3 Reviews)
2.4
ITprogrammer1

Hello! I am writing in response to your Project. After carefully reviewing the experience requirements and skills required for the job, I feel that I am a suitable match for the job. I am a data scientist by professi More

$40 AUD in 4 days
(0 Reviews)
0.0
RaqiyaTawfeeq

A proposal has not yet been provided

$30 AUD in 3 days
(0 Reviews)
1.9