Re:Re-indexing problem on large table

2003-10-20 Thread gunnar . lunde
set and pipe it in to a new table with all indexes in place I would be very happy if you let us know any advantages/disadvantages you might see with the three alternatives. Best regards Gunnar Lunde - Hello! I hope someone can help us with a problem we have

Re-indexing problem on large table

2003-10-20 Thread gunnar . lunde
sql/ | version | 3.23.41-log | wait_timeout | 28800 Mvh / Best Regards Gunnar Lunde sql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Performance problems after record deletion.

2003-01-14 Thread Gunnar Lunde
can not live with a select statement that takes 30 minutes when it used to complete in no time. Ideas to fix this is more than welcome! Best regards Gunnar Lunde > -Original Message- > From: Vikash K Agarwal [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 14, 2003 12:22 PM >

Performance problems after record deletion.

2003-01-14 Thread Gunnar Lunde
his job will be > completed by tomorrow. As a sidenote - is there any way of monitoring the > progress of large jobs of this kind? > If you have experienced the same type of problems, or if anyone have any thou