Did you try --skip-name-resolve ? Not sure if you are using any sort of caching, but memcahced may be a solution to mitigate some of the load for reads.
2009/6/8 Jancsok Akos <jak...@freemail.hu> > hi, > > I need some urgent help. We have encountered a problem, when we try to > connect in shell with a mysql client to the mysqld (via socket or via > localhost). The connection takes 5 to 50 seconds, or it happens that the > connection is fast, but then the "use somethingdb;" needs 5 to 50 seconds. > > We have tried to use some advice from here already: > http://www.debianhelp.co.uk/mysqlperformance.htm > We tried to use mysqltuner.pl, which is an optimizing tool. Here we set > "Maximum possible memory usage:", in fact the real memory usage is few megas > only. > > The other problem, which we found out in mysqlreport.txt, that if we set > "Max used" to any number, sooner or later it gets full and that is why > the "Maximum possible memory usage:" is huge in the mysqltuner.txt. > okay, so I can attach the mysql config currently used and the mysqlreport.txt > and mysqltuner.txt. > > The problem comes when the load increases during the weekend. However, this > load is still not huge, around 200 connections at a time. > > Hope someone can help us with some good advice. Thank you in advance, > > Viktor > > > > > ________________________________________________________ > Dr. Csernus Imre: A férfi - Rendelje meg 20% kedvezménnyel! > <http://bookline.hu/product/home%21execute.action?tabname=konyv&type=22&_v=Dr_Csernus_Imre_A_ferfi&id=80504&tabname=book&affiliate=frejkakar8779> > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=rstei...@gmail.com >