I just changed to these values
max_allowed_packet = 14M (lowered from 3000MB)
max_connections = 600 (lowered from 3000)
ft_min_word_len = 3
now looking into table_cache.
----- Original Message -----
From: "Justin" <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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1