hi, i am a newbie in mysql and i have some questions about performance tuning.
1-) in a system where you have to store information about a user, such as, user_name, id, last_log, is it better to store all the information needed in one table (lets assume 30 fields in a table) or split then in more tables (3 tables with 10 fields each).
2-) on my.conf, which are the values that is related with performance and how to change then (there is a formula, or something)?
3-) storage engines: Myisam or Innodb
4-) Queries: select * from db. Is this query good to get all users registered or there is a disadvantage in performance.
Any advice you may want to give will be welcome.
thanks for helping