How does sqlalchemy mysql achieve high concurrency to insert data?

  • I want to implement a crawler, but highly concurrent data cannot be inserted into the database?
  • how to insert database concurrently with sqlalchemy mysql
Mar.16,2021

inserting the same table concurrently triggers table-level locks. It is recommended to insert sub-tables, such as 10 concurrent processes, each of which is written to a table independently.
UNION ALL when querying

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b32943-341d5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b32943-341d5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?