[DiscordArchive] Can't read it. You used insert or replace?
[DiscordArchive] Can't read it. You used insert or replace?
Original source
You know, it may be an error in my app, or some limit on MySQL server's side
rektbyfaith
02-14-2018, 08:36 PM #11Archived author: Amaroth • Posted: 2018-02-14T20:36:32.885000+00:00
Original source
You know, it may be an error in my app, or some limit on MySQL server's side
Original source
Range limit should be a better translation
rektbyfaith
02-14-2018, 08:36 PM #12Archived author: Смердокрыл • Posted: 2018-02-14T20:36:46.369000+00:00
Original source
Range limit should be a better translation
Original source
Maybe MySQL doesn't allow inserting 37k records in one transsaction
rektbyfaith
02-14-2018, 08:36 PM #13Archived author: Amaroth • Posted: 2018-02-14T20:36:52.633000+00:00
Original source
Maybe MySQL doesn't allow inserting 37k records in one transsaction
Original source
Well, I checked the privileges for the login/password I used and there are no limits for queries/connections/etc set
rektbyfaith
02-14-2018, 08:38 PM #14Archived author: Смердокрыл • Posted: 2018-02-14T20:38:23.446000+00:00
Original source
Well, I checked the privileges for the login/password I used and there are no limits for queries/connections/etc set
Original source
OK, can you try using smaller listfile?
rektbyfaith
02-14-2018, 08:39 PM #15Archived author: Amaroth • Posted: 2018-02-14T20:39:43.655000+00:00
Original source
OK, can you try using smaller listfile?
Original source
With like 10k models?
rektbyfaith
02-14-2018, 08:39 PM #16Archived author: Amaroth • Posted: 2018-02-14T20:39:54.667000+00:00
Original source
With like 10k models?
Original source
Seems to be MySQL, not tool's issue
rektbyfaith
02-14-2018, 08:40 PM #17Archived author: Amaroth • Posted: 2018-02-14T20:40:08.778000+00:00
Original source
Seems to be MySQL, not tool's issue
Original source
Ok, I deleted all lines after 10000 from the listfile I just used, let me try again
rektbyfaith
02-14-2018, 08:42 PM #18Archived author: Смердокрыл • Posted: 2018-02-14T20:42:43.004000+00:00
Original source
Ok, I deleted all lines after 10000 from the listfile I just used, let me try again
Original source
<@357182195233980416> MysqlBulkLoader lib should handle that itself, it'll batch and all that
rektbyfaith
02-14-2018, 08:43 PM #19Archived author: Barncastle • Posted: 2018-02-14T20:43:42.918000+00:00
Original source
<@357182195233980416> MysqlBulkLoader lib should handle that itself, it'll batch and all that
Original source
What tool generated in our russian friend's case is one transaction with 2 insert queries, which together contained nearly 38k new rows
rektbyfaith
02-14-2018, 08:44 PM #20Archived author: Amaroth • Posted: 2018-02-14T20:44:48.734000+00:00
Original source
What tool generated in our russian friend's case is one transaction with 2 insert queries, which together contained nearly 38k new rows
1 Guest(s)
1 Guest(s)