Re: Apache::DBI, DBI, DBD::MySql and MySQL cache?

Are you sure you're not having any problems with mis-used package globals in your script? This, to me, sounds more like a mod_perl error and less like a MySQL error. I've never run into this type of behavior due to MySQL, but I have run into it when I was first learning mod_perl and using package globals.

-Any sufficiently advanced technology is
indistinguishable from doubletalk.

Comment on Re: Apache::DBI, DBI, DBD::MySql and MySQL cache?

Replies are listed 'Best First'.
Re: Re: Apache::DBI, DBI, DBD::MySql and MySQL cache? by perrin (Chancellor) on Mar 17, 2003 at 15:10 UTC
That's what I was thinking too. Let's see some more code!	[reply]
Re: Re: Re: Apache::DBI, DBI, DBD::MySql and MySQL cache? by Flame (Deacon) on Mar 17, 2003 at 20:04 UTC
Ok, code, Flame's scratchpad. This is the "school project" (Code is too long to be posted here) The sub you are looking for is called quotes, it's near the end of the program. (Any packages not used there are loaded by mod_perl ahead of time.) My code doesn't have bugs, it just develops random features. Flame ~ Lead Programmer: GMS (DOWN) \| GMS (DOWN)	[reply]
Re: Re: Re: Re: Apache::DBI, DBI, DBD::MySql and MySQL cache? by perrin (Chancellor) on Mar 17, 2003 at 21:08 UTC
The code is really hard to read because you didn't put in CODE tags. However, I don't see anything wrong with that sub. I think this is a MySQL issue after all. Take a look at this coment from the MySQL manual: As of MySQL 3.23.52, MySQL changed the way RAND() functions, such that you MUST supply a SEED to get an actual random number. If you do not, each new connection will return close to the same number as the previous new connection. An example to test this would be to run the follow command multiple times in a row. mysql -u username -p -e'select rand()' A basic way to seed this would be to run RAND(NOW()).	[reply]
Re^5: Apache::DBI, DBI, DBD::MySql and MySQL cache? by Flame (Deacon) on Mar 17, 2003 at 21:34 UTC
Re: Re: Re: Re: Re: Apache::DBI, DBI, DBD::MySql and MySQL cache? by Flame (Deacon) on Mar 17, 2003 at 21:55 UTC
Re: Re: Re: Re: Apache::DBI, DBI, DBD::MySql and MySQL cache? by Hero Zzyzzx (Curate) on Mar 17, 2003 at 20:50 UTC
I think you need to fix your code tags. . .And you're using package globals. Because these don't change between script invocations between Read the CGI to mod_perl porting guide, specifically this part of it. -Any sufficiently advanced technology is indistinguishable from doubletalk.	[reply]
Re^5_2: Apache::DBI, DBI, DBD::MySql and MySQL cache? by Flame (Deacon) on Mar 17, 2003 at 21:42 UTC


Do you know where your variables are?
	PerlMonks