Per second how many transactions can be performed in sql??? I mean how to connection can be connected and how many queries can be performed!??

Question

Help me out guys

Answer 1

Depends on your engine, I assume you're probably using InnoDB. In that case there is no raw transaction limit, it's only limited by the "redo-log" size.
For larger transactions you can set innodb_log_file_size to something like 256M or more.

Answer 2

Thanks much for replying Luke... And So that means per query we can set the size!?? Is that what you mean!??