Mysql large DB optimization and performance tuning. Fulltext queries
Budget: €250 – €750 EUR
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.
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.