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]
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 .
16 freelancers are bidding on average $42/hour for this job
I sincerely read your requirements and I am ready to endow with the solution as per your requirements. I can assure you that I will provide you high level of satisfaction and support to gain your confidence.