I just changed to these values
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
wait_timeout=30
default-character-set=utf8
max_allowed_packet = 14M (lowered from 3000MB)
max_connections = 600 (lowered from 3000)
ft_min_word_len = 3
key_buffer_size=2500M
now looking into table_cache.
----- Original Message -----
From: "Justin" <mysql@stripped>
To: <mysql@stripped>
Sent: Tuesday, September 04, 2007 1:46 PM
Subject: Memory Issue would someone confirm
> alright.. after some testing this afternoon I'm beginning to wonder if
> this is a memory issue.. here's what the test was..
>
> I did a insert select from a table that has approx 500,000 rows and the
> table data is about 1gb in size.. the query went and was in the repair by
> sorting phase when all of a sudden all my queries started to show up with
> a state of Locked.
>
> As soon as I killed the Insert select query all queries ran fine.
>
> Any insight on how I can prevent this would be much appriciated.
>
> thanks
>
> Ju.
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
