DelphiFAQ Home Search:

Best operating system settings for mysql throughput

 

comments3 comments. Current rating: 4 stars (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  
rating
2014-12-17, 03:10:33
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.
2015-02-01, 05:40:12
anonymous  
Yup, that sholud defo do the trick!

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
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, or post under a registered account.
 

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:

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.

photo Add a picture: