From: Chris Eidem <ceidem@Dexma.com> - 2006-02-23 15:04:11
I've had a this trouble for a while, so I thought that I'd finally do =
something about it. I run BASE 1.2.2 on an OpenBSD 3.7 box with the =
following versions of Apache and MySql:
ceidem@... /home/ceidem$ httpd -V
Server version: Apache/1.3.29 (Unix)
Server built: unknown
Server's Module Magic Number: 19990320:15
Server compiled with....
ceidem@... /home/ceidem$ mysql -V
mysql Ver 12.22 Distrib 4.0.23, for unknown-openbsd3.7 (i386)
(more information on request)
The basic problem is that I have four remote sensors sending data to =
this box (clarke) and after about three weeks the number of records =
becomes so large that BASE (or MySql or Apache or PHP) can't do queries =
without giving my browser a connect: close. I get something over a =
million records and I can't query or delete without going into MySql =
My question is, where should I start troubleshooting this? Has anyone =
seen this? I'm no Apache or PHP wizard and I don't know much about =
MySql (though I'm learning quickly :) ) so I'm not sure where to begin =
looking. How does one troubleshoot BASE? Do I need to tune MySql? =
Tweak PHP? Reconfigure my httpd?
I'm not really looking for someone to diagnose the problem, I just need =
a point in the right direction. Though if someone does know offhand, I =
wouldn't turn 'em away...
Thanks in advance,
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
Secureideas-base-user mailing list
Get latest updates about Open Source Projects, Conferences and News.