Bug #65533 | big update | ||
---|---|---|---|
Submitted: | 6 Jun 2012 10:21 | Modified: | 7 Jun 2012 14:06 |
Reporter: | Manea Catalin | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Workbench: SQL Editor | Severity: | S5 (Performance) |
Version: | 5.2.40 | OS: | Windows (Microsoft Windows 7 Ultimate Edition Service Pack 1 (build 7601), 64-bit) |
Assigned to: | CPU Architecture: | Any | |
Tags: | WBBugReporter |
[6 Jun 2012 10:21]
Manea Catalin
[6 Jun 2012 10:47]
Valeriy Kravchuk
Please, provide some details. Had you updated many rows in some table, or loaded sole huge SQL script doing updates, or something else?
[6 Jun 2012 10:55]
Manea Catalin
Thanks for your help, I have a sql file with all inserts, contains about ~ 2,871,224 rows, this is part of the script " LOCK TABLES `ARTICLES` WRITE; /*!40000 ALTER TABLE `ARTICLES` DISABLE KEYS */; INSERT INTO `ARTICLES` VALUES (1,'0 001 108 047',30,0,54248,0,0,0,0,0,0),(2,'0 001 108 050',30,0,54248,0,0,0,0,0,0),(3,'0 001 108 051',30,0,54248,0,0,0,0,0,0),(4,'0 001 108 052',30,0,54248,0,0,0,0,0,0),(5,'0 001 108 054',30,0,54248,0,0,0,0,0,0),(6,'0 001 108 056',30,0,54248,0,0,0,0,0,0) "
[6 Jun 2012 12:30]
Valeriy Kravchuk
How large is that file, 50+M or more?
[6 Jun 2012 12:42]
Manea Catalin
ARTICLES.sql 123MB Thanks !
[7 Jun 2012 14:06]
Alfredo Kojima
duplicate of bug #55312