Just becareful not to use too much memory unless you raise the DMAX and such values (see /usr/src/sys/i386/conf/LINT ) if mysql runs out of memory things can get ugly!
Also just run "show variables" to see the differences in the default configs. Also you did not say if both machines were the same version of FreeBSD and if both machine used the same type of SCSI harddisk and controller. CPU speed does not mean much during inserts, there is alot of disk writing. Ken ----- Original Message ----- From: "Jay Blanchard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 3:34 PM Subject: RE: MySQL Performance on Dual Processor machine > [snip] > I would suspect other things first such as the my.cnf configuration > (show variables) or has the kernel been optimised on the old box. > Did you check kernel configurations and disk subsystems? Also the > default process size on FreeBSD is 256Meg, so more memory won't help > much unless you use it in my.cnf and the kernel configuration allows > it! > [/snip] > > Amazingly enough (I did not do the install of MySQL) there is no my.cnf on > either machine (there are the default my-whatever.cnf files.). I belive that > I should use the my-large.cnf as a starting point. Does anyone have any > suggestions other than the default configuration for this file? > > Thanks! > > Jay Blanchard > Applications Development > nii communications, inc. > 210-403-9100 x285 > > > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
