Hello.
As said Guilhem Bichot. It will go up to 232 or 264 depending on your architecture (32 or 64 bit) then it will go down to 0 and grow again. There is nothing wrong with having a thread of id 0 (I had tested). >> I've looked though code of mysqld.cc, but haven't found any checks. >> The value of thread_id only increments: >> thd->thread_id=thread_id++; >> >> Is this a problem? No, the only problem which could happen is if thread 1 still exists when a new thread of number 232+1 == 1 is created. But that sounds unlikely. Batara Kesuma <[EMAIL PROTECTED]> wrote: > Hi, > > I noticed that the number of id when I do show processlist is getting > bigger and bigger. Now it is about 444,466,168. What is the maximum > number, and what will happen if it runs out of number? > > --bk > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]