Completed

Improve mysql performance

We developed a platform using wordpress where all users have to create accounts, log in, edit their profile, publish posts, search between posts, etc. So we use the database heavily. The problem is, when the database reaches 45 - 50% of CPU and about 20% of RAM with 0% SWAP usage, it becomes very slow and all requests time out. It´s strange because it´s using only half of our resources. So I need someone to help me fix that. Please start your bid with "hola jose". The lower the bid the better.

Skills: Database Administration, Linux, MySQL, UNIX, Web Hosting

See more: mysql search performance, add edit profile image php mysql, improving joomla performance mysql, php, mysql, wordpress, database administration, linux, web hosting, system admin, unix, suspended due performance mysql server, performance mysql prestashop, magento performance mysql, mysql improve security, stored procedure performance mysql, identify mysql database, joomla performance mysql optimize, improve table structuremysql query query time alot lower, import date time mysql fields

About the Employer:
( 10 reviews ) Santa Ana, El Salvador

Project ID: #9377145

Awarded to:

pdq

hola jose! Hi, i currently work in a datacenter as a linux servers administrator, so i believe my skills are quite enough to solve your problem. any kind of webhosting work is my daily routine, so i'm ready to start More

$55 USD in 1 day
(129 Reviews)
5.9

19 freelancers are bidding on average $113 for this job

TakeReal

Hello, My name is Sergey. I am Freelancer from [login to view URL], Russia. I can help you as SQL guru to improve MySQL performance. I can foresee: you have insufficient SQL queries and these queries slow down MySQL se More

$200 USD in 3 days
(1079 Reviews)
7.4
vili1977

"hola jose" Hello. I would like to help you with mysql optimization and WP perfomance. I have experience. Please read my feedbacks.

$55 USD in 1 day
(444 Reviews)
6.7
sabdsouza

"hola jose" I would be needing server root ssh login details to fix this, do let me know if you need my assistance. Regards, Sebastian

$45 USD in 0 days
(194 Reviews)
6.7
codetrance

Do you have root access to your server?. I'm looking forwards to your response. Thank you.

$65 USD in 2 days
(167 Reviews)
6.4
Yknox

Hello I'm interesting your project very well I'm a Good Java, PHP, WP, DB, Math, Algorithm expert. I understand your req exactly. I m quite well experienced in these jobs. Let's go ahead with me I want to ser More

$161 USD in 1 day
(74 Reviews)
6.8
mrfixersl

Hi, How much ram do you have? Is your server a VPS or a dedicated server? In each case how many cores does it have? Also, do yoi have any control panel such as WHM/cPanel etc installed?... Let me know. I would love t More

$100 USD in 3 days
(129 Reviews)
6.3
drailean

hola jose Could you please tell me, what's your server configuration? And how do you monitor the resources? Do you also have the mysql slow query log enabled and you could maybe send it to me? How many queries per s More

$200 USD in 7 days
(126 Reviews)
6.2
blackjk

Hello! How many cores in the your server? May be MySql uses one core from two (it's 50%) And, what about disk queue (how mach)? You use InnoDB or MyIsam? (try to use MyIsam for higher speed, but lower stability) Best More

$155 USD in 3 days
(26 Reviews)
5.1
vinaysinghh

hola jose ...I am mysql dba having more then 5 yrs of experience and very good experience in database tunning

$55 USD in 3 days
(46 Reviews)
5.3
vtechiti

hola jose I have gone through your requirement and will be glad to work for you. Please take a look of some of the website done by me: ===================================================== [login to view URL] More

$88 USD in 3 days
(19 Reviews)
4.8
itmonks

"HOLA JOSE " Hello, Hope you are fine I read your full job description and capable to complete this project successfully. I am expert Database Administratior having experience more then 5 years and having exten More

$50 USD in 1 day
(7 Reviews)
3.6
$88 USD in 3 days
(0 Reviews)
0.0
caagarwaljain

Greetings! I am qualified Accountant, Certified Quickbook ProAdvisor and hold dual bachelor degree in Commerce and Law. I have completed Level II of ICAI (Equivalent to ACCA/CPA) and also a member of the Institute of C More

$155 USD in 3 days
(0 Reviews)
0.0
srvdbdev

Hello. If your database is hunger for CPU it means that your database doesn't have required indexes. I will propose the following approach: - review slow log/general log and optimize performance - reviw config my More

$100 USD in 3 days
(0 Reviews)
0.0
hexagoninfosoft

Hello, We had gone through your project requirement we would like to know that are you using a shared hosting or it is dedicated? Could you please help with the answer of this question so we can help you in preci More

$250 USD in 3 days
(0 Reviews)
0.0
kaktus79

Hola Jose, I am the creator and admin of about 400GB MySQL database searching records in less than 2 seconds. I will hapily try to help you.

$155 USD in 5 days
(0 Reviews)
0.0
$54 USD in 3 days
(1 Review)
0.0
exceltpl

We are resolve your issue. We have expertise in Web Development and System Admin. Before, proceeding further, I would like to know type of Disk (SATA / SSD) and raid (RAID 0, 1, 10, 5) you are using. You could be fac More

$111 USD in 3 days
(1 Review)
0.0