Periodically run EXPLAIN ANALYSE to achieve perception into how well your database is performing. These tips are applicable to almost any database management system — specific database administration techniques will necessitate specific ideas relevant to them and your use case. By together with...