The Heap™ – Consultancy ©®

Q: Kill mysql process only for particular host automatically

7:45 AM

morning

mooning

Morning

Morning

8:27 AM

morning

1 hour later…

Tom V

9:32 AM

-1

There is many process running from different host on server. When i run SHOW FULL PROCESSLIST; It gives me following output: +------+--------+---------------------------+------+---------+------+----------------+-------+-----------------------------------------------+ | Id | User | Host ...

mysql

Tempted to post an answer changing his query into where id=2613

billinkc

It's mysql, they'd be better served with rm -rf /

ConcernedOfTunbridgeWells

9:54 AM

Morning all

1 hour later…

Q: Optimize long left outer join query

11:00 AM

There might be an interesting question about the optimizer, (somewhere hidden in that question):

I have query which has 40+ left outer joins. Query is not that slow but I'm interested that can I optimize this (procedure is most used one in db). I had idea that "a" table has type column which value basically says that there is data in c or d tables. So I thought that I add AND a.type LIKE 'ty...

sql-server sql-server-2012 optimization join

Or perhaps a rather rare case and not useful to everyone else

1 hour later…

12:20 PM

Does it produce the same plan if you change the LEFT joins to OUTER APPLY? From LEFT OUTER JOIN b on (a.id = b.id and a.type LIKE 'typeb') to OUTER APPLY (SELECT b.* FROM b WHERE a.id = b.id) AS b ON a.type LIKE 'typeb' ? — ypercubeᵀᴹ 1 hour ago

@ypercubeᵀᴹ ^^^ OUTER APPLY (SELECT b.* FROM b WHERE a.id = b.id) AS b ON a.type LIKE 'typeb' is incorrect syntax. Unlike PostgreSQL's LATERAL, APPLY doesn't accept an ON clause. So, in that case you just move the a.type predicate to the APPLY query's WHERE.

@AndriyM Ah, thnx for the correction. I always get confused when switching from sql sevrer to postgres and reverse

I find the LATERAL syntax much more flexible, although at first I was confused by it.

Paul White

That question needs a clear example, code and data. I'm not prepared to guess the question as well as invest in writing an answer.

Answer only good as question, as a wise person once said.

Perhaps one of the two people who voted it up will answer it.

Perhaps (s)he already has.

In which case maybe the other will have a suggestion as well.

Paul White

Perhaps :)

12:34 PM

@PaulWhite that's why I said "somewhere hidden inside"

It's curious that the OP chooses to describe the execution plans verbally instead of posting a picture or linking to an uploaded XML.

@AndriyM Removed my comments. I'll fly away from that q. Not that Intended to answer it.

12:54 PM

@PaulWhite so that's why we don't have a reversal badge yet?

Yeah, too many wise people on the site.

2 hours later…

2:36 PM

Please post valid syntax. Also, I think the official documentation is a way better source than tutorialspoint. — dezso 8 secs ago

Paul Vargas

3:00 PM

Survey: What is the best place to apply I18N of a table if its data is shown in the front-end? In another column or in another table or a bundle?

Take as an example this list of countries to be showed in Spanish, French, etc..

@PaulVargas bundle?

Paul Vargas

@dezso I mean a resource bundle.

A: Database modeling for international and multilingual purposes

@PaulVargas from how it sounds definitely not there ;)

I'd go for a data store, depending on the size

for a few languages a translation table could be enough

for a big internation online shop where everything is translated to multiple languages there are some better ideas

Paul Vargas

Here is the way I would design the database: Visualization by DB Designer Fork The i18n table only contains a PK, so that any table just has to reference this PK to internationalize a field. The table translation is then in charge of linking this generic ID with the correct list of translatio...

^^^ Did you mean something like that?