Mysql batch deletes a large amount of data

Mysql batch deletes a large amount of data. Assume that one table (syslogs) has 10 million records, and you need to delete all the records with statusid = 1 without stopping the service, with about 6 million records, if you directly execute delete from syslogs WHERE statusid = 1, the deletion fails because of the lock wait timeout exceed error. Because this statement involves too many records, we delete them in batches using the LIMIT parameter. For example, each 10000 records is deleted once, then, we can use a statement like MySQL to delete from syslogs WHERE status = 1 order by statusid LIMIT 10000. Then, the records can be successfully deleted after multiple executions.