am moving this blog to www.tahhan.me to be more free
thanks for every thing wordpress
am still using it
Close The Connection
November 17, 2009 at 10:28 pm (tecStop)
Tags: database, it happens, MySQL, PHP
If you get a Too many connections error when you try to connect to the mysqld server, this means that all available connections are in use by other clients.
always make sure you close the connection of the database by mysql_close() and in the mysql_connect() set new_link to false and set client_flags to MYSQL_CLIENT_INTERACTIVE flag (it will use the MySQL interactive_timeout value instead of wait_timeout) for limiting the number of connection and limiting the connection timeout and don’t forget to maximize the number of connection by setting MySQL max_connections variable to the number you think its better to your web server (the default in MySQL 5.1.15 is 151, previously, the default was 100 but most servers dose not use MySQL 5.1.15 yet ) if you really want to know how i’ll tell you later about how much servers can handle.
Since wait_timeout defaults to 8 hours. However, surprisingly, interactive_timeout also defaults to 8 hours. You should change this value to something smaller that fits your system.
Hello world!
November 17, 2009 at 5:03 pm (HI!)
Tags: first time, new
Hi am Ahmad Tahhan,
dont think am new with blogging but you know am try something new this is my specialty with working and life ” try something different ” i ‘ll not talking about every thing happens in my life it’s twitter job i ‘ll talk about some thing useful “i hope “
