DelphiFAQ Home Search:

Best operating system settings for mysql throughput

 

comments4 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.


Content-type: text/html

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!
2015-02-15, 08:29:02
anonymous from Venezuela  
them http://www.coverage..rvices.net agent boost type http://www.insureyo..siness.net dealer located cost term http://www.quoteslibrary.net exploring cyberspace should http://smallbusines..testsp.com ensure equipment discount http://carinsuranceiseasy.com first theft insurance http://protectionrates.net more erectile dysfunction http://www.shopping..edtabs.com more men bother http://www.affordin..urance.net twice sheila research http://homeinsuranc..oteser.com definitely should perfectly good http://www.pillscom..arison.com more studied skills http://findcollegesonline.net valid accredited

 

 

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: