Here is the hardware: 8x U160 SCA IBM UltraStar 36LZX Discovery 4MB cache 10000 rpm 18.2GB, Adaptec 3200S 64MB Cache 32/64 bit PCI RAID U160 SCSI,
FreeBSD says when booting: ADAPTEC RAID-50 370F Fixed Direct Access SCSI-2 device Tell me please if any other info is needed. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Tue, 19 Feb 2002, Simon Green wrote: > Date: Tue, 19 Feb 2002 13:22:04 -0000 > From: Simon Green <[EMAIL PROTECTED]> > To: 'Varshavchick Alexander' <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: RE: Mysql performance question > > What disk drive have you got? > We have found that this can help. > > Simon > > -----Original Message----- > From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]] > Sent: 19 February 2002 13:14 > To: [EMAIL PROTECTED] > Subject: Mysql performance question > > > Hi people, > > May be anybody can advice from the personal experience tweeking which > options both in the mysql configuration and server hardware can help in > increasing mysql performance speed? As it is now, mysql is configured to > occupy about 600M RAM, and queries per second avg goes up to about 100, > yet under the top load it seems to be not enough. Here are the config > options: > > set-variable = key_buffer=512M > set-variable = max_allowed_packet=1M > set-variable = table_cache=512 > set-variable = sort_buffer=8M > set-variable = record_buffer=1M > set-variable = myisam_sort_buffer_size=64M > set-variable = thread_cache=16 > set-variable = max_write_lock_count=10 > set-variable = thread_concurrency=8 > > The server itself is 2x PIII Intel Xeon 700 MHz, Intel KOA4 platform, > with 4G RAM. Mysql 3.23.47 (binary distribution), FreeBSD 4.5 system. > > All mysql queries are rewritten so the INSERT/UPDATE's has > been reduced or replaced by DELAYED as much as possible, to ease > mysql locking. The mysql tables are indexed, all documentation from the > main mysql site having been studied. And under the top load the mysql > starts locking anyways. > > So what can be the best ways of helping it: > > - Changing mysql options, may be increasing key_buffer some more or what > else? > > - Adding 2 more CPU's to the server (it can bear up to 4 CPU); > > - May be there can be some other ways? > > Thanks in advance! > > Alexander Varshavchick, Metrocom Joint Stock Company > Phone: (812)118-3322, 118-3115(fax) > > > > > > --------------------------------------------------------------------- > 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
