[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Date problem
From:       Danny Arseneau <danny () mamma ! com>
Date:       1999-08-25 20:09:25
[Download RAW message or body]

Hi guys, I hope that someone can help me out here. We are using mysql to
store various bits of data about activity on our website. For each visit
to our site we insert some information into a table.

The table is defined as follows

table queries
(
    query  char(255),
    querydate date,
    qtype int,
    partner char(30)
    primary key (querydate)
);


We use the following insert query

insert into queries (query, querydate, qtype, partner) values ('XXXXX',
now(), 1, 'XXXXXX');

This query is performed approximately 140,000 times a day from 5
different servers.

Our problem is that after about 4 days we see about 20 entries where the
field querydate is set to (0000-00-00).

Has anyone else seen this behaviour? Is there something wrong with our
setup? What could possibly be causing this to happen?

We are running mysql-3.22.19 on a Dual Pentium III (550Mhz) with RedHat
Linux 6.0
-- 

Danny Arseneau
Chief Technology Officer
Mamma Systems Inc.

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread11311@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]