176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

fix slow queeries in mysql
Sign in to Add to Watch List

IT & Programming > Database Administration

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Feb 27, 2014

Job description changed. New Version|Previous Version

Feb 26, 2014
Close

Job Description

  |  Change History >>

Updated

I recently got this message from my server tech support The Repair continues to run one thing i do notice is your server has a lot of slow queries. I would advise you contact a developer to look over your MySQL databases at your earliest convenience. Your databases need to have there tables looked over and queries indexed. I will continue to monitor this repair although i have no ETA on how long it will take to run. Below i have listed the current MYSQL status and the location where slow queries can be viewed. # root@server [~]# mysqladmin status Uptime: 668059 Threads: 235 Questions: 199527579 Slow queries: 222 Opens: 23761 Flush tables: 1 Open tables: 15501 Queries per second avg: 298.667 log-slow-queries="/var/lib/mysql/mysql-slow.log" So i need someone to do this. Please advise your experience in these issues. Boilerplate applications will not be considered

I recently got this message from my server tech support The Repair continues to run one thing i do notice is your server has a lot of slow queries. I would advise you contact a developer to look over your MySQL databases at your earliest convenience. Your databases need to have there tables looked over and queries indexed. I will continue to monitor this repair although i have no ETA on how long it will take to run. Below i have listed the current MYSQL status and the location where slow queries can be viewed. # root@server [~]# mysqladmin status Uptime: 668059 Threads: 235 Questions: 199527579 Slow queries: 222 Opens: 23761 Flush tables: 1 Open tables: 15501 Queries per second avg: 298.667 log-slow-queries="/var/lib/mysql/mysql-slow.log" So i need someone to do this. Please advise your experience in these issues. Boilerplate applications will not be considered. Most of the sites are wordpress, 1 is a custom php/mysql site

Feb 26, 2014

Close
  • Posted: Wed, Feb 26, 2014
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I recently got this message from my server tech support

The Repair continues to run one thing i do notice is your server has a lot of slow queries. I would advise you contact a developer to look over your MySQL databases at your earliest convenience. Your databases need to have there tables looked over and queries indexed. I will continue to monitor this repair although i have no ETA on how long it will take to run. Below i have listed the current MYSQL status and the location where slow queries can be viewed.

#
root@server [~]# mysqladmin status
Uptime: 668059 Threads: 235 Questions: 199527579 Slow queries: 222 Opens: 23761 Flush tables: 1 Open tables: 15501 Queries per second avg: 298.667

log-slow-queries="/var/lib/mysql/mysql-slow.log"

So i need someone to do this.

Please advise your experience in these issues. Boilerplate applications will not be considered.

Most of the sites are wordpress, 1 is a custom php/mysql site

Sign in or Register to see more

Job ID: 53583619
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Ajay Kang      
Ajay Kang's identity has been verified.  Learn More
 India  |  
Oracle, SQL Server, MySQL DBA with 12+ years of experience worked with IBM / TCS / Orange SQL PL-SQL TSQL Always keep my clients informed...
4
  |  
 5.0   |  Private   |  2 Jobs
Bid ID: 53638211  |  Submitted: Feb 27, 2014 04:59 ET 
Proposal SEALED

 Indonesia  |  
Winner
Professional system administrator and developer specialized in web performance optimization / tuning, high traffic website, server optimization,...
9
  |  
 4.9   |  Private   |  16 Jobs
Bid ID: 53635653  |  Submitted: Feb 27, 2014 03:38 ET 
Delivery
Within 3 days
$328.77

Sekuri Ganapati Ravi Sankar      
Sekuri Ganapati Ravi Sankar's identity has been verified.  Learn More
 India  |  
More than 10 years experience in DB(stored procedures/sql queries) and PHP programming. Interested in...
7
  |  
 4.7   |  Private   |  7 Jobs
Bid ID: 53611884  |  Submitted: Feb 26, 2014 14:35 ET 
Proposal SEALED

 United States  |  
IDS has been developing focused, web based applications since 1994. Our forte is rapid application development. Timelines run days, not weeks or...
8
  |  
 5.0   |  $44,021 Earnings   |  5 Jobs
Bid ID: 53608536  |  Submitted: Feb 26, 2014 13:17 ET 
Proposal SEALED

Ashok P.      
Ashok P.'s identity has been verified.  Learn More
 India  |  
MISSION: "Help my Customers to succeed, through Quality work on time, every time" High level of accuracy, timely deliveries and total...
3
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 53605252  |  Submitted: Feb 26, 2014 12:08 ET 
Proposal SEALED

 Vietnam  |  
PHP developer with HTML, CSS, Javascript, Photoshop and Linux skills.
6
  |  
 4.9   |  $1,748 Earnings   |  27 Jobs
Bid ID: 53599778  |  Submitted: Feb 26, 2014 10:06 ET 
Proposal SEALED

ZUZEX      
One or more team members at  are verified.  Learn More
 Russia  |  
ZUZEX takes responsibility and provides this planet with complex mobile, desktop and web applications. All projects are developed according to...
12
  |  
 4.8   |  $147,870 Earnings   |  61 Jobs   |  4 verified credential(s)
Bid ID: 53596361  |  Submitted: Feb 26, 2014 08:46 ET 
Proposal SEALED

 Pakistan  |  
Qualityunits is committed to delivering world-class technology solutions to a virtually integrated business community. We provide Creative and...
3
  |  
 4.2   |  Private   |  2 Jobs   |  4 verified credential(s)
Bid ID: 53588759  |  Submitted: Feb 26, 2014 05:36 ET 
Proposal SEALED

Evgeny K., Global Information Technology...      
Evgeny K.'s identity has been verified.  Learn More
 Ukraine  |  
I am a highly-qualified web developer (Master`s Degree in `Software for computerized systems`) with more than 7 years of experience in designing,...
4
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 53586189  |  Submitted: Feb 26, 2014 04:27 ET 
Proposal SEALED

Shashi Kumar      
Shashi Kumar's identity has been verified.  Learn More
 India  |  
My Key Skills Are: I'm experienced Database professional with proficiency in Mysql,PHP, Excel and web based services. Also manage Live database...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 53585696  |  Submitted: Feb 26, 2014 04:12 ET 
Proposal SEALED

Matrix Infologics      
One or more team members at  are verified.  Learn More
 India  |  
We are an Expert @ what we do (100% MONEY BACK GUARANTEE), Technology Enthusiasts (Innovative & Cost effective Solutions for your needs) and work...
10
  |  
 4.8   |  Private   |  48 Jobs
Bid ID: 53585362  |  Submitted: Feb 26, 2014 04:01 ET 
Proposal SEALED

Muhammad Farhan      
Muhammad Farhan's identity has been verified.  Learn More
 Pakistan  |  
My oDesk Profile: ================== https://www.odesk.com/users/~01838a778e8ea2260d ================== > 6+ years of experience in Oracle /...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 53585325  |  Submitted: Feb 26, 2014 04:00 ET 
Proposal SEALED

Aman Aggarwal      
Aman Aggarwal's identity has been verified.  Learn More
 India  |  
DBA having 5+ year of experience. Experience in Database designing, development, Parameter configuration, server tuning according to server...
3
  |  
 4.4   |  Private   |  74 Jobs
Bid ID: 53585152  |  Submitted: Feb 26, 2014 03:54 ET 
Proposal SEALED

 India  |  
I am having more than 5 years of experience in software development, Education, Administration software quality assurance & software quality...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 53584945  |  Submitted: Feb 26, 2014 03:47 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »