Kapalı

Mysql large DB optimization and performance tuning. Fulltext queries

The developer is required to work on an existing copy of our MySql DB and optimize its performance.

The DB is composed of around 30 tables and is around 2.6Gb big.

The biggest table alone is about 2Gb because it stores a lot of text in a text field. This table uses MyISAM engine and this must be preserved, cannot be partitioned because we run fulltext queries on it.

Fulltext select are very slow and we need to solve this problem.

Every modification to the DB must be provided in SQL so we can replicate it on the live DB when the performance issue will be solved.

Beceriler: PHP, Yazılım Mimarisi, MySQL, Veri Tabanı Yönetimi, Database Design

Daha fazlasını gör: plesk vps mysql performance tuning, optimizing mysql large queries, optimise mysql large queries, mysql performance tuning oscommerce, mysql performance tuning ecommerce, mysql performance tuning consulting, apache mysql performance tuning, mysql apache performance tuning linux, mysql performance tuning, jboss optimization & performance tuning freelance corporate trainer, java performance tuning and optimization, mysql query performance tuning, mysql query optimization and performance tuning, mysql performance tuning tools, tuning mysql server to boost performance, mysql performance tuning tips, mysql performance tuning tutorial, database performance tuning and query optimization, drupal 7 mysql performance tuning, mysql large table optimization

İşveren Hakkında:
( 3 değerlendirme ) Milano, Italy

Proje NO: #30632745

Bu iş için 23 freelancer ortalamada €628 teklif veriyor

(324 Değerlendirme)
8.7
(202 Değerlendirme)
8.5
(475 Değerlendirme)
8.7
(81 Değerlendirme)
8.0
(215 Değerlendirme)
8.0
(221 Değerlendirme)
8.1
(84 Değerlendirme)
7.8
(138 Değerlendirme)
7.3
(415 Değerlendirme)
7.2
(48 Değerlendirme)
6.9
(49 Değerlendirme)
6.7
(31 Değerlendirme)
6.2
saubhagyamweb

Hello there, I’m Virang Patel, a Professional and Expert Software Engineer. I am interested in doing this job for you. Ready to start the project. Looking forward to hearing from you. Thank you Virang

€500 EUR in 7 gün içinde
(22 Değerlendirme)
6.1
(81 Değerlendirme)
6.1
(54 Değerlendirme)
5.3
(35 Değerlendirme)
5.3
(30 Değerlendirme)
4.7
ArturAgababian

Hi there Thanks for your post. I read your database issues carefully As a Database expert, I have rich experience in resolving a huge mysql database. If you agree, I want to solve your issues. Looking forward to your r Daha Fazla

€400 EUR in 2 gün içinde
(1 Yorum)
3.8
charlespiaocn

hi, how are you? I've already worked for this type project. I want you to discuss with me about further more project specification. Thanks regards.

€500 EUR in 7 gün içinde
(8 Değerlendirme)
2.7
rana176

I am ready to start working immediately on your project. I would be honored to assist you on this project. I will give you 100% satisfaction with the requirements. Respected Sir! I am a professional WordPress Develop Daha Fazla

€250 EUR in 2 gün içinde
(8 Değerlendirme)
2.6