How to tune MYSQL db for best performance?

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

Downvote Reply () Report

Popular Searches

Sales Executive Jobs Engineers Jobs Engineering Technicians Jobs Accountant Jobs Driver 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)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.