concurrency control in MySQL,PHP based apps

[tanveer]

Friends,
I don't know if this is the right forum to put this topic, if not then sorry.
I want to know in linux environment how to handle concurrency of PHP,MySQL based applications? Do I have to handle concurrency issue in coding or linux handles this by default? What will happen when simultaneous requests will take place when it will be up in the server?
Another issue is after I develop an application using PHP,MySQl then what next? I mean to say ishow to up it in server, where to put the database,...
Looking forward for help in this any link,tutorial, will be a great help.

[hasnut]

you can look at this
http://www.itu.dk/people/jcg/WP/Conc/www/index.html

But if you are really new in php/mysql based system then you don't need to much worried abut concurrency control of your system.

In practical life there are really small amount of people have expreance with say 1 milllion of users at a time for a site, where concurrency issue is importent.

Quote:

Another issue is after I develop an application using PHP,MySQl then what next?

upload your files by ftp for that you need ftp access(username/pass), setup mysql database and for that you need hostname username and pass
_________________
Sarder Hasnut
MCSD, CIW A

Need Low Cost Prefessional Hosting Contact me

[hasnut]

Have a look at this issue
http://www.eecs.tufts.edu/~stauber/mycomp20/php_dangers.php3

But you will rarely fall in such issue with php with myslq database.
_________________
Sarder Hasnut
MCSD, CIW A

Need Low Cost Prefessional Hosting Contact me

[tanveer]

hasnut,
Thanks a lot. It was a great help for me to clarify things.
It's almost a year I am working with PHP,MySQL and read many books but never found this concurrency issue in any book.
All I know was if I use persistent connection(mysql_pconnect) then it can handle upto 100 client requests simultaneously,by default. But can extend this number by editing in config file.
I came up with this question in a recent interview of mine with a bunch of idiots who were asking such questions.

Thanks anyway.