Organic Search Agency

  Bingham: Marcosis, it is the other way round, insert . on duplicate key update . Battaglia: Can a select and insert be combined into the same statement? Salvesen: Dimi1947: See http://dev.mysql.com/doc/refman/5.6/en/insert-select.html Tomson: Hey, so I read that if I set a mysql p***word to expire, a user will be…

  Grosclaude: This is the migration file http://paste.ubuntu.com/12520147/ Swed: Absklb, but if the trace shows the exact statement being executed, then the {{user_remote_identities}} should definitely not be there - should be replaced with real identifiers Klafehn: My mysql version is mysql Ver 14.14 Distrib 5.6.25, for debian-linux-gnu x86_64 using EditLine…

  Atlas: Swed: yes but I am using the same query for each of them also Bray: Swed: so with the same query, same tables, same indices, etc. radically different results Swed: Lucid, really try the "pt-config-diff" danblack suggested to see what is the difference between the servers configs -…

  Alarie: If it's just a straight comparison debian/centos I will do that though Knudsuig: What are you talking about? it's a file on the filesystem Magness: You must be fun at parties. Mannina: Lots of times distros do things differently Cork: Apache for example, distros split different things different…

  Radder: Signing off now, thanks for the help folks! Diers: The reason I think it's ignoring the ORDER BY is if I change GetSongFromPlaylist5 from ORDER BY MR.created_at to ORDER BY MR.created_at DESC, I get the same result. Swed: Tstrimple, it should work the way you expect - http://sqlfiddle.com/#!2/e7c7e/1…

  Ashlin: The examples are on here: http://pastebin.com/NJdK7t87 Jenison: When i use the mysql binary to connect interactively, i have no problem creating and accessing tables, but when i try it non-interactively, i get access denied. can anyone suggest how to troubleshoot this? Swed: Jmpp, the last one is number…

  Oken: Well, of course, there are other fields in the table that I'd also select, i.e. the ones I need to ****yze, otherwise the whole exercise wouldn't make sense ; Swed: Jmpp, and you need to process ALL those rows? if yes then making it in batches makes sense…

  Ruffing: Juxta: How many of these max do you expect? Malbon: Xgc: ideally upto 500, but can do smaller queries if this is unrealistic Karmely: Juxta: That's not too nice. SQL is not meant to vary in width of result. Szczesny: Xgc: yeah, indeed. I could start with a…

  Vining: Are you running mysql 5.6+? Schilsky: Do you have the free disk space, and can you afford some maybe downtime, as well as turn on innodb_file_per_table? if yes, just do it Feldmeier: There are basically no downsides apart from fulltext innodb search which is added in 5.7 iirc…

  Melhorn: Scott0_: You don't have to ask to ask, or state: "I have a question", Don't ask: "Is anyone around?" or "Can anyone help?". Just Ask The Question. Also, please read: http://workaround.org/getting-help-on-irc Abuaita: Wanted to make sure you were still active Deraveniere: Brittman: http://pastie.org/pastes/10436537/text?key=aeswx6ysarhf0gbc1x2a Brittman: Scott0_: i'm not, don't…