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?