Multi insert. What's wrong with a large value of max_allowed_packet in mysql?

The crown loaded with third-party API products in the database. Not to do a lot of small inserts, insert 200 of goods through the multi insert. It was 200 because you no longer fit in the query depends on the max_allowed_packet limit (64M). If this $ 200 can be different (length of the description etc), that is, varies.
What are the disadvantages I expect if I, for example will increase the size of this parameter by 5 times and will insert time, not 200, and 1000 goods? What are the disadvantages from the point of view of the importance and what are the disadvantages from the point of view of the large number of entries for a single insert. Everywhere write, what to insert many records at once is better than a lot of times to insert 1 record, but whether somehow to limit the number to one insert? After all, can be several gigabytes to put and paste all the goods in one insert. How to make optimally?
July 2nd 19 at 17:59
2 answers
July 2nd 19 at 18:01
1. You do not need to bother with this question, this business layer interact with the database.
for example you have 1000 records you insert for example an array $adapter->insert("table",$data)
this method needs to determine the size of the inserted data, to the setting max_allowed_packet determines the packet size divided insert an array into parts depending on the packet size = the size of the array/max_allowed_packet
2. If 200 products you have depends on 64MB then 1000 goods will weigh 320мб you can rest against the php memory (memory_limit) so you'll have to increase it also
July 2nd 19 at 18:03
What you store in the database? and how request make through the values or each request as a separate request complete?

64MB/200 products
300KB = 1 item
War and peace in txt format weighs about 3MB.
10 of your products = war and peace
Is it too much?
I made a mistake. The error in data size and number of placeholders. General error: 1390 Prepared statement contains too many placeholders. - rupert_Weissnat79 commented on July 2nd 19 at 18:06

Find more questions by tags MySQL