Best practices while designing databases in MySQL -

i developing enterprise application in java ee , think have huge amount of stored data. similar university management application in colleges students registered , have profile.

i using mysql database. tried explore on internet , found tips on link.

what best practices develop huge databases not decrease performance?

thanks in advance.

first of database not huge medium -> small size. huge database when need deal terabytes of data , million operations per second. considering case, mysql (myisam) enough , rather optimization should focus on correct database design (optimization next step).

let me share tips you:

• scale hardware (not important case)
• identify relations (normalize) , correct datatypes (i.e. use tiny int instead of big int if can)
• try avoid null if possible
• user varchar instead of text/blob if possible
• index tables (remember indexes slow update/delete/insert operations)
• design queries in correct way (use indexes)
• always use transactions

once design , develop database , performance not sufficient - think optimization: - check explain plans , tune sqls - check hardware utilization , tune either system or mysql parameters (i.e. query cache).

please check link: http://dev.mysql.com/doc/refman/5.0/en/optimization.html