Linders: Intent: If you change the data, that allows you to use NOT LIKE once without the CONCAT. If you don’t change the data, you can use NOT LIKE with the CONCAT or use NOT FIND_IN_SET
Botterbusch: Xgc: wouldn’t that FIND_IN_SET also match any number that had three in it
Erich: Intent: 3 is not in that set.
Hoyles: I’m testing those now.
Bernoski: Intent: SELECT FIND_IN_SET’3′, ‘30,31,32,33’;
Vanasten: Xgc: All three work, and the difference to execute them is minimal. Actually the first, longer one, executes the fastest by 0.0001s
Robertello: Xgc: Actually, I’m wrong, the times fluctuate when I run the multiple times-in any case the two new ways are way easier to maintain, so thank you for that.
Dashne: Intent: Be careful drawing conclusions from your timing tests.
Oliveira: I suppose you mean the timing doesn’t accurately indicate other factors, like server load?
Vacanti: It’s sometimes difficult to accurately time these things.
Simental: Intent: Also factors like caching, etc.
Classon: I think I’m happy with this now. I tried figuring out NOT EXISTS instead of NOT IN but couldn’t get it to work, so I’m going to call this a victory. Thank you again for your help.
Larusso: Relatively speaking of course
Clearman: How do i pivot table my table?
Galven: Maskio: http://www.artfulsoftware.com/infotree/queries.php?&bw=1223#78 ## MariaDB only solution: https://mariadb.com/kb/en/connect-table-types-pivot-table-type/
Widdowson: Hello is it possible to disable session sql_log_bin and force for all sessions for sql_log_bin = 1
Mathern: Hey, I have this error on my slave: Got fatal error 1236 from master when reading data from binary log: ‘log event entry exceeded max_allowed_packet; .’ how can i skip that?
Thometz: Chepra: increase max allowed packet value x
Heltzel: JesusTheHun: Hey, I got busy and didn’t get a chance to respond to your questions the other day
Minger: JesusTheHun: And now I don’t remember what they were. :
Perrine: Cheramie: oh thats kind, I don’t remember neither x
Kuzel: But i’ve a new one for you today 😀
Aubertine: Look at this http://sqlfiddle.com/#!9/8c5d1
Augusta: The query is a try #fail
Herandez: I want the lowest rank for each csc, token 😀
Kinkel: JesusTheHun: oh, group by?
Ritterbush: I’m not actually that good with SQL
Ohlen: I know how to do it when you join only one row, but for two :/
Kirkhart: Afaik group by cannot guarantee which line will be taken
Pritchett: I’m an SRE, not a DBA, so I look at things a little strangly
Rumery: JesusTheHun, the fiddle does not contain your query as it is not saved on error?
Bermudez: Site Reliability Engineer / Systems Engineer / Production Engineer
Henn: I deal with application performance and reliability issues, not just mysql stuff
Henard: K, you are the annoying IT guy 😀
Moscariello: Anyway, let me know if you play with the prometheus/mysqld_exporter stuff
Alaibilla: I’m looking for more feedback
Campion: I’ve given the name to my SRE, he’ll give a look soon
Clancy: Rumery: sqlfiddle looks broken x
Fossett: Cheramie: I work in a bank, if we go for it, it’ll take time
Rumery: JesusTheHun, fiddle sometimes timeouts for me, it does not work for few minutes to half an hour and then starts working again
Moisant: Rumery: hey, the schema + query broke fiddle, here is the query : http://pastebin.com/S9Bkz8RY
Rumery: JesusTheHun, sorry for the delay. and you want groupwise-max for each csc, token combination “ordered by” rank?
Exum: Hi. i want to stop mysql to insert a row in my table if a constraint based on another table value isn’t verified. Do i need a trigger for this?