mysql question

>how much the expected data base size would be

>what/what kind of application is going to deploy

> connection type b/n application & data base (is application using connection pool etc etc)

>Security of data base (users in database eg. root pwd secure in database & connect only thru localhost)

>What mysql table engine preferred (myISAM or Innodb ) ==> how is our applicaiton (e.g if more insert and select then go with myISAM

and if more update and select then go with innodb

and if more insert + delete + select then go with innodb

and if one time bulk insert + one time delete + select then myisam

>reason               myisam -- lock table level

innodb -- locks table in row level

If databases have majority of innodb table then

setup server with following parameter

innodb_buffer_size s/b 65-75 % of available RAM and so on

>Before that I need to know the config of the system

                - RAM

                - What processor

                - What media (SATA or SAS or SSD)