#mysql - Tue 27 Mar 2007 between 01:52 and 01:59

NY Lost Funds



seekwillagore: What does your cronjob do?
Melt_Downseekwill a mysql bug
agoreits an online sports game
seekwillMelt_Down: Definitely raymond
Melt_Downhttp://hashmysql.org/paste/viewentry.php?id=7476
agorethe cron job calcualtes all the results for everybody at 8pm every night
seth1246raymond: When you said reload you meant I should do a flush privileges after granting? Or else why would the mysqldump user need reload priveleges?
Melt_Downafter the first null value mysql encounters it stays null
if you definde the fields "null" then it works ok
hope you can repeat it
agoreseekwill: the more people that play the more time the 8pm cron takes to complete
Melt_Downraymond here?
seekwill can you atleast try what the results are with your version? :)
seekwillagore: it could be the way you do things that is slow... It's a big job. You may want professional services.
agoreit does millions of queries
Melt_Downonly copy past into a db, all tempory
raymondMelt_Down: Why a sub select? and GROUP_CONCAT without a GROUP BY just has no hope of working.
agoreseekwill: who would you reckomend for professional services ?
apart from MySQL AB
Melt_Downraymond this is a very stripped version of a big query
raymondMelt_Down: Ok, my points still stand.
Melt_Downthe subselect gets multiple values which it concats for the main query to be a field there
better? :)
seekwillMelt_Down: http://hashmysql.org/paste/viewentry.php?id=7477 There
raymondagore: going out on a limb here but... http://www.mysql.com/consulting/
</shameless plug>
seekwillMelt_Down: All I did was run it. Didn't even look at the logic.
Melt_Downseekwill you got the same problem
seekwillagore: Where are you located?
Melt_Down: Yes, I got the same problem. But that doesn't mean it's a bug.
Melt_Downafter the first null everything keeps null
agorethe UK, but Im based in South America
Melt_Downit should return 1 lateron again
seekwillagore: Oh. Just wondering. yeah, I'd go to MySQL :)
Melt_Downraymond can you check the query to ?
raymondMelt_Down: Sure, but it won't mean much to me.
agoreseekwill: they are really expensive, like $5000 just for 4 days
raymondMelt_Down: I never did get the hang of SQL trees.
seekwillagore: You get your money's worth :)
agore: I don't work for them :)

Page: 5 12 19 26 33 40 47 54 61 68 75 

IrcArchive

NY Lost Funds