# Could you explain how to optimize MySQL database performance for a new user handling large-scale data?

Could you explain how to optimize MySQL database performance for a new user handling large-scale data?

##### Post Metadata
- Posted at: almost 2 years ago
- Author title: Pinned by G2 as a common question



## Comments
### Comment 1

Indexing is your best friend here. I always make sure queries aren't hitting the whole table. Also, tuning the innodb_buffer_pool_size to around 75% of your RAM keeps the heavy lifting in memory instead of on the disk.

##### Comment Metadata
- Posted at: 4 months ago
- Author title: Cloud Architect | DevOps Engineer | Terraform | Kubernetes | CI/CD | Automation



### Comment 2

Try these steps:
1) try normalization 
2) use indexes 
3) try to separate workloads using different techinques

##### Comment Metadata
- Posted at: over 1 year ago
- Author title: Senior Analyst, Google Cloud, Google Certified Professional Data Engineer, Python, Machine Learning Algorithms , DataBricks, SQL




## Related Product
[MySQL](https://www.g2.com/products/mysql/reviews)

## Related Category
[Relational Databases](https://www.g2.com/categories/relational-databases)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4