CronJob fix

I have a cronjob running on a VPS running a php file to insert items into a DB. The items come from multiple sources and each source is read by the php file from a txt file eg S1,S2,S3,S4.

This was working fine untill the data base hase become quite large with 500,000 items.

Now the cronjob runs the first source in the list and then send email to say process has failed and terminates.

Im guessing this is some sort of time out type issue but I need it fixed with either a more efficient code. I have already increased timeout in [login to view URL] but this has not helped. I am a novice with this type of thing.

Thus is the cronjob

for i in $(cat /var/www/vhosts/domain/httpdocs/admin/[login to view URL]) ; do php -q /var/www/vhosts/domain/httpdocs/admin/[login to view URL] "$i" || { echo "Cron $i failed" | mail -s "Cron error" hello@[login to view URL] ; } ; done

Beceriler: Linux, MySQL, PHP, Yazılım Mimarisi

Daha fazlasını gör: I need to fix two little things on my code, software write mq4, software write chip epson, php, software testing, mysql, software architecture, linux, debugging, need iphone application code, useful software write book, delphi php efficient code, fix ie7 fixed, software write web specs, fix flash xml website issue, need flash player code, issue html code newsletter, free software write user guide, software write edid, free software write company profile

İşveren Hakkında:
( 14 değerlendirme ) Woodley, United Kingdom

Proje NO: #14536626



Hi. You are absolutely right: increasing time of excution is not the only way to solve your problem. Memory limit might cause the problem. Seems need to analyze your algorythm, database structure and so on. Sometimes a Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 70%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(46 Değerlendirme)

Bu iş için 47 freelancer ortalamada $131 teklif veriyor


Hi greetings of the day I am a Experienced PHP Developer based out in Chennai,India. My experience revolves around development of web and mobile applications,Ecommerce websites. Relevant Skills and Experience I believ Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(50 Değerlendirme)

Hello I'm interesting your project very well I'm a Good Linux, C++, c#, Python, swift, object-c, MySQL, Math, Java, Algorithm expert. Relevant Skills and Experience I m quite well experienced in these jobs. Let's go Daha Fazla

in %bids___i_period_sub_35% gün içinde247%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(662 Değerlendirme)

I have more than 7+ years experience in this field By reading your requirement i have some question please message me so we can discuss over the chat and communicate quickly. Relevant Skills and Experience Linux, My Daha Fazla

in %bids___i_period_sub_35% gün içinde195%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(410 Değerlendirme)

Dear Client, I have expertise in Linux , I have knowledge of Linux coding , Linux programming , Commands , AWS server maintenance, Ubuntu server maintenance, Nignix server maintenance . I can successfully hel Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(565 Değerlendirme)

READY TO START NOW!!! Can you please provide website code access so that i can check code and move further accordingly? Looking forward to hear from you. Thanks

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(94 Değerlendirme)
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(35 Değerlendirme)

I can debug the PHP code as well as DB connection settings and then can fix the problem. I guarantee to solve the problem, hence i can even solve the problem before you accept my bid request. Relevant Skills and Exper Daha Fazla

in %bids___i_period_sub_35% gün içinde85%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(305 Değerlendirme)

Hi there, I am ready to start Work on it Right Now. Kindly check PMB. Daha Fazla

in %bids___i_period_sub_35% gün içinde147%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(214 Değerlendirme)

I can do this very easily even i have done this many a times. Kindly initiate chat ones so i can discuss the problem clearly, and help you out surely. I am very expert with AWS i have setup EC2 instance manny time a Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(65 Değerlendirme)

Hi , I am very much familiar with cron jobs . Recently I have completed as per client's requirements. you can see client's feedbacks for CRON relevant t tasks on my profile page :- [login to view URL] Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(227 Değerlendirme)

Hi, so problem is cron job is no more working after 500,000 items insertion in database. I can modify the code so more cron job will work again. I can further check your code once you message me. Relevant Skills and Daha Fazla

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(342 Değerlendirme)

I ama ble to fix PHP cron job on VPS to insert 500,000 items into DB. Relevant Skills and Experience I am Anna with more than 5 years experience in PHP, Laravel framework, Slim framework, CodeIgniter, MySQL, PostgreSQ Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(113 Değerlendirme)

Hi. I'm available to take a quick look at the cron code and make a preliminary diagnosis. Then we can decide if we go ahead with the job of fixing. Thanks for considering my services, Stan. Over 300 jobs feedbac Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(329 Değerlendirme)
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(124 Değerlendirme)

Hello, I can definitely help you with your requirements. I am a full time developer working "8 hours a day" 40 hours per week. Thanks Relevant Skills and Experience Linux, MySQL, PHP, Software Architecture Proposed Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(73 Değerlendirme)

Hello Sir, I have worked with Website Cron Job for a Project in which we work with a lot of products in every 2 hours of time. We can fix the Cron Job. Regards, Sagar Webiots Relevant Skills and Experience Cron job Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(100 Değerlendirme)
in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(89 Değerlendirme)

HI, My name is Rohit and i am full time freelancer having 5+ year experience in web development. Relevant Skills and Experience I have experienced in PHP and cron job. Proposed Milestones $50 USD - Project Milestone Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(116 Değerlendirme)

If you let me have a look to the program, I can check whether it can be drastically optimized to remove the cause of the problem (for instance, using MySql LOAD instead of INSERTs?). If no apparent optimization can be Daha Fazla

in %bids___i_period_sub_35% gün içinde170%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(48 Değerlendirme)

Hi, Nice to bid you. I can do it very fast in reason of my full resources and development experience what I have accumulated by now for while developing a variety of sites. Relevant Skills and Experience PHP&PHP Frame Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(81 Değerlendirme)