Bug #5201 'freezing' of utility when performing operations on numerous records

• Submitted: 25 Aug 2004 9:26
• Modified: 1 Dec 2004 13:43
• Reporter: [ name withheld ]
• Status: Closed
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: mysql-query-browser-1.0.5-alpha-win-noin
• OS: Windows (win ad svr 2000)
• CPU Architecture: Any

[25 Aug 2004 9:26] [ name withheld ]

Description:
While deleting (and also applying changes) on records, the utility freezes, even after mysql administrator reports that 0 rows in table. 

Takes about 5 minutes later to resolve itself or sometimes need to be killed.

How to repeat:
create 1 million rows in a single table and delete them using the util.check with the mysql admin.

Suggested fix:
maybe they could delete record by record and display the progress like mysql control center?

[25 Aug 2004 16:35] Michael G. Zinner

Do you have a primary key on this table? Did you execute 

DELETE * FROM test;

or did you have a where clause? Do you have a similar behaviour in the MySQL command line client?

Thanks!