Hi guys
I am going to fetch out the data from remote mysql database according to
timestamps colmmen, however my local date is different from the one on
remote mysql database,
how can I get right timestamp using the date of remote time zone? that
is to say I set the date and send itto remote ser
Dear all,
I am running mysql server sharing with apache web server in a box of freebsd
6.4. Hardware spec is roughly as bellow:
CPU: Xeon 3.06GHz x 2
Mem: 4GB
The version of Mysql is 5.1.17_beta, a pre-complied binary package for FreeBSD.
Recently the apache request raises quickly, sometime
Nigel/Marcus/Johann
mg>hopefully quick answer
>
> nigel wood wrote:
> >
> > Here's a rough table stucture. The indexes in events tables would be
> > TargetId.
mg>there would be need to be a 1:1 correspondence between
mg>TargetId index and Username..all of your other tables would need to know
nigel wood wrote:
Here's a rough table stucture. The indexes in events tables would be
TargetId. But problably TargetId+EventDate probably eventId+event date
as you found more uses/added paging.
Well that didn't format very well :-( The tables structures are:
User/Actor
===
TargetId
On Fri, Jul 3, 2009 at 12:09 PM, Marcus Bointon
wrote:
> On 3 Jul 2009, at 09:42, Johan De Meersman wrote:
>
> To be honest, this sounds like more of a filesystem thing, given that you
>> only ever need to select the full set of an individual user. Just build up
>> an FS structure with one file p
Marcus Bointon wrote:
"For the most part this is write-only and is only ever read very rarely,
but when I do, it will be to retrieve the details of a single user, and
all I need is the whole history, not individual events."
For your stated requirements the filesystem is probably most efficien
On 3 Jul 2009, at 09:42, Johan De Meersman wrote:
To be honest, this sounds like more of a filesystem thing, given
that you only ever need to select the full set of an individual
user. Just build up an FS structure with one file per user.
You really think so? Even though I'll need to initi
To be honest, this sounds like more of a filesystem thing, given that you
only ever need to select the full set of an individual user. Just build up
an FS structure with one file per user.
On Wed, Jul 1, 2009 at 7:57 PM, Marcus Bointon wrote:
> I need to log fairly large numbers of historical eve
