| Limits and datatype for connection_id() [message #3650] |
Fri, 24 October 2008 09:25 |
 Poul
Messages: 1
Registered: October 2008 |
Junior Member |
|
|
Hi,
we use connection_id() return value to fill some fields in a mysql-myisam database.
I have spent a lot of time researching about the returned value, but I have not found any interesting information, so I'm asking this blog which I follow from one year now.
My questions are:
- select connection_id() returns an integer value: what are the limits? How should a declare the field to store it?
- what will happen when the limits are reached? Yes, it is possible; we are managing millions of connections per day on a single database...
- is it there any other better parameter available in a query, to ensure that two concurrent users will have returned different values?
Many thanks in advance.
|
|
|
Members
Search
Help
Register
Login
Home
