My sql database Important questions(Help needed )

[VVM Ravikumar Sarma Chengalvala]

Hi,
1.
What is the default memory allocated by mysql to a
newly created database?
2.
If I make any changes to a database(either by adding a
new table or by adding or deleting a column of a
table) is there a way ,I can have a version control of
my database and retain the old tables and new tables
of the database also?
3.How does mysql implement concurrency control?Will it
lock the table automatically in case multiple users
try to access the same table at a time?If so, what is
the type of locking it enforces by default?
4.
Your replies are highly appreciable.

Regards,
Ravi

____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php