Re: PHP /MySQL problem on SMP machines

Hi Curt, Thanks for your email - please find answers below: Regards -- Lasse Laursen · VP, Hosting Technology · NetGroup A/S St. Kongensgade 40H · DK-1264 Copenhagen K, Denmark Phone: +45 3370 1526 · Fax: +45 3313 0066 - Don't be fooled by cheap finnish imitations - BSD is the One True Code ----- Original Message ----- From: "Curt Zirzow" <php-general@zirzow.dyndns.org> To: <php-general@lists.php.net> Sent: Sunday, April 25, 2004 5:52 PM Subject: Re: [PHP] PHP /MySQL problem on SMP machines > * Thus wrote Lasse Laursen (laursen@netgroup.dk): > > Hi all, > > > > We just installed PHP 4.3.6 on FreeBSD 5.2.1 on some SMP machines and we are > > experiencing some weird problems. > > > >... > > > > The database backend is MySQL 4.0.18 and is run on a seperate dedicated > > server. > > What mysqlclient is php linked to? > php -i | grep "Client API" > > I would make sure you're using a 4.x version. webnode2# ./php -i | grep "Client API" <tr><td class="e">Client API version </td><td class="v">3.23.49 </td></tr> That could be one of the problems - how do I specify that I wish to use the 4.x API? > > Last night some problems occured - when we queried the databases for simple > > queries that _should_ return some rows (and worked minutes before) the > > database simply returned 0 rows. A restart og the mysqld and the php > > processes solved the problems but they return at random. > > A couple things to check: > - the output of mysql_error(), it usually solves 90% of query > problems. > > - if myismchk was ran on the table(s) mysql can get confused > about the indexes (until the table(s) are flushed) No errors occur that give an mysql_error at any time. Queries on the database simply returns the "wrong" information...