search

Home  >  Article  >  Backend Development  >  How much data will be lost after a single insert in mysql?

How much data will be lost after a single insert in mysql?

WBOY
WBOYOriginal
2016-08-23 09:17:442045browse

I want to use PHP to execute a SQL statement to insert data in batches. I heard others say that too much data will cause data loss problems. Please tell me why this problem occurs. Generally, how much data can be inserted in batches to ensure that the data will not be lost.

Reply content:

I want to use PHP to execute a SQL statement to insert data in batches. I heard others say that too much data will cause data loss problems. Please tell me why this problem occurs. Generally, how much data can be inserted in batches to ensure that the data will not be lost.

Lost data is because the application is not written well and has nothing to do with mysql. It depends on your current memory size and system load. Generally, you can start testing with 1,000 entries each time. Experience data

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：html - How to get the full local path of the file when uploading it in phpNext article：html - How to get the full local path of the file when uploading it in php

Related articles

See more