Who we are   Organizations   Get Involved!   Helpdesk   Weblog   About FLORA   Server project   F.A.Q.

Election 2006 (and beyond): Digital Copyright Canada

Re: mysql changes for performance

From: "Krishna E. Bera" <keb_-at-_cyblings.on.ca>
To: flora-admin-design_-at-_flora.org
Cc: team_-at-_openconcept.ca
Date: Wed, 13 Nov 2002 03:04:10 +0500
References: <Pine.LNX.4.44.0208271013220.3768-100000@calcutta1.flora.ca>

using the PEAR benchmark class,
i found the intermittent speed problem with the
w-agora php/mysql application on calcutta:

mysql_free_result was being called with an invalid result handle.
for some reason it was being called as @mysql_free_result
which meant the error message about invalid handle didnt appear.
simply removing calls to this eliminated a 189 second delay.
the memory used by mysql results is freed automatically up script exit,
so it was never necessary to call it explicitly when in doubt.

why doesnt this happen on other machines with apache/php/mysql installed?
likely the combination of mysql-client-lib and php-mysql,
as compiled for calcutta.  don't know if worth further investigation.

now to see if the same thing is happening when other apps
e.g. phpNuke, LETS, Back-End
have strange very long delays in some database operations.

in the course of investigation, i also noticed that
several optimizations such as INSERT DELAYED, UPDATE LOW_PRIORITY,
index management, and using mysql_query instead of mysql_db_query
could improve speed marginally in the low-usage situation we face.

-krishna

Please read the FLORA.org Terms and Conditions before you submit information to FLORA.org
Join the Blue Ribbon Online Free Speech Campaign (USA) (Canada)	FLORA Community Web (FLORA.ORG) is sponsored by FLORA Community Consulting (FLORA.CA).