ID: 32675 Updated by: [EMAIL PROTECTED] Reported By: michael at cosby dot dhs dot org -Status: Open +Status: Feedback Bug Type: MySQL related Operating System: Linux 2.6 PHP Version: 5.0.4 New Comment:
Noticed this: "apache 2.0.52 in multi-threaded mode".. What if you try with prefork apache2? Previous Comments: ------------------------------------------------------------------------ [2005-04-11 22:24:45] michael at cosby dot dhs dot org It appears that I'm already using the external mysql client library, or I'm reading phpinfo() wrong: MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 4.0.21 MYSQL_MODULE_TYPE external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib -lmysqlclient ------------------------------------------------------------------------ [2005-04-11 20:04:08] michael at cosby dot dhs dot org For the libraries, it appears that my PHP is *not* compiling with the 4.1.11 client library, but with a 4.0.21 client library. I'm trying to get it to compile with with the 4.1.11 library to see what happens, but I doubt that will fix it since this same 4.0.21 client library works fine with PHP 5.0.2. ------------------------------------------------------------------------ [2005-04-11 20:01:16] michael at cosby dot dhs dot org It looks like my query cache is already disabled: mysql> show variables; +---------------------------------+----------------------------+ | Variable_name | Value | +---------------------------------+----------------------------+ ... | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 0 | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF | ... >From the mysql manual at http://dev.mysql.com/doc/mysql/en/query-cache.html: " To disable the query cache at server startup, set the query_cache_size system variable to 0. By disabling the query cache code, there is no noticeable overhead. " (I'm not real familiar with the query cache, so I wanted to be 100% sure it was disabled). ------------------------------------------------------------------------ [2005-04-11 19:54:43] [EMAIL PROTECTED] Does the problem still exist if you disable MySQL's query cache? ------------------------------------------------------------------------ [2005-04-11 17:56:45] [EMAIL PROTECTED] Try configure PHP using the external mysql client libraries: 1. delete config.cache file 2 run your configure with this change: --with-mysql=/usr (or whatever the install PREFIX is) Also note: /usr/local/lib or /usr/lib are NOT correct values for any PHP configure option!! They're /usr/local and /usr ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/32675 -- Edit this bug report at http://bugs.php.net/?id=32675&edit=1
