title: How to optimize the performance of a very large MySQL database?
body: <p>I am working on a web-application in PHP-MySQL. I am MySQLi API for database access. I have broadly two questions:</p>
  
  <ol>
  <li>How can I increase the performance of the MySQL database?</li>
  <li>How much secure and suitable is MySQL for large, enterprise level database?</li>
  </ol>
  
  <p>For question 1, please note the following points:</p>
  
  <ul>
  <li><p>The main central tables of the database are expected to receive about half a million to one million rows every year. How can I speed up retrieval from those tables? I already have created Index on those tables.</p></li>
  <li><p>I am moving the archived rows to a new table, and keeping only currently being used rows in the main table. But at any moment of time, the main table will still have very large number of rows.</p></li>
  </ul>
  
  <p>Thanks in advance</p>