|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
|
|||
|
|||
|
Some Ideas about Connection Buffer Pool~~~
Connection Buffer Pool
------------------------ Hi, I'v got a sudden idea. When i using php and mysql to do some project, i found that if too many users connected my database server at the same time,something happend. Mysql always alert "Too many connectios!!!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Maybe mysql can not afford too many connected thead at same time.What should we do?? I thought we may use some conception as jsp or java defined. It is called "Connection Buffer Pool". As i konw,php nowadays doesn't have the similar function like that . I wanna do something about it.~~ V may use a array as a pool,the pool has a size limit, and it is FIFO(Firsrt In First Out). We use this array to store user's connection thread. So we call it Connection Buffer Pool. If the connected thread overstep the array's limit,we buffer it but not kill it.When other guys logout ,we put that thread in. If the pool is spare ,it makes some threads to wait users to use. This can save much time when user connect to the pool. Connection Buffer Pool may help us to control user's connected thread to database,it works during the whole process. ~~~~~~~~~~~~~~~~~~~~~ Maybe its not a good idea,i just think about.I just feel like doing something about it. Althouh it is just an idea,a sudden thought of mine,if we on the road,the chance to achieve it is greater. Can someone help me to do this. Maybe we can work together. Or give me your ideas or suggestions. Thx. |
|
#2
|
|||
|
|||
|
Well, my thing is if you are getting to many connections on the database at the same time, it's time to start using some sort of caching architecture to save on the database load.
Your project could be a usefull one though...
__________________
~ Joe Penn We work for free to help make this a valuable resource on the internet. Do you appreciate the help - did we provide help that will help you prosper and help that has contributed to sharpening your current skill set? Show your appreciation and purchase something from our Amazon Wishlist's - it's simple and a great way to say thank you. |
|
#3
|
|||
|
|||
|
Quote:
HI~~~~ jpenn thx for your idea can u give me more information about the caching architecture how it works~~~~~~~ |
![]() |
| Viewing: Dev Articles Community Forums > Programming > General Programming Help > Some Ideas about Connection Buffer Pool~~~ |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|