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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
