General Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsProgrammingGeneral Programming Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
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  
Old January 12th, 2003, 09:59 AM
martin_dr martin_dr is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2003
Location: Berkeley ,california
Posts: 9 martin_dr User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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.

Reply With Quote
  #2  
Old January 12th, 2003, 01:40 PM
jpenn jpenn is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2002
Location: Washington, DC
Posts: 317 jpenn User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 m 3 sec
Reputation Power: 6
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.




Reply With Quote
  #3  
Old January 12th, 2003, 06:39 PM
martin_dr martin_dr is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2003
Location: Berkeley ,california
Posts: 9 martin_dr User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally posted by jpenn
it's time to start using some sort of caching architecture


HI~~~~
jpenn
thx for your idea
can u give me more information about the caching architecture
how it works~~~~~~~

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingGeneral Programming Help > Some Ideas about Connection Buffer Pool~~~


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Iron Speed




© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway