Hi All,
I've been lurking around on this list for a few days, and searching archives and
darn near anything else I can get my hands on. What I'm curious to find out is,
how many people are using MySQL for logging Squid/Aapache (more Squid) and how
did you go about doing it.
I've already implimented a simple system using a perl script and the File::Tail
module to dump the access logs into a MySQL database, and Apache/PHP to
edit/modify/query/update it.
What I've discovered is that a select query is extremely fast, but a delete
query takes literally forever, as I haven't been able to get one to complete
within several hours (actually left over a weekend).
The system is a Celeron 600 with 512Mb ram and SCSI hard drives which I thought
would be ample for this application, running FreeBSD 4.1 RELEASE and the version
of MySQL is 3.23.30-gamma
I'm suspecting that I should be upgrading this to 4.2 STABLE and MySQL 3.23.33
or later, but will it actually help in this instance?
Thanks in Advance
Tim
--
| Disclaimer: | Timothy Aslat [EMAIL PROTECTED] |
| The sender of this email is a figment | http://www.goodiesruleok.com |
| of a deranged imagination and leaves it| Spyderweb Consulting |
| to your own devices to decide whose... | P: 82270800 M: 0401088479 |
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
