http://qs321.pair.com?node_id=243639


in reply to 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]
      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]
        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]

        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]

In Section Seekers of Perl Wisdom