Find Jobs
Hire Freelancers

Optimize mySQL database with 10 million rows

$30-250 USD

Closed
Posted about 9 years ago

$30-250 USD

Paid on delivery
I have an adult video website, with 5.5 million rows of video, it is slowing down. It is your job to alter the mysql database and the php code to make it fast. The script used is clip-bucket. Expected server response time: under 200 ms. You are required to work as fast as possible as my site is losing SEO rank. Payment is released only after I see work.
Project ID: 6975606

About the project

15 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
15 freelancers are bidding on average $155 USD for this job
User Avatar
Hello, I can optimize both Database and the code to obtain the expected result within next 8 hours, maybe earlier
$210 USD in 1 day
5.0 (58 reviews)
5.7
5.7
User Avatar
Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you’ll come to us again and again to avail our services. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project. Thanks, Priyanka
$273 USD in 8 days
5.0 (20 reviews)
5.6
5.6
User Avatar
I have years of experience with PHP development and MySQL administration, so I will be able to find bottlenecks and remove them, to make your site load faster. Beside that, I can provide you with server tuning tips, to additionally speed up the whole site. If you have any questions, do not hesitate to contact me. Best regards, Damir
$200 USD in 3 days
5.0 (56 reviews)
5.2
5.2
User Avatar
That is a healthy size database. It will require some thoughtful analysis to optimize. I specialize in optimizing VLDB (Very Large Database) systems and have the experience required for this project. The last VLDB system I optimized was for an Oil & Gas company. They had 150M+ records which occupied 1.5 Terabytes of drive space. Queries took 10-30 minutes to execute. Using advanced optimization techniques I was able to reduce those to 1-5 seconds each. My method is as follows. 1. Create a local Virtual Machine with the PHP script(s) and MySQL database. 2. Profile the application as-is, find the bottlenecks. 3. Discuss my recommendations with you. 4. Implement the recommendations on your production web site. I create a local VM so that I can perform in-depth surgery on the application without impacting your production system. Then, once I have a solid plan to optimize the system I can implement it online. Here is some recent client feedback on my profile. "Best freelancer I've worked! Professional, quick, & highly skilled. Optimized my database loading issue, its now quicker than expected! I highly recommend anyone to work with Jay." "The stars aligned to find such a perfect match for this job! Awesome out of the box thinking by Jay improved our system's speed by over 100 times. I will be using JCS Consulting again!" I have some questions regarding the project that could be quickly discussed via chat. Please let me know if that works for you. Best regards, Jay
$240 USD in 4 days
5.0 (12 reviews)
5.0
5.0
User Avatar
6+ years experience in Linux Server Administration, extensive experience in installing, configuring: APF or CSF Firewall Apache & MySQL optimization MySQL optimization Database issues, backup and repair DNS configuration issues Load balancing PHP configuration, upgrades, and site errors Security lock down Disaster recovery Seamless Server migrations Proactive Server Monitoring Guaranteed Uptime Installing and configure new servers Firewall Installation and configuration Security Audit and Server Hardening Securing and Upgrading of SSH Server Installation of third party software and scripts LightSpeed and nginx Installation & configuration Kernel updates Exim tweaks – spam source detection and prevention Malware removal Plugin installation and configuration Backup configuration using either the internal control panel features, custom backup, rsync, or service such as R1Soft Failing services Disk space issues Fffmpeg and video Ttools And much more.
$222 USD in 3 days
5.0 (8 reviews)
2.7
2.7
User Avatar
Hi Nice to meet you on this site. Thanks for your job posting. We saw your requirement carefully. Read my proposal carefully and reply me please. Company name : ShangSheng IT Company Number of member : 20 Degree : All member graduated from University in china. We all has master of Software engineering. Reviews : We has been worked many large projects like enterprise software. We are from elance online job site. So we are new contractor on this site. Now, 10 member of us are working on elance for new project (Price : $12000) You can check on elance as ID : act_ws415 We likes large project because we are company. If you need more information of us , we can suppose the document for our info. Skill : wonderful WebDesign with responsive design such as HTML5, css3, bootstrap,angularJS etc and best quality backend with ASP.net, C++&C# programming , software architecture , Java, PHP Database programming and Mobile such as android, ios, windows mobile.. We hope to work with you. Thanks again.. BestRegards. *ShangSheng IT COMPANY*.
$277 USD in 5 days
4.4 (1 review)
0.2
0.2
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
hello sir, come for chat to know more details about your project . thanking you Regards DatavisisionITC
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm an expert DataBase Administrator and web developper. I'm used to work for big clients in France outside freelancer. I'll provide only best quality work, please provide more details by mp :sitebucket version, website url, and if you can mysql version, hosting type ( dedicated, VPS ...) so i can have an idea for possible urgent optimizations. Sincerely yours, Eric
$150 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I work in 24/7 linux servers supports. I can help you with mysql setting optimization. It is ok if accept me after getting result. Best regards, Eugene D.
$35 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to take this challenge, i have more than 10 years experience in MySQL /ORACLE/DB2 Administration and Development , and i have hands on experience in C++/, Java,PHP, SQL, PLSQL Programming. I am totally agree with you on Payment condition. Looking forward to hearing from you soon. Please reachout me 00601116311823
$222 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$97 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have very much experience with database optimization. Your project is easy for me to complete in a timely manner. The things that i will do: -Analyze and optimize mysql configuration -Analyze/Enable/Tune query cache -Analyze Mysql queries -Add the proper indexes to tables -Adjust sql queries if they are creating temperary tables Please contact me. I understand this project is on a no cure no pay basis, i am very confident i will resolve this professionally.
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of LEBANON
Hadath, Lebanon
5.0
11
Payment method verified
Member since Mar 16, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.