At 02:56 PM 10/14/2002 +0300, you wrote: >Hello Mike, > >Saturday, October 12, 2002, 5:41:11 AM, you wrote: > >MZ> Recently our DB, which is running MySQL 3.23.52, started experiencing >MZ> intermittant load spikes, of the magnitude of 200+ load averages. >Normally, >MZ> our high spike is about 0.90 load. When this starts happening, we >notice a >MZ> lot of processes "cleaning up" within the database. Can someone clue >me in >MZ> as to what cleaning up means, and what the possible cause of this is? > >Sure, we can. > >Please tell us: > >- what is the exact mysql version running (build)
Version string: mysqld Ver 3.23.52 for pc-linux-gnu on i686 Not Max, etc. >- how MySQL is configured Straight off the RPMs from the MySQL download mirrors. [mysqld] port = 3306 skip-locking set-variable = key_buffer=550M set-variable = max_allowed_packet=2M set-variable = table_cache=512 set-variable = sort_buffer=50M set-variable = record_buffer=50M set-variable = thread_cache=8 set-variable = max_connections=1500 set-variable = thread_concurrency=4 set-variable = myisam_sort_buffer_size=128M memlock log = /home/mysql/mysql.log log-bin server-id=1 >- how does the table looks like (structure/type/properties) The table that shows the most of the "cleaning up" states is this one, our sessions table: CREATE TABLE sessions ( sesskey varchar(32) NOT NULL default '', expiry int(11) unsigned NOT NULL default '0', value text NOT NULL, PRIMARY KEY (sesskey) ) TYPE=MyISAM; >- what is the hardware Dual AthlonMP 1600+, 1GB RAM, RAID-5 configuration on the DB filesystem. >- what are the OS details RedHat 7.2 based system, with a 2.4.16 kernel (not the stock RH kernel). The session table would be a HEAP, but for the text field. As a compromise, the MYD and MYI files are in /dev/shm. Any help would be greatly appreciated. >MZ> Mike Zimmerman > > > >-- >For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c >This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > >--------------------------------------------------------------------- >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
