Encerrado

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.

Habilidades: PHP, Arquitetura de software, MySQL, Administração de Bancos de Dados, Database Design

Veja mais: 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

Acerca do Empregador:
( 3 comentários ) Milano, Italy

ID do Projeto: #30632745

23 freelancers estão ofertando em média €628 nesse trabalho

(324 Comentários)
8.7
(202 Comentários)
8.5
(475 Comentários)
8.7
(81 Comentários)
8.0
(215 Comentários)
8.0
(221 Comentários)
8.1
(84 Comentários)
7.8
(138 Comentários)
7.3
(415 Comentários)
7.2
(48 Comentários)
6.9
(49 Comentários)
6.7
(31 Comentários)
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 dias
(22 Comentários)
6.1
(81 Comentários)
6.1
(54 Comentários)
5.3
(35 Comentários)
5.3
(30 Comentários)
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 Mais

€400 EUR in 2 dias
(1 Comentário)
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 dias
(8 Comentários)
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 Mais

€250 EUR in 2 dias
(8 Comentários)
2.6