I have a DB Server running CentOS 6.4 and MySQL 5.5 from RPMs (not source).  I have dozens of databases but one of them is being hit quite hard with large updates which degrade the performance of other queries.  To alleviate this I would like to replicate one of the databases onto the same server so that the writes can write to the "master" and reads can be done on the "slave". I don't have the luxury of additional hardware.  I have found a lot of guides on the internet describing how to replicate to a different server, and one () describing how to replicate to the same server but it doesn't seem to be geared towards retrofitting this functionality to an existing database with 10s of GB of data in it already.  It also talks about compiling MySQL from source.  Does anyone know how I can retrospectively convert my MySQL 5.5 config to replicate one of my databases on the same server?  My existing DB runs on port 3306 so I feel it should be as easy as firing up another instance of MySQL on port 3307 and making some changes to my.cnf but not sure what changes.  Thanks in anticipation.
I have a DB Server running CentOS 6.4 and MySQL 5.5 from RPMs (not source).  I have dozens of databases but one of them is being hit quite hard with large selects which locks out other updates which in turn locks out other selects (at least I think this is what's happening!)  To alleviate this I would like to replicate one of the databases onto the same server so that the writes can write to the "master" and reads can be done on the "slave". I don't have the luxury of additional hardware.  I have found a lot of guides on the internet describing how to replicate to a different server, and one () describing how to replicate to the same server but it doesn't seem to be geared towards retrofitting this functionality to an existing database with 10s of GB of data in it already. It also talks about compiling MySQL from source.  Does anyone know how I can retrospectively convert my MySQL 5.5 config to replicate one of my databases on the same server?  My existing DB runs on port 3306 so I feel it should be as easy as firing up another instance of MySQL on port 3307 and making some changes to my.cnf but not sure what changes.  Thanks in anticipation.
When functions commute under composition Is it okay to have a multi-language deck? I want to buy a few booster pack from a local shop that only gets them in French. Is it generally acceptable to show up to a tournament with cards in different languages? Anti-Cheat for MMOs issues and solutions? Most online games suffer for this problem and there are some  out there to cover this but recently from what I've seen most companies are trying to avoid those programs creating their own system (blizzard with warden, aion with their own checking, etc...) but it is a very difficult case to prevent such ...  Just wanted to say i made another question topic as community wiki specific for posting applications and it is features and the ideas behind this question here is not to list those but instead to know more about what were your attempts, issues along the road and possible solutions, piece of codes if application and so forth.  What sort of protection do you guys use in order to (try to) prevent such acts:   Anti-cheat Software ? (please state which, why and possible problems you faced, for example aion stopped using GameGuard at beta stage due to a huge amount of compatibility problems and complains from their users) Your own code ? (what sort of verification do you usually run to make sure of the bad-faith players, for example speedhack, verify new location against speed+last location, etc...) None, i dont care ? (any personal reason or input you did like to share ?)   Any interesting piece of code related to the issue you would like to post ?  Feel free to rework my text my english inst that great  ?** How to avoid interference in wireless communication? I am working on wireless communication system. We are using around 10 pairs of transmitter and receivers. We are using atmega16 microcontroller for encoding and decoding by USART ports.  Now we are able to transmit the data and receive the same in the receiver end, but there is a major problem, when we are finding the 2 transmitter data coming at the same time. The receiver is unable to get it due to interference.  Suppose one transmitter sends "SENDA" at the meanwhile another transmitter sends "GETTS", at that time the receiver can not receive proper data. As all the transmitters and receivers are working in same frequency, so this interference is occurring. How can I resolve this issue? The set of convergent points of a sequence of continuous functions is Borel Suppose that $f_n$ are continuous.  Prove that $E=\{x\in \mathbb{R}:f_n(x)\text{ is convergent}\}$ is Borel.   My first instinct is to take balls around $\lim_{n\to\infty}f_n(x)$, for each $x$ in $E$, and then show that there has to be some ball small enough so that everything inside that ball is a member of $E$. But this would imply not only that $E$ is Borel, but moreover that it is open, so I don't think that can be right.  Can someone show me how to do this? What's the difference between the apt packages: 'cinnamon' and 'cinnamon-desktop-environment'? I have a fresh Ubuntu install and want to install Cinnamon as the desktop environment. When I do apt search cinnamon, I get multiple results, but two seems like they are the correct one.   The first is just   cinnamon/xenial 2.8.6-1ubuntu1 amd64 all     Innovative and comfortable desktop (Common data files)   while the other is   cinnamon-desktop-environment/xenial,xenial 2.8.0 all     Cinnamon desktop environment - full desktop with extra components   What's the difference between the two? What does the cinnamon-desktop-environment package contain that the cinnamon doesn't? Introductory Calculus textbook for physics? Background image shows in front of 3D objects, not behind them. I've done a quick 3D track in blender and I'm trying to render my output, but the plate I used to track is showing up over my 3d objects.  I want to render the objects in the scene with an alpha channel and comp them over the plate I tracked. My renders however, are covered by the aforementioned plate.  Un-checking "Background Images" in the camera properties (only removes it from the viewport) isn't doing it for my render outputs.  Working on some production tests and am not really proficient with the software yet, my apologies in advance. How do I lock compiled Java classes to prevent decompilation?  I know this must be very well discussed topic on the Internet, but I could not come to any conclusion after referring them.  Many people do suggest obfuscator, but they just do renaming of classes, methods, and fields with tough-to-remember character sequences but what about sensitive constant values?  For example, you have developed the encryption and decryption component based on a password based encryption technique. Now in this case, any average Java person can use  to decompile the class file and easily retrieve the password value (defined as constant) as well as  and in turn can decrypt the data by writing small independent program!  Or should such sensitive components be built in native code (for example, VC++) and call them via ? If you cast Polymorph on a non beast creature then cast Awaken on their beast form how much carries over after polymorph ends?  Polymorph does not give any explicit information on what happens to your statistics when the polymorph ends:     The transformation lasts for the duration, or [drops to 0 hp]. [...] The target's game statistics, including mental ability scores, are replaced by the statistics of the chosen beast.  (Basic Rules, pg. 266)   So this leaves ambiguity when game statistics are altered during polymorph,   The charm effect of Awaken seems pretty clear from the  and reinforced by the specific wording referring to the target as a beast or plant during effects and a creature afterwards:     The awakened beast or plant is charmed by you [longer than polymorph.] When the charmed condition ends, the awakened creature chooses [...] (Basic Rules, pg. 216)   The other two effects of awakening (other than making a plant mobile) are less clear-cut:     The target gains an Intelligence of 10. The target also gains the ability to speak one language you know.  (Basic Rules, pg. 216)   I would guess the modification to intelligence would apply to the beast's stats and therefore end with polymorph.     as being independent of creature statistics and act more as the character's experience. I'd argue the experience of a stranger turning you into a mouse, then gifting you the ability - as a mouse - to speak a language you have never used before would be an experience you couldn't lose I'm not sure if the language and intelligence granted from awakening should remain linked.    These are two examples I can see this having significant impact on my campaign:   Meet an NPC I don't share a language with, Polymorph them then Awaken their beast form so they can speak my language. Can I now communicate with them when they turn back?  If their original intelligence was higher then 10 is it reduced to 10? Say I use find familiar to get an owl (classified as a fey) familiar, then polymorph it to an owl (classified as a beast) so my druid friend can cast Awaken on it, does my familiar keep an intelligence of 10 and/or the ability to speak?   So after reverting from an awoken polymorphed state would you keep the 10 intelligence and a new language, only the new language, or not keep either? Truncated trivariate normal - conditional expectation The  is a proposed propulsion mechanism for spacecraft in which some form of microwave device provides the propulsion. The consensus from the physics community, including many voices on this site, is that the proposed device would violate conservation of momentum.   Several experiments have been conducted, by three main groups: (i) , from Satellite Propulsion Research Ltd, (ii) a research group at the Northwestern Polytechnical University in Xi'an, China, and (iii) Eagleworks Laboratories at NASA's Lyndon B. Johnson Space Center in Houston, Texas. However, few of these experiments have been performed in vacuum (and none of the vacuum tests has been published in a peer-reviewed journal), which means the effect of air currents around the device cannot be ruled out.  This device has been the subject of many questions on this site, including          and their many closed duplicates.  Many of these questions ask what the proposed explanations are, but then veer off into territory of the form "assuming it is true, how does it work?", so they have been (rightfully) closed as counterfactual physics. I feel this sort of bundling does a lot of harm to the discussion, and there is some scope to ask what exactly is being proposed as an explanation. So:     What do the proponents of EmDrive claim is the theoretical justification of the device's function?   Please limit answers exclusively to references, and indicate whether they are peer-reviewed or not. Please limit answers to serious attempts at explanations, as opposed to vague claims about the 'quantum vacuum' - or indicate if an experimental paper does not have any such theoretical explanation or reference.  To be clear, this is not the place to discuss whether the explanations are correct or not. If you have specific questions about any of these sources, ask it separately. (However, if your question starts with "assuming that this works", be prepared for it to be closed.) If you feel there are not enough resources on this thread, you can  but please do not post another question asking people to look for more references. Is there a direct physical interpretation for the complex wavefunction? The Schrödinger equation in non-relativistic quantum mechanics yields the time-evolution of the so-called wavefunction corresponding to the system concerned under the action of the associated Hamiltonian. And this wavefunction is, in general, complex, and its modulus squared yields the probabilities observed experimentally. Though, perhaps, this question has been asked many times, I am wondering if there is a direct physical interpretation - something that physically corresponds to - the wavefunction. Or is it just an intermediate calculational tool to arrive at the appropriate predictions for experimental outcomes, and nothing more? Of course, things like superposition and interference effects follow from the complex nature of the probability amplitude. So there must be something physical about it. What is it? Or are we not supposed to ask that question? Is it because the probability amplitude is complex that we have difficulty in relating it to something physical? Can we do quantum mechanics without complex numbers? Find the last two digits of $3^{45}$ I was wondering if there is a simpler way to find the last to digits of a power such as $3^{45}$. I reduced it modulo 100 to get the answer, which is 43. But I was curious if there was a simpler, or more eloquent way to get this result.  Here's my method:  Using the fact that $3^4=81\equiv -19 \pmod{100}$ and $19^5=2,476,099\equiv -1 \pmod{100}$  $$ 3^{45}\equiv 3(3^4)^{11}\equiv 3(-19)^{11}\equiv 3(-19)(19^5)^2\equiv 3(-19)(-1)^2 \equiv -57 \equiv 43 \pmod {100} $$  I just felt like this was sort of a messy way to find out that the last two digits are 43. If $a,b$ are positive integers such that $\gcd(a,b)=1$, then show that $\gcd(a+b, a-b)=1$ or $2$. and $\gcd(a^2+b^2, a^2-b^2)=1$ or $2 $ I have asked this question before  The first guy solved it in a way, but  i would like to know is there any efficient way to do so, because i did the same for N = 13 and N = 15  which took long time.  This problem is from a pen and paper test, ZIO-2018 Can i solve it with an efficient algorithm, well i am pretty beginner in algos, so if there is one kindly descibe it how can i do so?  Thank you I have a manuscript that is under review in a major journal which is a main result out of a few recent years of my research. When applying for faculty positions, I would like to send the draft as a part of my writing sample. But since the material is not yet published, I am not sure if it is a good idea.  What are the foreseeable disadvantages of sending an article in review to the faculty search committee?  My area is neuroscience / biomedical engineering.  Update: The paper got into a high-profile journal, and I got a job at a different place which did not require a writing sample. Term or phrase describing action occuring when not watching Getting ssh to execute a command in the background on target machine This is a follow-on question to the  question.  If I want to execute a command on the remote machine that runs in the background on that machine, how do I get the ssh command to return?  When I try to just include the ampersand (&amp;) at the end of the command it just hangs.  The exact form of the command looks like this: ssh user@target &quot;cd /some/directory; program-to-execute &amp;&quot;  Any ideas?  One thing to note is that logins to the target machine always produce a text banner and I have SSH keys set up so no password is required. What does "cpu MHz" field mean in the /proc/cpuinfo of a hyper-threading cpu? The CPU is a i7-3770@3.40GHz. It has 4 cores and each core has 2 threads. Here is the dmidecode output:  # dmidecode -t 4 # dmidecode 2.9 SMBIOS 2.7 present.  Handle 0x0042, DMI type 4, 42 bytes Processor Information     Socket Designation: SOCKET 0     Type: Central Processor     Family: &lt;OUT OF SPEC&gt;     Manufacturer: Intel(R) Corporation     ID: A9 06 03 00 FF FB EB BF     Version: Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz     Voltage: 1.1 V     External Clock: 100 MHz     Max Speed: 3800 MHz     Current Speed: 3400 MHz     Status: Populated, Enabled     Upgrade: &lt;OUT OF SPEC&gt;     L1 Cache Handle: 0x003F     L2 Cache Handle: 0x003E     L3 Cache Handle: 0x0040     Serial Number: Not Specified     Asset Tag: Fill By OEM     Part Number: Fill By OEM     Core Count: 4     Core Enabled: 4     Thread Count: 8     Characteristics:         64-bit capable   It will be 8 logic core in a system, like what shows in /proc/cpuinfo. But can any one tell why the cpu MHz of a core is 1600MHz? I guess there is 2 threads in a core, so a hw thread freq may be about the half of the core's? How this number is calculated?  processor   : 7 vendor_id   : GenuineIntel cpu family  : 6 model       : 58 model name  : Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz stepping    : 9 cpu MHz     : 1600.000 cache size  : 8192 KB physical id : 0 siblings    : 8 core id     : 3 cpu cores   : 4 apicid      : 7 initial apicid  : 7 fpu     : yes fpu_exception   : yes cpuid level : 13 wp      : yes flags       : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 x2apic popcnt aes xsave avx lahf_lm ida arat tpr_shadow vnmi flexpriority ept vpid bogomips    : 7013.49 clflush size    : 64 cache_alignment : 64 address sizes   : 36 bits physical, 48 bits virtual power management:   Also, here is the output of lshw and lscpu command. There are also 1600MHz mentioned.   lshw info:  #lshw -class processor   *-cpu                           description: CPU        product: Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz        vendor: Intel Corp.        physical id: 42        bus info: cpu@0        version: Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz        slot: SOCKET 0        size: 1600MHz        capacity: 3800MHz        width: 64 bits        clock: 100MHz        capabilities: fpu fpu_exception wp vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp x86-64 constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 x2apic popcnt aes xsave avx lahf_lm ida arat tpr_shadow vnmi flexpriority ept vpid cpufreq   lscpu info:  #lscpu Architecture:          x86_64 CPU op-mode(s):        32-bit, 64-bit CPU(s):                8 Thread(s) per core:    2 Core(s) per socket:    4 CPU socket(s):         1 NUMA node(s):          1 Vendor ID:             GenuineIntel CPU family:            6 Model:                 58 Stepping:              9 CPU MHz:               1600.000 Virtualization:        VT-x L1d cache:             32K L1i cache:             32K L2 cache:              256K L3 cache:              8192K