title: Is Mysql/Mariadb delete Query transactional? and its performance for huge no. of rows?
body: <p>Q1: Does a delete query run as a whole transaction in mysql/mariadb. So if we have 1 million rows to delete, will mysql/mqriadb server delete it as a whole or if after deleting some rows something goes wrong deleted rows will get restored.</p>
  
  <p>Q2: Should we need to delete rows in a single delete query (irrespective of   how many rows need to deleted) or should we need to place a limit in delete query and perform delete in batches. If batching is required  at what number (no. of rows to deleted) should we think of it.</p>