Closed

MySQL Design

This project received 18 bids from talented freelancers with an average bid price of $42 USD / hour.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$25 - $50 USD / hour
Total Bids
18
Project Description

Hello,

I'm looking for somebody who is expert in mySQL / Unix

I do have a website, which use database MySQL and i have ALTERED some table into InnoDB.


The server is powerful
Total processors: 24
Intel(R) Xeon(R) CPU E5-2620 0 @ [url removed, login to view]

32GB Ram

SSD Drive With Raid-1


Now, my current design need to have the operations on SQL to be done from Outside the server, we already linked another server via API and it's working .

But as more i have ( crons ) running on 2nd server the first server load get's up and start hanging

I have 2 tables in InnoDB which keep getting fragment as they do 1 update each 3minutes and each table have huge number of records .


The Indexing is not working as it was expected .


I'm looking at somebody who can check the server/sql design give advice's/edit to fix this .




Regards

Looking to make some money?

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

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online