MySQL concurrency

[robcrozier]

Hi all.

 

OK, I'm doing a bit of a project for University at the minute and i need to address database concurrency as an issue.  Basically what I'm trying to find out is - how concurrent is MySQL as standard (i.e. how many simultaneous transactions can it handle with ease?) and also how can it me made more concurrent?

 

I've come across a few things while 'googling' the issue, like 'lock tables' for example however I'm not exactly sure how this works.

 

If anyone can offer any help or useful links it would be much appreciated!

 

thanks a lot!

[fenway]

It can handle a relatively large number of threads in principle from the server side... it's the type of statements that you're running that will be the rate-limiting step.

[robcrozier]

thanks for that.  The system that i intend to create for the UNI project will be an online auction.  Obviously not as large as eBay etc, though, because it's for UNI they expect me to address the issues (i.e. concurrency that larger online auction sites like eBay would face.  This would also be based on the number of potential transactions that would take place if the proposed system were the size of eBay.

 

Have you any idea how many transactions, as an average MySQL can handle and also how can the speed of the statements be increased etc?

 

cheers!

[fenway]

Too general a question....