Best operating system settings for mysql throughput

1 comments. Current rating: (1 votes). Leave comments and/ or rate it.

1. No swap.
   If you have memory problems, add more RAM instead or configure your system to use less memory.
2. Don't use NFS disks for data (you will have problems with NFS locking).
3. Increase number of open files for system and for the SQL server. (add ulimit -n # in the safe_mysqld script).
4. Increase the number of processes and threads for the system.
5. If you have relatively few big tables, tell your file system to not break up the file on different cylinders (Solaris).
6. Use file systems that support big files (Solaris). Choose which file system to use; Reiserfs on Linux is very fast for open, read and write. File checks take just a couple of seconds.

Comments:

2006-11-28, 22:58:05

throughput in computer term in operating system from India

Email address (not necessary): Rate as Off-topic Very Helpful Helpful Ok article Not useful Very bad	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option.
It seems that you are from Los Angeles, US . Info/ Feedback on this	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Add a picture: Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.