Find Jobs
Hire Freelancers

Server Optimization (Nginx-Wordpress, database with high number of entries)

$30-250 USD

Completed
Posted over 7 years ago

$30-250 USD

Paid on delivery
I am running WordPress site on Linux dedicated server with config: Cent os/nginx/php-fpm/mariadb, disks are in raid 10 configuration. Since there are a lot of search queries and database tables with high number of entries server load started to go up and it is pretty high now, also a lot of search queries ending up with timeout error. Need someone to optimize the database queries, to optimize mysql and php configuration on server to work best with wordpress, also wordpress optimization is needed. Server specs: HP ProLiant DL120/Intel Quad-Core Xeon X3440 ( 4x2TB ). The freelancer that i choose for this job will also be first choice for all further projects of mine. Site traffic is around 10k daily visitors so it will need further adjustments in the future.
Project ID: 11275788

About the project

10 proposals
Remote project
Active 8 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
Awarded to:
User Avatar
Hello from Greece, Do you have SSH access to the server? May I check the nginx / php-fpm / mysql configuration? Would you like to have a chat? Regards, Dimitris
$66 USD in 2 days
5.0 (317 reviews)
6.7
6.7
10 freelancers are bidding on average $182 USD for this job
User Avatar
Hi there, I am ready to start now, I am expert in - VOIP / Asterisk PBX - Linux RedHat/Centos and other distributions. Installed and managed thousands of servers. - Amazone WebServices EC2 / SES - WebMin / cpanel / DirectAdmin / ISPconfig - WordPress / HTML / CSS / CorePHP - Apache / Varnich / Nginx / LightSpeed / SVN - Interspire / PowerMTA / Postfix / Exim / OEMPRO - Linux Server Security - FreeBSD, HPUX, Solaris - Network design / implementation, ip allocation, management - Network security - Datacenter management - Experience with various web hosting control panels - Advanced monitoring - Backup systems - Advanced management and provisioning for various services like HTTP, MySQL, PgSQL, FTP, DNS, SMTP, POP3, IMAP, SSH - Backtracing hackers, cleaning abused servers, mitigating DDoS attacks, cleaning/fixing spamwaves - Domain registration, SSL certificates management - Programming: advanced PHP, ASM, C++, API implementations - Basic web design skills (javascript/css/html and design software) - Problem solving, tech support, troubleshot, debug, customer support - Load balancing and clusters, cloud - Data recovery (deleted/destroyed drives) - Testing, evaluating, maintenance, tuning hardware and software I am available for the discussion related to this project, Also be assured work will be done on time agreed and excellent support will be provided
$277 USD in 3 days
4.8 (1141 reviews)
8.6
8.6
User Avatar
HI this could be just not the server side but also the wordpress side too. Because you must running un optmized quries which make the server load very high and your mysql server must be getting busy because of that and long queries may results in down the mysql server and thats y you are getting timeout issue. First we have to fix the site and identity the php quires that make the server load high. We can do this with php profiler. Then implement a cache system this way we can reduce the load to server. Then we have to add indexes to tables to make sure the data are load faster. Thank you
$368 USD in 5 days
4.9 (227 reviews)
8.1
8.1
User Avatar
Hi, I am a developer and designer from India and a Linux enthusiast. I have done more or less every kind of website designing & development and act as system admin for my own servers. I can assure you perfection and punctuality. If you see me suitable for your work, please let me know in chat. Regards
$166 USD in 5 days
4.9 (66 reviews)
6.5
6.5
User Avatar
May I know how much RAM do you have in server?. I'm looking forwards to your response. Thank you.
$110 USD in 1 day
5.0 (176 reviews)
6.5
6.5
User Avatar
Hello! My bid is for the following procedures, that will fix your problem: - Check the server configuration to see if everything is right on the hardware, that involves checking smart errors mostly and some log files. - Check the operating system, the CentOS, if everything is well setup and any errors is coming up, also check if the filesystem is too busy leading to problems with the database. - Next will check the database for the queries, maybe you got a not optimized table, some missing indexes or maybe the queries are badly written leading to filesorts and stuff like that. - Will also check the webserver and php structure, but by your brief it may not be the problem. I don't think so, since 10k visitor per day is not that much for a server like this, but it may be possible that the hardware can't handle, in this case will help you with the server migration and choice within this project context, with no extra charge. Most improvement will be seen at first hours, but will need some time to fine tune the server since some symptoms only show when there's a high load. Will need full root access to the server via SSH to do all this stuff. If you have any doubts please tell me. Thanks for reading and hope to make business, Vinicius
$222 USD in 3 days
4.6 (18 reviews)
4.7
4.7
User Avatar
Hi, if you need someone to join you, maybe I can help! I work with MYSQL, WordPress, Linux. PHP< HTML, Flash, Dreamweaver, CSS, Javascript. Anyway I work in my own Home! Cheers
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SERBIA
Pristina, Serbia
5.0
23
Payment method verified
Member since Dec 12, 2011

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.