Re: OK - all seems to be working well... now...

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--===============0346235151==
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enigB02C8189905352305D343F9B"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigB02C8189905352305D343F9B
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Simon wrote:
> I have a everything working well and i have mod_log_sql creating
> tables with "mod_WEBSITEID_log".. and its intergrated into our
> PHP/MySQL apache virtual hosts management interface. I have two
> questions before rolling out:
>=20
> 1). Ive noticed that there is no primary key on the access_log tables,
> is this an issue at all for any reason? What is the reason for no
> primary key?

There have been threads about this in the mailing list archives

http://thread.gmane.org/gmane.comp.apache.mod-log-sql/289/focus=3D289
and
http://thread.gmane.org/gmane.comp.apache.mod-log-sql/303/focus=3D303

Read the second one especially the posts by matt erbst.  He has some
insight into the pros and cons of indexing a logging table like this.

I will be doing more research into this for the next release, as well as
playing with MySQL 5 and the archive engine (of which seems a perfect
fit for mod_log_sql).

> 2). I have a dual 2.8 xeon web server with approx 350 web hosts all
> with php and mysql access... i have setup a seperate single 1.5Ghz
> athlon server for the mysql apache logging server. both have 1GB+ RAM
> - any thoughts on issues in going live with all 350 hosts?

=46rom load tests by the previous author that seems like it should handle=

it.  It really depends on how much traffic too. Search through the list
archives (on gmane.org), as this has been discussed before.
http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/?chapter=3D=
/4/#id_4_1_3

Things to assist in improving performance is me adding back in delayed
inserts. Which I plan to do for next release when I find time.




--------------enigB02C8189905352305D343F9B
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFEiYqHvwMxRUUct20RAt40AJ9SBAALzKqoGorqKiDm3UxfVfjH3wCdEADx
UBa89lEvlxFBDhq2WQHKIDo=
=OpT0
-----END PGP SIGNATURE-----

--------------enigB02C8189905352305D343F9B--

--===============0346235151==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/

To unsubscribe send an e-mail to 
mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org

--===============0346235151==--