How to tune MYSQL db for best performance?

- Newsfeed
- Find People
- More
- - Products By Bayt.com
    
    Bayt.com
    
    Shagheel
    
    Specialities
    
    Learning
    
    Companies
    
    Salaries
    
    People
    
    Blog
- - العربية
- Use Our Mobile App
  
  Get contacted by recruiters directly with our newest chat feature!
  
  Download Now

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Next Question:
What makes me the best performer? a. Knowledge & Skills b. Good Boss c. Att...
Posted by:
Kashif Mumtaz Ahmed
30-April-2017

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.

1 Answers

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

Upvote (0)

Downvote Reply () Report

Popular Searches

Engineers Jobs Sales Executive Jobs Software Engineer Jobs Accountant Jobs Sales Manager Jobs

Write Your Answer

More Questions Like This

If an employee facing personal problems affecting his performance, what will you do?
Top Answer: All good managers & supervisors always try to sort out personal problem of the staff working under ... See More

Answers (27)
Comparison between php vs asp.net using c# what is best in speed and features. also compare frameworks ?
Top Answer: At the beginning both programming languages are so helpful and have different features.so we compare both ... See More

Answers (3)
What is employee retention? What are the best ways to retain great employees? Please give suggestions to bolster employee retention strategy.
Top Answer: Employee retention is to keep the good performing employees in the organization for long time so that the ... See More

Answers (29)
What is the best performance tuning platform for MySQL and Why?
Top Answer: There are many Program .. Example SQL+ , SQL Server … Iam better Oracle More software used ... Th ... See More

Answers (1)