Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: my.cnf optimizing MySQL

    Just wondering if anybody has a suggestion for tweaking the my.cnf file to reflect my server set-up.

    I'm running Dual pentium III 550, 1G Ram, mirrored 8G SCSI HD.

    Connections to the server are all through PHP about 90% SELECTS and 10% INSERTS/UPDATES.
    It is a college sports site so I get some pretty heavy traffic on game days the rest of the time it's moderate to semi-heavy.

    Currently I'm using the default settings but get major slow downs on game days.

    Any help would be greatly appreciated.


  2. #2
    Join Date
    Jul 2003
    Hi pelowe,

    You may or may not find the following discussion helpful...

    There is also plenty in the MySQL manual on configuration options.

    Our MySQL performance improved dramatically after tweaking the config settings.

    Last edited by asherh; 11-01-03 at 01:34.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts