Best operating system settings for mysql throughput
4 comments. Current rating: (1 votes). Leave comments and/ or rate it.
If you have memory problems, add more RAM instead or configure your system to use less memory.
Don't use NFS disks for data (you will have problems with NFS locking).
Increase number of open files for system and for the SQL server. (add ulimit -n # in the safe_mysqld script).
Increase the number of processes and threads for the system.
If you have relatively few big tables, tell your file system to not break up the file on different cylinders (Solaris).
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.
Send a message to
throughput in computer term in operating system from India
anonymous from Australia
说道：I would like to thnkx for the efforts you have put in wtiirng this web site.I am hoping the same high-grade site post from you in the upcoming as well.Actually your creative wtiirng skills has inspired me toget my own website now. Really the blogging is spreading itswings rapidly. Your write up is a good example of it.