Replace deletes and inserts.
?
what do you mean?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
matt ryan wrote:
Replace deletes and inserts.
?
what do you mean?
Replace does a delete followed by an insert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
matt ryan wrote:
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
I've switched to innodb but performance isnt very good
while the insert runs, here's what I get for performance
select count(*) from rondon;
1 row in .13 sec
select count(*) from
matt ryan wrote:
matt ryan wrote:
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
I've switched to innodb but performance isnt very good
while the insert runs, here's what I get for performance
select count(*) from rondon;
1 row in .13 sec
matt ryan wrote:
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
Doh another problem
innodb has no merge option, I have too much data, and the only way to
deal with it, is partition the data and then tie it together with merge
views.
I hate to pry (snoop) but my curiosity is just going nuts! If this is a
sensitive issue, please ignore my questions
What are you doing that requires you to mass-replace so many records so
often? Are they design or processing requirements (or both) that require
this kind of bulk exchange
SQL is, replace delayed into table c1, c1, c3 select c1, c2, c3 from
temp table.
This takes 2 hours to comlete, the temp table is rather large.
The table being updated is locked, the whole time, all web requests are
locked and the pages time out.
Is there any way to get this to run without
matt ryan wrote:
SQL is, replace delayed into table c1, c1, c3 select c1, c2, c3 from
temp table.
This takes 2 hours to comlete, the temp table is rather large.
The table being updated is locked, the whole time, all web requests
are locked and the pages time out.
Is there any way to get this
If you are using a MyISAM table type, the entire table is either locked or
it isn't. Normally this isn't a problem most statements happen quickly.
However, yours takes a couple of hours to finish so the entire table has
to stay locked until your statement completes.
The way I see it, you have
10 matches
Mail list logo