#mysql - Tue 6 Mar 2007 between 09:30 and 09:57

NY Lost Funds



domasyeah
though you may want to use WHERE propertyrental IN (%d,3)
Bizzy%d is only as it is now because its in a sprintf string
will be a number when it hits mysql
spike"If you have low performance and SHOW INNODB STATUS reveals many threads waiting for semaphores, you may have thread thrashing and should try setting this variable lower or higher."
not sure where to locate that piece of info in that output
any help?
GutterPunknils_, I read the page but nothing works. Also, I'd like to try mysql 5.0 on this server. Are there any consequences when I make this change? I'm hoping this will also solve the issue
nils_GutterPunk, there are some incompatibilities
GutterPunknils_, is there a list available?
nils_GutterPunk, hmm changelogs...
jan___I'd recommend finding another box and installing it on there, then trying it out (carefully)
GutterPunknils_, alright. Thanks a lot :)
nils_hmm I somehow need to solve deadlock errors in replication
when are transactions written to binlog, after commit or is the whole transaction written to the binlog?
Isotopptransactions are written on commit, atomically.
that is why there is such a thing as the binlog cache
nils_great
weigon_that's why you need 2 fsync() to write the transaction-log and binlog to disk
whatspyhi, what is the actual meaning of "JOIN" alone? (neither inner, left, cross, etc...)
jan___cartesian product, I believe
ie, "both"
DEinspanjerwhatspy: Do you have an on clause?
nils_whatspy, INNER.
whatspy, if there is an on clause.
DEinspanjerwhatspy: Without an ON it is a cartisian. Otherwise it is an INNER.
erm.. what nils_ said. :)
nils_errr what deinspanjer said
choose one ;)
DEinspanjeror take a cartisian join of them. ;)
whatspyhaha
as long as it's not inner
I do have an ON clause
nils_alright, slave is catching up.
Seconds_Behind_Master: 243316
RedShiftwhat is sql state 00000?
nils_that slave will take ages to catch up.
DEinspanjernils_: time to take a tape backup and jumpstart it. :)
nils_I don't use tapes... actually I use the slave for backups which currently proves as bad idea ;)
I'll just call the datacenter and tell them to push the "turbo" button

Page: 2 9 16 23 30 37 44 51 58 65 72 79 86 

IrcArchive

NY Lost Funds