Find Jobs
Hire Freelancers

slow MYSQL DATABASE / BEST MYSQL OPTIMIZER

$30-250 USD

Closed
Posted over 4 years ago

$30-250 USD

Paid on delivery
I have a shared hosting account on hostgator. This is not a dedicated server. It is a shared hosting account. I have mysql database with 10,000 records and php admin control panel that is very very slow. I need you to optimize the database to make it a lot faster. $100 to the first person who can do this. This is fast easy work if you know what you are doing. If you want this job answer this question 1. What exactly will you do to make this database faster. It takes 5 minutes to load each page .. what can you do to make it faster? 2. do you know php? if you do how many years have you been working on php? 3. do you know mysql? if you do how many years have you been working on mysql?
Project ID: 22427389

About the project

33 proposals
Remote project
Active 4 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
33 freelancers are bidding on average $150 USD for this job
User Avatar
Hello, if you give me temporary access I can tell you what's wrong. Maybe indexes are not properly set. Also, optimizing database will help. I know php and mysql; I can check it. I am working for 10+ years.
$100 USD in 1 day
5.0 (1307 reviews)
8.7
8.7
User Avatar
Hello hiring member i hope you are doing well i am bhavika i have 4+years experience in php , laravel ,ajax , jquery , javascript , html ,css , bootstrap i can do it let me share all answer what i have experience :) 1) we get those data with ajax so it will be fast and it will be fast and it will not take that much load 2)i have 4+years experience in core php and advance php with many projects 3) i have done many mysql job with my 4+years experience like mysql customizaion and many things i hope you will like my bid so please give me chance to serve you thanks in advance :)
$100 USD in 1 day
5.0 (244 reviews)
8.0
8.0
User Avatar
Hello Hope you are doing well. I have 7 years of experience in Linux and Server Management. I can handle this project. If that is shared hosting , Slow query finding will be difficult . I will host in our server and check slow query and work on hostgator 1. What exactly will you do to make this database faster. It takes 5 minutes to load each page .. what can you do to make it faster?: Fix Bad query with slow query log 2. do you know php? if you do how many years have you been working on php?: yes, 3 year 3. do you know mysql? if you do how many years have you been working on mysql? yes, 5 year
$100 USD in 1 day
4.9 (626 reviews)
7.6
7.6
User Avatar
Hello, 1. What exactly will you do to make this database faster. It takes 5 minutes to load each page .. what can you do to make it faster? 100% it's the query you have I need to check the php files to know how do you query that mysql records. 2. do you know php? if you do how many years have you been working on php? 3 years 3. do you know mysql? if you do how many years have you been working on mysql? 3 years
$100 USD in 1 day
4.9 (83 reviews)
7.4
7.4
User Avatar
Dear Customer! I am an expert PHP developer with over 14 years of experience. Very interested to work on your project. My bid is for top quality work. Available to start immediately and finish as soon as possible. Please contact to discuss details. Thank you, zeke
$100 USD in 5 days
4.6 (201 reviews)
7.5
7.5
User Avatar
1. What exactly will you do to make this database faster. It takes 5 minutes to load each page .. what can you do to make it faster? - Indexing of the pages and optimizing queries 2. do you know php? if you do how many years have you been working on php? - 10 years 3. do you know mysql? if you do how many years have you been working on mysql? - - 10 years
$100 USD in 1 day
5.0 (135 reviews)
7.1
7.1
User Avatar
Hello, i working with mysql for a long time. we using it in voip so we got big tables and a lot queries. 1. What exactly will you do to make this database faster. It takes 5 minutes to load each page .. what can you do to make it faster? it may be because: tables not have indexes for columns, query are not good, mysql server has not cache for some tables. 2. do you know php? if you do how many years have you been working on php? i am working with php for few year, so it's easy for me to understand php code for analyze and fix. 3. do you know mysql? if you do how many years have you been working on mysql? for a long time, because it's most of common database using by voip software.
$200 USD in 3 days
5.0 (56 reviews)
6.6
6.6
User Avatar
I have experience in deploying and maintaining of: Cloud Computing Platforms: AWS Amazon Web Services,Microsoft AZURE, Google Cloud (GCP). Server Operating Systems: Windows Server 2003-to-2012R2, Windows Server 2016 Amazon Linux, Debian, RHEL, CentOS, Ubuntu. Web servers and servlets containers: IIS, APACHE, NGINX, DOCKER Mail servers: POSTFIX, EXIM, MS Exchange 2000-to-2013, MS Exchange 2016, QMAIL Database servers: MySQL, MS SQL Virtualization: MS Hyper-V, VMware Server(ESXI), VirtualBox. Directory service: Active Directory, OpenLDAP. File servers: IIS FTP, proftpd, FileZilla FTP Server, SAMBA. Firewalls: Windows firewall,ISA/Forefront TMG, MikroTik,PFSense Zywall and other Routers; Data Storage Systems: Netapp, FAS, EMC, VNX Virtual Private Network (VPN) OpenVPN, IPSEC,P2P,S2S VPN, Microsoft VPN, OpenConnect VPN , Mikrotik VPN , PFsense VPN. Hosting Panels: PLESK,cPanel,Website Panel
$150 USD in 1 day
4.9 (369 reviews)
6.8
6.8
User Avatar
Hi, I am ready to start right away. I have reviewed your job description as well and very confident to handle this project perfectly. I will do multiple revision in your project with 100% satisfaction work guaranteed. Can you send me a message? Then we can discuss the details and build a long term & healthy business relationship. Thanks & regards Rahul
$48 USD in 2 days
5.0 (205 reviews)
6.4
6.4
User Avatar
I am good in php, MySQL, phpMyAdmin along with optimization and scripting like powershell, perl etc Please let me know if you are good to award this project to me 1. What exactly will you do to make this database faster. It takes 5 minutes to load each page .. what can you do to make it faster? ANS: will explore your table structre first and then I will decide what are the key columns need to make index and do some normalization stuff, also need to understand your infra capacity 2. do you know php? if you do how many years have you been working on php? 10+ Years 3. do you know mysql? if you do how many years have you been working on mysql? 10+ years
$112 USD in 2 days
5.0 (87 reviews)
6.5
6.5
User Avatar
Hello, I will check and resolve the issue as per your requirement. I have 5+ Year experience in Php with different different freamwork I have 5+ Year experience in Mysql with different different freamwork Looking forward here. Thanks
$100 USD in 1 day
5.0 (174 reviews)
6.4
6.4
User Avatar
Hello, I'm pretty good at MySQL optimization. I won't reply to your first question as it is .. not related to anything, it is like calling a mechanic and tell him .. what does my car have as it is broken :) I have 10+ years in both php and mysql. I ask 200 usd as there it may be a lot of debug required to see why it is so slow (maybe a code issue, maybe a mysql structure issue). Regards Sorin
$200 USD in 7 days
4.9 (224 reviews)
6.7
6.7
User Avatar
I am working on latest web technologies for more than 5 yrs. I have extensive experience in php,mysql. I have viewed your job requirements. Fou loading quickly, I will review mysql queries and optimize all queries and if need will add indexes in database tables. I have knowledge and working on php and mysql more than 5 yrs. Ready for your work. We can discuss more details in chat. Thanks
$160 USD in 3 days
5.0 (82 reviews)
6.4
6.4
User Avatar
Hi, there! Nice to meet you. I'm a senior web developer with 10 years of experience. I've a great experience with Database Optimization so far. Your problem seems there is a problem with MySQL Query. I'll optimize the Queries for you. I think the Join and Select queries should be make it slow. I've extensive experience with PHP and MySQL over 7 years. I'm sure I can complete your task in the shortest time. Let's discuss more details in our chat Best Regards
$100 USD in 1 day
5.0 (9 reviews)
6.1
6.1
User Avatar
Hello Sir! I have checked your requirement. I can speed up your site. 1. I would do indexing on your database and apply pagination on your web pages. 2. I have experience of more then 5 years in php. 3. In many projects i have used mysql database. For further discussion leave a message. Thanks.
$100 USD in 2 days
5.0 (104 reviews)
5.8
5.8
User Avatar
Hello my name is Nikos and Im working on the Linux server administration field for the past 6 years. Over these years I worked for two web hosting companies as a Senior Administrator managing their servers & providing customer support. I have extensive experience with the following control panels: CPanel, Plesk, Directadmin, SolusVM, VestaCP and many more. Depending on what kind of website do you have, we could possibly implement caching but this involves switching hosts. Message me for more details. Regards
$140 USD in 7 days
5.0 (58 reviews)
5.6
5.6
User Avatar
Hi Nice to meet you 1. SQL restructuring. 2. Woocommerce, eCommerce, Wordpress and Laravel etc, I developed many websites. 3. This is also same like PHP. MySQL is paire with PHP. Thank you.
$250 USD in 7 days
4.3 (23 reviews)
5.7
5.7
User Avatar
hi the problem seems to be processing when record loads in php memory. if you can share particular block of codes and dbms structure. I am core php developer having 8 years of experience in techs around php/mysql. regards
$111 USD in 1 day
4.9 (9 reviews)
3.6
3.6
User Avatar
Hello sir. High-quality & Fast-delivery is promised! As a highly skilled full stack developer and I can help you perfectly. I am very confident with my skills and I'd like to help your business by doing my best. My clients have never been frustrated with my work and I hope to make you one of them. I am able to work full time on your timezone and start working right away. Please confirm that I am one of the best fits for you and drop me a message for further discussion. Thanks and Best Regards.
$300 USD in 7 days
5.0 (3 reviews)
2.5
2.5
User Avatar
I can do your data entry work with my hard working I will gave you my best try my best work for your company I'm very happy to work with you.
$35 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
mission hills, United States
4.8
910
Payment method verified
Member since Apr 18, 2008

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.