Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What do you advise to have the best performance of MYSQL ?

user-image
Question added by Wahba Abd ElHalim , Supervision Project Director / Resident Engineer , Pace (Arab Consultant) Kuwait
Date Posted: 2016/07/05
Mohamed  Yasin
by Mohamed Yasin , Web Administrator/ Front End Developer , Royal Crown LLC

1: Profile your workload

2: Understand the four fundamental resources

3: Don't use MySQL as a queue

4: Filter results by cheapest first

5: Know the two scalability death traps

6: Don't focus too much on configuration

7: Watch out for pagination queries

8: Save statistics eagerly, alert reluctantly

9: Learn the three rules of indexing

10: Leverage the expertise of your peers

 

More Questions Like This