Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to tune MYSQL db for best performance?

jQuery
user-image
Question added by Harshad Usman , Senior software engineer , Cognizant Technologies
Date Posted: 2015/10/10
Upvote (0) Views (0) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Chander Prakash
by Chander Prakash , full stack developer , Barclays - South Africa

 

  • MEMORY/RAM, specifically the buffers
  • SWAP
  • ACID - Do you need full ACID, or can you (likely) make some sacrifices there for speed
  • tmp tables, tmpdir (use a tmpfs mounted dir)
  • Thread/Connections - How many processes and threads should be running
  • open_files / table_cache - May need to boost your /etc/security/limits.conf and your /etc/sysctl.conf

Write Your Answer
More Questions Like This