Organic Search Agency

  Losh: A ton of **** changed in the optimizer Brittman: Scott0_: you moved the data files, not the binaries. you have no idea if the QEP changed because you haven't run explain. Brittman: Scott0_: query execution plan. Sarchet: Why would this not be in the upgrade docs? Brittman: Scott0_:…

  Kovalcik: The explains would be identical Boehne: Are you saying my schema changed? Brittman: Nope, i am saying that your index statistics may have Brittman: Thus, you may see a different optimization strategy, different indexes used Brittman: You might even see something done in 5.5 that wasnt possible in…

  Sollie: I don't know what to replace anything with. This is my time to learn. Keiter: Volund: take your time. Read docs. Notarnicola: Keiter: I have to find out which docs to read. :P there are so many interwoven systems here like apache and mysql and the php configs…

  Ditto: Now everything is clear Semonick: Dovid: you can, the link I provided shows how to set the tmpdir Ammon: Blade: I didnt see. thanks Brittman: Dovid: beware, if your ssd is mounted directly at /var/lib/mysql you might not want to set tmpdir to a subdir of the datadir…

  Colker: I really have never seen MySQl just randomly shut down though. ever Suran: Hello, is inner join without any constraint no on keyword is same as full join Umfleet: Thank you, can you tell me what is the difference? Brittman: Http://math.stackexchange.com/questions/668885/is-cartesian-product-same-as-sql-full-outer-join Bogany: Brittman: results show engine innodb statusG…

  Cepero: Because otherwise it won't do an outer join. Torrado: You would have to LEFT JOIN instead of INNER JOIN eptp if you wanted to keep them in the order they are Belmont: Hello does anyone here uses workbench ? im trying to do a query but my result…

  Kuester: Does 5.5 utilize more threads/CPUs with default values? Boardwine: Im thinking that's where my problem exists Dubill: Danfield: if those changes aint successfull for whatever reason can I undo them and will the server after new restart of dbserver fallback to what it is/was befor the changes? Seabreeze:…

  Antwi: Rathrock: wtf does line 55 do? Lesley: Thanks Naktibalda got it with a more tricky thing SUBSTRINGd.name, 1, CHAR_LENGTHd.name-8 Lesley: Is that the typical way to get a substring from the left side to. rather than . right side? Shepperd: Rathrock: apparently mariadb 5.5 optimizes that subquery and…

  Keiter: Rathrock: right. And I'm giving you hints on where you should start. Cegla: Rathrock: well you aren't listening to one of the most knowledgeable people in this channel : Mithell: Keiter: no crown for you. Laurito: Rathrock: See http://dev.mysql.com/doc/refman/5.6/en/using-explain.html Letman: Rathrock: See http://dev.mysql.com/doc/refman/5.6/en/slow-query-log.html Keiter: Rathrock: and use SHOW…

  Cupples: I came in for help because it was slow, but was then informed it didn't work and should be rewritten. so I've done that but now I'd like someone to look and tell me if Ragusa: 1 it gives the expected results and 2 there are any obvious…