is mysql support following things

[rakesh76]

Dear Friends

I am new to mysql. I want to come to know following things.
whether mysql supporting or not.

1) Does it support Transaction Handaling
2) Does it support row level locking or Page level locking.
3) No. of Simultaneous users it can handle
4) Total database size in terms of MB/GB it can handle.
5) Backup and Restore Features.

Rakesh Sanghvi

 

[piti]

hi

i think all answers for your questions can be found in the mysql documentation, but

1. yes - though there is some limitation on the table type
2. don't know
3. as i remember there was something about more than 1000 on linux systems
4. depends on the system - it's from GB to TB/table
5. yes

 

[KarveR]

to fill the gap :
2. - yes.(

http://www.mysql.com/doc/I/n/InnoDB_transaction_model.html

)

3. The maximum number of connects to MySQL is dependant on how good the thread library is on a given platform. Linux or Solaris should be able to support 500-1000 simultaneous connections, depending on how much RAM you have and what your clients are doing ***************************************
Party on, dudes!