Fix: MySQL queries create tmp tables to disk

Budget $25 - $50 USD / hour
Bids 11
Average Bid $30

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.

Post a Project Like This

This project was awarded to

About the Freelancer

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • anshukaushikraj Profile Picture

    anshukaushikraj

    mumbai,  India

    Hi, I am basically MySqL performance and benchmark experts. Can help anyone with SP,triggers,Dynamic SQL and complex queries for MySQL administration also

    Linux, SQL, Sports, and Phone Support

  • tsbcrop Profile Picture

    tsbcrop

    Hyderabad,  India

    We are professional spftware development company with the following skills: AJAX, Java, J2EE, Mobile App expert

    ASP, Java, JSP, and Javascript

  • xcitestudios Profile Picture

    xcitestudios

    Acomb,  United Kingdom

    Specialising in PHP and Javascript jobs (including client-server communication such as AJAX) with graphic design if jobs require both coding and design. MySQL optimisation expert and CouchDB expert. Areas of Expertise: PHP, MySQL, CouchDB, Linux, Javascript, AJAX, VB.net, HTML, xHTML, CSS

    PHP, Javascript, XML, and Python

  • pivn Profile Picture

    pivn

    .,  Vietnam

    + Software Engineer + Database Administrator (MS-SQL, MySQL, Oracle) + System Admin, Linux, Windows Server. + Lecturer Works with : - C/C++, Java, C# Programming Guru - J2EE/JavaEE, Struts, Spring, Hibernate, EJB3, Webservices with Restful, AXIS2 - PHP, HTML5, CSS3, JavaScript, jQuery. - Android, Windows Phone 8. - eCommerce, WordPress, Open Cart, Joomla, Drupal, Magento, TYPO3, MODX, vBB, etc. - Windows Server, Linux Server - Mathematics. - Malware removal* - Hacking recovery* - Website monitoring - Security Audit WORDPRESS: + Install and config the project + Plugin: Customize and create new plugin with MVC structure + Template: Create, adjust the template (include design graphics or not) with tableless WordPress design (CSS / DIV) + Migrate & Upgrade: Are you using the website without WordPress or with WordPress and you want to migrate or upgrade to WordPress with a higher version? I can do this very fast and exactly for you. + Advanced SEO (search engine optimization) I can do that for you, if you like and I'm glad I have a chance to work with you all. Trust me for your project and you will see the value of difference!

    PHP, C Programming, Java, and Website Design

  • PauloAngeloCOM Profile Picture

    PauloAngeloCOM

    Brasilia,  Brazil

    Work professionally for 12 years with networks and is finishing PhD in Mathematics.Worked at big companies like Conectiva S/A (now Mandriva S/A), RedHat's partner and high governmental units. Now work at brazilian government and as external consultant as freelancer.

    System Admin, Linux, Computer Security, and Cloud Computing

  • codetrance Profile Picture

    codetrance

    Zwolle,  Netherlands

    Expertise: Translation (English, Dutch and German) Intrusion Detection System Amazon EC2 Management Cloud Management High Availability (HA) Clusters PCI DSS Compliance Compromised Server Recovery Malware Removal Security Audit Mail server, SPAM prevention setup Server Optimization For Fast Pagespeed (Wordpress, Joomla, Magento, etc...) OpenVZ, XEN & KVM Virualization Capacity Planning Consultancy Monitoring Much More!

    PHP, Translation, System Admin, and Linux

  • willwesley Profile Picture

    willwesley

    Colorado Springs,  United States

    Experienced intranet application developer, skilled with PHP, jQuery, HTML5, CSS3, MySQL, and T-SQL. Experienced with both Apache and IIS server environments.

    PHP, XML, Graphic Design, and Linux

  • phpSQLexpert Profile Picture

    phpSQLexpert

    Gombak,  Malaysia

    PHP and MYSQL expert on Wordpress, major eCommerce Scripts,Magento, creloaded,phpBB, forums, fixing, debugging, remote posting,PayPal Payment Integration, DirectAdmin, cPanel, Kloxo (XLabs), cURL, web sites fetching & leeching, modifying and hacking, website optimization and maintenance :)

    PHP, Javascript, XML, and Linux

  • truongngocthanh Profile Picture

    truongngocthanh

    Ho Chi Minh city,  Vietnam

    I do good work as a database developer, data processing as well as developing applications using the web. Areas of expertise include Coldfusion, .NETand web full-stack. I am also expert in HTML, JavaScript, CSS (frontend developing)

    PHP, ASP, Java, and Javascript

  • Ekushey Profile Picture

    Ekushey

    West Dhanmondi,  Bangladesh

    "You're awesome!" - A Freelancer.com employer I'm known for my fast turnaround time and ability to fix difficult problems that other freelancers have failed to solve. As I always say, hire me when everyone else fails, and I'll not leave you disappointed! In 2012, I was selected as the first-ever Featured Freelancer by Freelancer.com. As of 2015, I'm a part of Preferred Freelancer program, the group of elite the elite freelancers as they say. My timezone is GMT +6, though I work round-the-clock to cater the needs of my clients in over 60 countries worldwide.

    PHP, Perl, XML, and Script Install