Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: Mysql query cache?

Posted on 2008-01-09 12:33:28 by michalkuls

Hello.
I have a strange problem with my website at work. There is a database
with some product data. Data is registered thru php - website, and
once a week a raport is generated from this data. If a mistake was
made, the data of current week can be corrected in the same way as it
is input. Also there is a part which draws graphs showing registered
data on time based graph.
The problem is, since 2 days something happened and the report
generated shows invalid data - from the current week, not the most
recently corrected. I don't keep corrected data. It's no longer in
database. But it appears in the report. In the graph showing part the
problem doesn't exists. The most recent data is shown there. And
still it uses the same data table.
The problem never happened before (the website exists for many
months).

I'm looking for some advice what could have happened? After rebooting
the computer-server the most recent data was loaded into the report,
and the problem continued if any new corrections were made after the
reboot.

It looks to me that it is some kind of a buffer which holds the
queries...?

I even have screen-printed the query and - following - the results. If
I executed the screen-printed version in SQL-yog - a SQL managing
program - the result was correct. But still in the application - the
data was not up-to-date.

The screen -printed query is:
"select
columns_wr.nazwa2,weekly_sales.value,weekly_sales.week,weekl y_sales.week,columns_wr.event2,columns_wr.product_id
from report.columns_wr,report.weekly_sales
where columns_wr.product_id=weekly_sales.product_id
and columns_wr.product_id=65
and date>='2007-12-10' and date<='2008-01-13' order by date"

Report this message

#2: Re: Mysql query cache?

Posted on 2008-01-09 12:56:39 by michalkuls

Maybe it helps:
The MySQL version is 5.0.37 and the table has six columns (one of
which contains texts about 20-30 chars long) and about 27000 rows.

Report this message

#3: Re: Mysql query cache?

Posted on 2008-01-09 13:54:44 by Captain Paralytic

On 9 Jan, 11:56, michalk...@o2.pl wrote:
> Maybe it helps:
> The MySQL version is 5.0.37 and the table has six columns (one of
> which contains texts about 20-30 chars long) and about 27000 rows.

I'm not sure where php comes into this.

Maybe you'd be better off asking in comp.databases.mysql

Report this message

#4: Re: Mysql query cache?

Posted on 2008-01-09 16:58:04 by michalkuls

On 9 Sty, 13:54, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> On 9 Jan, 11:56, michalk...@o2.pl wrote:
>
> > Maybe it helps:
> > The MySQL version is 5.0.37 and the table has six columns (one of
> > which contains texts about 20-30 chars long) and about 27000 rows.
>
> I'm not sure wherephpcomes into this.
>
> Maybe you'd be better off asking in comp.databases.mysql

This problem is definitely connected with php. If I edit/search data
through mysql-interface everything works perfect. It only happens if I
enter and read data through php web page.

Report this message

#5: Re: Mysql query cache?

Posted on 2008-01-09 17:51:12 by michalkuls

On 9 Sty, 16:58, michalk...@o2.pl wrote:
> On 9 Sty, 13:54, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
> > On 9 Jan, 11:56, michalk...@o2.pl wrote:
>
> > > Maybe it helps:
> > > The MySQL version is 5.0.37 and the table has six columns (one of
> > > which contains texts about 20-30 chars long) and about 27000 rows.
>
> > I'm not sure wherephpcomes into this.
>
> > Maybe you'd be better off asking in comp.databases.mysql
>
> This problem is definitely connected with php. If I edit/search data
> through mysql-interface everything works perfect. It only happens if I
> enter and read data through php web page.

please check out my next post for more info on this problem

Report this message