Anybody know? I tried every version after 5.0.19 and none allow me to do
concurrent inserts/load data into a myisam table, even with the new
force concurrent variable
we are stuck on 5.0.19 for now, any ideas?
matt_lists wrote:
We have been using older versions of mysql without any problem (5.0.19)
I updated our test server to 5.0.27
senario is.. temp table performs data conversion, master table is
never deleted/updated, only new records insert, insert takes 30-40
minutes for bulk loads
under old mysql versions we had no table locking
under 5.0.27 the select locks, and after a few minutes I get this error
select * from table limit 1;
ERROR 5 (HY000): Out of memory (Needed 1371552 bytes)
Job running that causes the lock is, load data concurrent infile
'file' ignore into table
did something change? Do we need to switch to innodb (WAY slow in
test) to do concurrent inserts & reads? I never delete from the
tables, and concurrent was supposed to allow insert/read at the same
time as long as there's no data holes, and there are none in my case,
a delete statement has never been ran on this table, never will it's
all historical data.
from the documentation..
For a |MyISAM| table, you can use concurrent inserts to add rows at
the same time that |SELECT| statements are running if there are no
deleted rows in middle of the table.
is this no longer the case?
I tried making it do inserts in batch form, ie 250 records at a time,
but a 30 min load turned into a 3 hour load using that method, and it
locks tables longer than I like.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
