List:MySQL on Win32« Previous MessageNext Message »
From:East Bay Technologies Date:July 20 2004 10:59am
Subject:Suggested settings for dual processor machine?
View as plain text  
I am running mySQL on a :

Dual 2gig AMD (2 processors) under Windows 2000 with 2 gigs of memory
Disk wise I am using a 7800rpm SATA (150mb/sec) drive+card (not on the OS
drive)
Can someone suggest things to change in mySQL setup to better utilize the
2gigs of memory and 2 processors...

Also I am using :

database service mysqld-nt, would it be better to use mysqld-nt-max or
another type?
database type myISAM, is this the fastest operating database? (im not using
fulltext index)

Any help would be greatly appreciated...

Thanks,
Craig
Thread
• Using a Blob with the ByteFX data providerNick Randell16 Jul
  • RE: Using a Blob with the ByteFX data providerReggie Burnett19 Jul
    • RE: Using a Blob with the ByteFX data providerNick Randell20 Jul
      • Suggested settings for dual processor machine?East Bay Technologies20 Jul
      • RE: Using a Blob with the ByteFX data providerReggie Burnett20 Jul
      • Should I use myISAM or InnoDB??East Bay Technologies21 Jul
      • Should I use myISAM or InnoDB??East Bay Technologies23 Jul
      • Suggested settings for dual processor machine?East Bay Technologies23 Jul
• RE: Should I use myISAM or InnoDB??PF: MySQL23 Jul
  • Question about Insert StatementDanny Willis23 Jul
    • Re: Question about Insert StatementTata Respecia24 Jul
      • Ignoring or filtering ' charCadbury30 Jul
        • Strange site error.Danny Willis30 Jul
        • Re: Ignoring or filtering ' charTiago Serafim30 Jul
          • Re: Ignoring or filtering ' charCadbury4 Aug
            • Re: Ignoring or filtering ' charTiago Serafim4 Aug
              • Re: Ignoring or filtering ' charCadbury5 Aug
        • Re: Ignoring or filtering ' charPetr Vileta30 Jul
          • Re: Ignoring or filtering ' charTiago Serafim30 Jul
• Re: Question about Insert StatementRandy Clamons24 Jul