Find Jobs
Hire Freelancers

Speed up MYSQL or SQL database Percona? other options?

$30-150 USD

Closed
Posted over 7 years ago

$30-150 USD

Paid on delivery
I have a database with 40 million records. It is on a dedicated server. The database is growing every few days. Everything works fine but after running a "filter" and then proceeding to download the data, it takes 15 minutes to download 100,000 records. I need to download a few million records each day. This download time needs to be SERIOUSLY sped up. I dont know if its the php scripts the programmer used for the "filter" but it's too slow. I have heard Percona can really speed things up. I am open to solutions.
Project ID: 11622180

About the project

23 proposals
Remote project
Active 7 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
23 freelancers are bidding on average $159 USD for this job
User Avatar
Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce,vBulletin , Zen cart-Drupal , android and IOS , I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
$154 USD in 7 days
4.7 (533 reviews)
8.4
8.4
User Avatar
Hi ! is this the same project as the https://www.freelancer.com/projects/php/Speed-SQL-Databse-Download-Speed/ or a new one ? Let me know, Rudy Frenchlancer.
$125 USD in 7 days
5.0 (27 reviews)
6.7
6.7
User Avatar
Hi Please pick me for this task. See my project history for details. About the query. MySql with MyISAM engine is able to deliver 100k rows per second in some cases. The most likely the "filter query" is overcomplicated and need to be optimized or reimplemented. I do not think Percona will solve the issue since Pecona is just MySql claster. Before accepting my bid I suggest you to send me sql "filetr query". I'll have a look and estimate how it could be improved. All the best Alexei
$50 USD in 3 days
4.9 (84 reviews)
5.9
5.9
User Avatar
Hello, Hope you are fine. I have read your requirements; I am expert in all required skills and ready to start work immediately. Please open chat with me so we can discuss more in details. Hope we ll work together. Looking forward to hearing from you. Best Regards, Waheed Gondal
$138 USD in 3 days
5.0 (15 reviews)
5.4
5.4
User Avatar
+Dear Project Owner, Hope I am approaching you in best of your health and spirits!! I can be a suitable match for your work as I am having 8 years of experience in Website designing,SEO,SMO. I completely fit into the requirements you have framed for the designer. Hence, it would be great if you can open a line of communication so that I can analyze and share some mockup designs which will help you gain confidence in my abilities. For further discussions I would appreciate it if you can have spare time from your schedule and communicate convenient. Once we come into contact with each other we will be able to prove our competency. Thanks and Regards Arun Singh Kushwah.
$30 USD in 3 days
4.8 (31 reviews)
5.1
5.1
User Avatar
I am mysql dba having more then 7 yrs of experience. I am expert in tunning and optimization , you can check my feedback on mysql... can we discuss
$55 USD in 1 day
4.8 (60 reviews)
5.3
5.3
User Avatar
Dear Employer, 1) What's the size of DB backup (.sql) file when you take the backup. 2) Its true that using percona you will definitely get the increase in performance due to change in Storage Engine. Percona uses XtraDB as a default storage engine. About myself, Overall 6 yrs of exp in Linux and 3.5 yrs in LAMP, MySQL troubleshooting and tuning
$108 USD in 3 days
5.0 (84 reviews)
5.0
5.0
User Avatar
The best solution i could advice at this scale of data processing is database clustering. I might be able to setup it for you and migrate data. Please see my reviews for some references. We could always discuss the details via chat. Thank you.
$175 USD in 7 days
5.0 (38 reviews)
4.6
4.6
User Avatar
Hi there, Thanks for posting your project we are interested in your work & have vast experience in blog creation & customization. We will fix out the problems & that all will be done in few hour & you can check the changes as well.
$100 USD in 3 days
4.8 (14 reviews)
4.1
4.1
User Avatar
Hi there, I would recommend to migrate your database to cloud like aws rds which 100℅ resolves the issue you are currently facing. Let us discuss more over the chat. Regards, Imran Ahmed
$35 USD in 3 days
5.0 (6 reviews)
2.4
2.4
User Avatar
What kind of SQL server are you running? The query itself is likely flawed, I can look into this for you, will take likely 1 day but have said 3 to be conservative.
$111 USD in 3 days
5.0 (1 review)
2.0
2.0
User Avatar
Hi, I've 15 years of experience with web development and administration of web hosting servers. I'll like to check your schema data base, index and normalization and tune up queries, to give you a report and possible fixtures to optimize your results.
$110 USD in 5 days
4.8 (2 reviews)
1.1
1.1
User Avatar
JAYMAN INFOTECH PVT LTD is a contemporary Website design and development company with a focus on user-centered design while helping our clients achieves the desired result. we are a custom software development company providing custom IT based solutions for the modern business offer bespoke Custom application Development to small, medium and large business including startups. Service Description We provides IT services in the following areas: - - Mobile Programming * iOS 7 and 8 application * SWIFT programming * Xamarin ( MVVMCross for multi-platform) * iPhone / iPad * Android and NDK programming * BlackBerry * Hybrid programming (PhoneGap, Accelerator Titanium) - Software Engineering / Architecture * Windows / Mac OS x / Linux Software * Image processing * E-Learning System - Web * Server management * PHP programming (WP, CI and etc) * Front-end and web service programming - Database * MySQL * SQLite * MogoDB NOTE:OUR TEAM STRENTH 25...ALL THE PLATFROM AND ALSO WORK IN S.E.O AND S.M.O,PPC AND GOOGLE ADWORD
$944 USD in 45 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an experienced linux system admin, as well as software developer, database admin. I can perform your requests, I think.
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
An experienced MySQL DBA with good knowledge of MySQL and its forks. I can speed up the query and make a change for you.
$140 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I optimised number of database for different clients successfully. Database is my strongest part.
$166 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Scottsdale, United States
5.0
45
Payment method verified
Member since Feb 18, 2009

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.