From: Mike Zimmerman
Date: October 14 2002 3:48pm
Subject: re: High load with "cleaning up" status
List-Archive: http://lists.mysql.com/mysql/122137
Message-Id: <5.1.1.6.0.20021014113104.00aba210@mail.spamcop.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

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
>  / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
>/_/  /_/\_, /___/\___\_\___/   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 <mysql-thread122106@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-tarmon=spamcop.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php