title: Remove over 100,000 rows from mysql table - server crashes
body: <p>I have a question when I try to remove over 100,000 rows from a mysql table the server freezes and non of its websites can be accessed anymore!</p>
  
  <p>I waited 2 hours and then restarted the server and restored the account.</p>
  
  <p>I used following query:</p>
  
  <pre><code>DELETE FROM `pligg_links` WHERE `link_id` &gt; 10000
  </code></pre>
  
  <p>-</p>
  
  <pre><code>SELECT* FROM `pligg_links` WHERE `link_id` &gt; 10000 
  </code></pre>
  
  <p>works perfectly</p>
  
  <p>Is there a better way to do this?</p>