Zend Framework slow connect to Mysql

Question

Using Zend_Db_Profiler_Firebug and FirePHP to profile our code, all other queries after the connect is fast, but it seems to take forever for Zend Framework to establish a connection to mysql, I've googled the problem and others suggest using table metadata cache which I did, but the problem still persists.

ZendDbTableAbstract::setDefaultMetadataCache(ZendRegistry::get('cache'));

We're using ZF 1.7, php 5.2 and Mysql 5.1, please see the screenshot for more details.

http://imgur.com/8FsgK.png

I'm beginning to suspect this could be a Mysql configuration issue and I'm going to look into that now, but I do appreciate any ideas or suggestion regarding this problem, thanks.

Answer 1

If it is a problem on Zend's side then this should help:

http://stackoverflow.com/questions/1275375/zend-framework-and-mysql-very-slow