DelphiFAQ Home Search:
General :: Databases :: mysql
General information about mysql - how to get around the differences between version 3.33 an 4, how to do stuff that you think you need a nested query for etc.


This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

Best operating system settings for mysql throughput

  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.

Generated 16:00:35 on Oct 20, 2019