How to get full query text from performance_schema.threads? According to : Access to the threads table does not require a mutex  and has minimal impact on server  performance. The other sources have negative performance consequences because they require a mutex.   So yes, I want to use threads table to examine running queries. The trouble is, the PROCESSLIST_INFO column does not contain the full query. It just contains a truncated version of the query. There is a flag viz performance_schema_max_sql_text_length which controls how many bytes are allocated for the SQL query. But it seems to affect the events_statements_history_long table. There is no change in the thread table output. Am I missing something?
How to get full query text from performance_schema.threads? According to : Access to the threads table does not require a mutex  and has minimal impact on server  performance. The other sources have negative performance consequences because they require a mutex.   So yes, I want to use threads table to examine running queries. The trouble is, the PROCESSLIST_INFO column does not contain the full query. It just contains a truncated version of the query. There is a flag viz performance_schema_max_sql_text_length which controls how many bytes are allocated for the SQL query. But it seems to affect the events_statements_history_long table. There is no change in the thread table output. There is also the events_statement_current table. But it is not clear if accessing that table affects performance or not.
Thailand visa exemption: any rule limiting number of entries per year? How do I check if a file exists in Java? You can start fire by focusing the sunlight using the magnifying glass.   I searched the web whether you can do the same using moonlight. And found  and  - the first two in Google search results.  What I found is the thermodynamics argument: you cannot heat anything to a higher temperature using black body radiation than the black body itself, and Moon isn't hot enough.  It may be true, but my gut feelings protest... The larger your aperture is, the more light you collect, also you have better focus because the airy disk is smaller. So if you have a really huge lens with a really short focus (to keep Moon's picture small), or in the extreme case you build a Dyson-sphere around the Moon (letting a small hole to the let the sunlight enter), and focusing all reflected light into a point it should be more than enough to ingnite a piece of paper isn't it?   I'm confused. So can you start fires using the Moon? Posting to friends' wall with Graph API via 'feed' connection failing since Feb 6th 2013 How to change folders color? How do i change the folders colors? i am using this icon theme   and there are several folders. like black, gray, purple, orange(which is the default), yellow, green, red, blue, brown and lightblue  How can i use any of them? for example have a blue folder called "family" in images and another right beside that have a purple folder called "others".  Basically why have he created all those folders with different colors? How can I set custom key bindings and key macros on Mac OS X? I recently upgraded to Snow Leopard, from Leopard and I was using an awesome app called  that let you remap your keys, set scripts/macros and even had repeat functionality.   However, this app doesn't seem to be in active development anymore, and 10.6 broke the ability to bind certain modifier keys (Shift) with other keys.   I totally miss things like Shift+Insert for paste (Linux/Windows), setting Ctrl+Shift+Esc for Activity Monitor, and Ctrl+Alt+Del for the login window.   So, how can I achieve this instead? How can I take a photo with everything in focus with my DSLR? I am quite new to DSLRs and one of the first things I noticed was the incredible focus points and appearance of depth that you can achieve. That is great in a lot of scenarios, but not in all. When filming a landscape as a whole, I do not want to have the focus on that single tree, but on the whole skyline.  Is there a way by which you can sort-of "disable" the focus, so that the raw image is recorded without any added blur? I suppose something as simple as this is only a small function you can turn off, but I can't seem to find it in the manual of my camera. Rules for Profiles Are there any rules concerning what I can put in my profile? How to use siunitx with non numerical values? How do I remap the keys on my keyboard? I broke my laptop and had to buy a new one with a new keyboard that I am struggling to get familiar with, especially with the keys like home, page-up, page-down and end, which aren't standardized at all.  I found myself doing this for like the 5th time in the last several years, and I think it is really annoying.   Is there an app that can reliably map one key to another?  By reliably I mean that key mapping works with Shift, Alt, and other modifiers.  UPDATE  Windows 7, Samsung Chronos 7 How can a single slit diffraction produce an interference pattern? How can a light passed though a single slit produce a similar interference pattern to the double-slit experiment? How does the diffracted wave produce the points of cancellation and reinforcement, if there is only one wave? Optimum Bone To Water Ratio For Pork and Beef Stocks I am tinkering with my stock recipes.   For pork stock I have been using 8 cups of water over a roasted trotter, a roasted backbone section with about 4 inches of rib attached, and a 1/4 inch slab of roasted pork belly.   For the beef stock I have been using 8 cups of water over an equivalent amount of roasted beef bones (knuckles and backbone/rib).   This gives a very flavorful stock and, for cost reasons, I want to determine how much I can reduce the concentration (by adding more water) without reaching too watery a taste.   Does anybody have any guidance on this topic? Rolling back a completely changed question was originally asked August 9, and received answers. A month later, the OP  the question, invalidating the existing answers. I rolled it back, and left a comment to say that a new question should be opened, but the OP changed it back saying "There is no rule about it, so you can't edit my post."  There is also a bounty on this question, making things more interesting.  What are the guidelines on completely changing a question or rolling back changed questions? Was I out-of-line rolling back the question?  I have no desire to get into an edit war, so I'm not going to touch the question again. If a moderator wants to get involved, great. Same as title, want to kill alt-tab, etc. Is a visa to Poland required for a Russian spouse of a Polish citizen? I am a holder of a Russian passport and my husband is a Polish citizen. We both live and work in the UK. I have received my family member of EEA national card, good for 5 years. We would like to travel to Poland together. On the website of the Polish embassy it clearly states that if we are traveling together, I do not require a visa, however in the embassy they were sure that I do need a visa. Could anyone please clarify? List of Ubuntu Versions with Corresponding Linux Kernel Version I was trying to do some of these questions to check my understanding about the topic, but I'm not sure if they're correct. Here are my answers.   1) Suppose $f$ is continuous on $[0,1]$. Must there be a nondegenerate closed subinterval $[a,b]$ of $[0,1]$ for which the restriction of $f$ to $[a,b]$ is of bounded variation?   No, because $f(x)$ might be a constant function. In this case, $f(x)$ will not be the difference of two increasing functions...and so will not be of bounded variation.  2) Let $f$ be the Dirichlet function, the characteristic function of the rationals in $[0,1]$. Is $f$ of bounded variation on $[0,1]$?   No, because we cannot express it as the difference of two increasing functions.  3) Let $f$ be a step function on $[a,b]$. Find a formula for its total variation.  If we partition $[a,b]$ in such a way that for each $[x_{i-1}, x_i]$ (which is part of the partition), $x_{i-1}$ and $x_i$ each correspond to the midpoint of a step. I know this is not a formal answer, but I'm just trying to check my understanding. iOS 11-13 - unable to paste into comments I’m able to copy-paste from any application to any application. I’m able to copy from a comment or from a question or from an answer. I’m able to paste to a question or answer. However, if I attempt to paste into a comment, nothing happens. I am able to subsequently paste into another application, confirming that the text is actually on the clipboard.   However, copying SE links will paste them successfully, but all other text - including other links - still fails. This leads me to believe that it’s a SE issue and not an Apple one.   This has been an issue since 11.0 beta and persists through iOS 13 release. If $(a,b)=1$ then prove $(a+b, ab)=1$. Let $a$ and $b$ be two integers such that $\left(a,b\right) = 1$. Prove that $\left(a+b, ab\right) = 1$.   $(a,b)=1$ means $a$ and $b$ have no prime factors in common  $ab$ is simply the product of factors of $a$ and factors of $b$.  Let's say $k\mid a+b$ where $k$ is some factor of $a$.  Then $ka=a+b$ and $ka-a=b$ and $a(k-l)=b$.  So $a(k-l)=b, \  a\mid a(k-1)$ [$a$ divides the left hand side] therefore $a\mid b$ [the right hand side].  But $(a,b)=1$ so $a$ cannot divide $b$.  We have a similar argument for $b$.  So $a+b$ is not divisible by any factors of $ab$.  Therefore, $(a+b, ab)=1$.  Would this be correct? Am I missing anything? How can a function with a hole (removable discontinuity) equal a function with no hole? I've done some research, and I'm hoping someone can check me. My question was this:  Assume I have the function $f(x) = \frac{(x-3)(x+2)}{(x-3)}$, so it has removable discontinuity at $x = 3$. We remove that discontinuity with algebra: $f(x) = \frac{(x-3)(x+2)}{(x-3)} = (x+2)$. BUT, the graph of the first function has a hole at $x = 3$, and the graph of the second function is continuous everywhere. How can they be "equal" if one has a hole and the other does not?  I think that this is the answer:   Because the original function is undefined at the point $x = 3$, we have to restrict the domain to $\mathbb{R} \setminus 3$. And when we manipulate that function with algebra, the final result, $f(x) = (x + 2)$ is still using this restricted domain. So even though the function $f(x) = (x+2)$ would not have a hole if the domain were all of $\mathbb{R}$, we are sort of "imposing" a hole at $x = 3$ by continuing to throw that point out of the domain.   And then just to close the loop: Removing the removable discontinuity is useful because it allows us to "pretend" that we're working with a function that is everywhere continuous, which helps us easily find the limit. But the reality is that the function $f(x) = (x +2)$ is actually NOT continuous everywhere when we restrict the domain by throwing out the point 3. Or am I now taking things too far?   Thanks in advance!  EDIT: For anyone coming across this in the future, in addition to the excellent answers below, I also found this other question about the  helpful.