Closed

MySQL Design

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

Skills: MySQL, NoSQL Couch & Mongo, PHP, UNIX

See more: huge design, get expert advice, fragment design, mysql number sql, php mysql load table, update database mysql, fragment, fix cpu, mysql update table, edit current design, api design expert, server load check fix, ssd drive, php server load mysql, cpu load mysql fix, mysql design database, expert database design mysql, huge load, edit records sql php, sql design, cpu load, indexing database, cpu load php, fix server load, fix raid

About the Employer:
( 0 reviews ) RaS Bayrut, Lebanon

Project ID: #5070901

16 freelancers are bidding on average $42/hour for this job

deepgaf

Can help you with that... Give me the URL & other details. Greetings from EUPHORBIA(TM)! Please check your PMB for our detailed bid. Quality work & your satisfaction is 100% guaranteed or we will gladly refund you More

$51 USD / hour
(50 Reviews)
6.7
seekdeveloper

Hi, I have understood your requirement I have good experience in handling HTML5/PHP/Java/J2EE/iOS and Android apps/Drupal/Ruby & Ruby on Rails/Javascript/MySQL/ I can handle this task for sure.I Hope we can wo More

$51 USD / hour
(34 Reviews)
6.3
bigdognec

Hello, A few questions about the tables and the server: 1)Can you tell me how many rows are there in these tables and how many are updated? 2)Have you tweaked the [url removed, login to view] file? 3)Do you have slow query logs pointi More

$36 USD / hour
(84 Reviews)
6.0
khalak

Hi, I am doing such kind of job, so I know this job very well. I think I am the perfect person to do this job. I am offering myself as a candidate for this job. Please provide me your Skype id. I thing that will help More

$50 USD / hour
(48 Reviews)
5.5
datadiggers

Hello, If You're looking for a real MySQL expert that can work on very large datasets (10GB-100GB) I will be available next week (currently my schedule is full). I do understand that You might need to start on the pro More

$56 USD / hour
(13 Reviews)
5.4
Eliteprog

Hi, First of all thanks for posting this project, I am available to provide you economical services for web development , I have read and understood all of project details. I am expert in software development and c More

$39 USD / hour
(23 Reviews)
5.0
amfahsoft

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.

$38 USD / hour
(35 Reviews)
5.0
pixelbypixelsl

Hi - do you have an individual index such as SOLR or Sphinx that you either use or can use? Are you reading any of the tables or is the slowdown simply due to updates? There are several things that can be checked firs More

$50 USD / hour
(8 Reviews)
4.9
sergechernyavsky

Hello, I have 10+ years Linux administration experience and have worked a lot with MySQL. Many of my projects required development of relatively busy databases, optimization, replication and tuning. Could you ple More

$44 USD / hour
(12 Reviews)
4.9
malexc

Hello, I'm a senior PHP / HTML / CSS / JavaScript / AJAX / jQuery developer, with more then 10 years experience. I'm fluent in both spoken and written English and I'm available for full time work. I'm looki More

$40 USD / hour
(3 Reviews)
4.2
elboukharimu

Hi, I'm very interested helping you checking and resolving your mysql database problem, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my port More

$36 USD / hour
(11 Reviews)
4.1
listmystuff

Hi I have 10+ years developing commercial grade systems primarily using Linux, Apache, MySQL, PHP/Perl and Javascript. I have an indepth understanding of MySQL as a developer and as a MySQL administrator. I c More

$42 USD / hour
(4 Reviews)
3.8
nsplit

Good morning, I'm 15+ unix/linux sys admin and programmer. I'm curious why you are using external mysql server and not locally in the same server where website exist? It's your option or an emergency solution becau More

$41 USD / hour
(2 Reviews)
3.1
icodingtechno

Hello, Pleased to see your project posting. I've gone through your project details and hereby I'm outlining my understanding about your project: ============== Project title: MySQL Design Concept: mySQL / Unix dev More

$50 USD / hour
(2 Reviews)
1.2
alinaimi

i have done such this .

$40 USD / hour
(1 Review)
1.1
nganpho

I have along time working with mysql. My strength is algorithm and turning SQL implementation. I can analysis the time and complex that one sql query work. I think that your problem is indexing, may be it is not good i More

$38 USD / hour
(0 Reviews)
0.0
gassana

We provide you industry standard Mobile Apps, Software, Desktop Apps, Web Stores, Websites and Web Apps. So, you get all at one place! We can provide you the following: - iOS applications - Android applications - More

$27 USD / hour
(0 Reviews)
0.0
zillur00

Dear Hiring Manager, I am very good at MySQL Database optimization. I am very confident I will be able to solve your problem within a day. As per your description I pickup the following -> You are running s More

$25 USD / hour
(0 Reviews)
0.0