Fix: MySQL queries create tmp tables to disk

In Progress

Our website which is hosted on a VPS is using Wordpress. Recently we are facing a problem in which MySQL queries create tmp tables to disk which leads to high use of RAM and CPU which leads to server failure.

We are searching for an experienced database/MySQL programmer to solve this issue out.

Skills: Database Administration, MySQL

See more: c# database mysql, queries, disk, fix cpu, queries wordpress, wordpress administration, vps fix, vps problem, wordpress database mysql cpu, mysql administration, mysql queries using, wordpress cpu fix, joomla component create mysql tables, using phrets create mysql tables rets, fix mysql cpu, wordpress website cpu, wordpress mysql problem, wordpress cpu, read xml file create mysql tables, high mysql cpu, fix mysql database, database queries wordpress, create tables, cpu mysql, fix tables

Project ID: #4515547

Awarded to:

xcitestudios

This could be a number of things, such as queries not using indexes correctly or the amount of data being worked on is greater than the configuration options set for the maximum temp table in memory size. I can inve More

$27 USD / hour
(94 Reviews)
6.5

10 freelancers are bidding on average $30/hour for this job

bhavinhjoshi

Hello, I have provided the details in private message. Please check PM. Regards.

$30 USD / hour
(12 Reviews)
5.2
Ekushey

It's a normal behaviour of mySQL to write on /tmp, but it shouldn't lead to high load on the server. What exactly is going on?

$26 USD / hour
(41 Reviews)
4.8
codetrance

Please check your PMB. Thank you.

$30 USD / hour
(22 Reviews)
4.7
truongngocthanh

Hello, I can help you to check your mysql server and solve it. Thanks

$27 USD / hour
(11 Reviews)
4.5
pivn

Let expert do this

$27 USD / hour
(23 Reviews)
4.4
phpSQLexpert

Hi. I can help you on this. My previous company has huge mysql database load but this can be fixed

$31 USD / hour
(6 Reviews)
4.1
willwesley

I have a lot of experience resolving MySQL performance issues. I am bidding a minimum of three hours, in which I will analyze your system and any simple fixes with a high ROI will be implemented. Before exceeding the 3 More

$30 USD / hour
(2 Reviews)
3.2
PauloAngeloCOM

Expert here. Take a look at your private messages.

$25 USD / hour
(3 Reviews)
2.2
anshukaushikraj

MySQL tuning and performance expert!!!

$33 USD / hour
(0 Reviews)
0.0
tsbcrop

********** HOPE TO GRAB YOUR ATTENTION ********** The plugins you use must be the reason for such volume of tmp tables. I can fix your problems.

$41 USD / hour
(0 Reviews)
0.0