MySQL Design
$25-50 USD / jam
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 @ 2.00GHz
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
ID Proyek: #5070901
Tentang proyek
15 freelancer rata-rata menawar $41/jam untuk pekerjaan ini
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 Lebih banyak
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 Lebih banyak
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.
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 - Lebih banyak
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 Lebih banyak
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 Lebih banyak
