This is not a question about capacity planning, its about mysql performance over local network vs on the same virtual machine (where it needs to share cpu with other processes)  I have a wordpress+woocommerce site hosted on a VPS with 2 cores, 4gb of ram and local nvme storage, configured with ubuntu 18.04, nginx, php7.3 and percona mysql 8. Hosted on Hetzner in Germany.  Lately traffic on my site grew and so did my cpu usage. mainly by mysql ( roughly 2/3 of the cpu is used by mysql and the other 1/3 by php-fpm). Sometimes when i have many people visiting my site at the same time it takes a lot of time to load because my cpu is at 100% for many seconds    I'm now facing a decision to make: buy another VPS like this and move mysql onto it or upgrade this VPS and double its specs?   Either way it will cost me the same, certainly having 2 separate machines means disaster recovery would be easier/faster, if one of the servers crashes I would have to recover only half of the services to put the site back online and it could also be easier to setup a load balanced system in future.   But how much will it cost in terms of TTFB having to contact another machine on the private network everytime wordpress needs to query the database?  Or might my load times improve because I'm dedicating 2 cores to php and 2 cores to mysql so they can work more in parallel on the same request with less queueing?  My priority is to make my site's TTFB as short as possible, without php cache because I can't use it for technical reasons right now.
This is a  about  Related:      I have a question regarding capacity planning. Can the Server Fault community please help with the following:   What kind of server do I need to handle some number of users? How many users can a server with some specifications handle? Will some server configuration be fast enough for my use case? I'm building a social networking site: what kind of hardware do I need? How much bandwidth do I need for some project? How much bandwidth will some number of users use in some application?
Prove $\int_0^{\infty}\! \frac{\mathbb{d}x}{1+x^n}=\frac{\pi}{n \sin\frac{\pi}{n}}$ using real analysis techniques only Let $f$ be an entire function such that $\mid f(z) \mid \leq A \mid z \mid$ for all $z$, where $A$ is a fixed number. Show that $f(z)=a_1z$, where $a_1$ is a complex constant. On thanksgiving day a woman posted in a facebook group that her father had just passed away (left her money) and in good deed because it was thanksgiving she was offering to pay people’s debts. Well I inboxed her and she pretty much wants me to open up a bank account with First Tech Credit Union and give her my log in and password info. Ofcourse its sketchy!   So I questioned her and asked why she wanted that instead of her sending me the money directly from her bank to mine. She then responded because she wants to keep records of my debts. (She asked for proof and I sent her screenshots ONLY of my outstanding balances) I heard about the depositing checks scam so I questioned her about how she would deposit the funds and she said cash.  Her facebook page is 100% legit, I screenshotted her pics and family profiles etc. We came to an agreement that I would only accept her help if she sends me a picture of her ID before me sending this info.   She literally just wants to deposit the money to me, She isn’t asking me to send nobody money from that account or anything. Of course the account will be empty when I provide it to her. When she does deposit the money I am planning to immediately change the password and obviously stay watching my account activity while she deposits the funds.   She actually also provided pics of other accounts she funded. My question is, is this a scam? And if so how could she possibly scam me? Specially if i have her information and A pic of her ID. She is a christian lady and looks like she has a good heart, We talked about my struggles and she actually looked into why I needed to be assisted with the money. By no means was she pushy or anything. I want to believe that she just wants to help me but I am also too skeptical. Error while updating debug log trace flag I am trying to update the debug log trace flag for my user but getting the following error     Having an active trace flag triggers debug logging. You have 259 MB of the maximum 250 MB of debug logs. Before you can edit trace flags, delete some debug logs.   I have removed all existing debug logs but it is still throwing the error. My printer does not print light magenta. (Canon MP220 - CL-38) I have a Canon MP 220, with new cartridges. Prints fine everything, but it won't print light magenta. I cleaned it and deep cleaned it many times. I have no idea what could be the problem. Cartridge models: CL-38 and PG-37.  Any ideas ?  LE: Now it won't print magenta at all! Python Argument Binders How can I bind arguments to a Python method to store a nullary functor for later invocation?  Similar to C++'s boost::bind.  For example:  def add(x, y):     return x + y  add_5 = magic_function(add, 5) assert add_5(3) == 8 Render semi-transparent volume with cycles I want to render an image of a fire in cycles, but as a png with a transparent background. Without a transparent background, the output image looks like this:    But as soon as I tick the "Transparent" checkbox under Render->Film, all the semi-transparent parts of the image are not rendered and it looks like this    which is clearly not what I want. I've tried to add a holdout shader or a transparent shader to my smoke domain material nodes, but it didn't help. I've only found answered questions for semi-transparent glass, but none for volumes. My node setup looks like this:    but the transparent shader doesn't do anything.  Has anyone an idea how to fix this?  Thanks  Edit: I've just changed the flow type to "Fire and Smoke" instead of "Fire" and now the semi-transparent parts render too, but I don't want the smoke. Suppose we have two twins travelling away from each other, each twin moving at some speed $v$:    Twin $A$ observes twin $B$’s time to be dilated so his clock runs faster than twin $B$’s clock. But twin $B$ observes twin $A$’s time to be dilated so his clock runs faster than twin $A$’s clock. Each twin thinks their clock is running faster. How can this be? Isn’t this a paradox? How to add border to listview and different row colors at the same time I know of 2 basic kinds of default web icons for websites:   : place an .ico formatted file at the root of your site named favicon.ico and most desktop browsers will find it and display it in various contexts (bookmarks, tabs). Can also be added in code, which allows you to specify other names and other graphics types to the file, though there are :  &lt;link rel="shortcut icon" href="/favicon.ico" /&gt; &lt;link rel="icon" href="/favicon.ico" /&gt;  : place a png formatted file called either apple-touch-icon.png or apple-touch-icon-precomposed.png at the root of your site and iPhone OS/iOS versions of Safari will pick those up and store them when the site is added to the Home Screen. Can also be added with code like:  &lt;link rel="apple-touch-icon" href="/custom_icon.png" /&gt;    Are there any other default icon graphics for a website a webmaster can include? Angle Constructions Over the numerous math tests I've taken, I have yet to understand what angle can be constructed and what cannot. From my understanding, 30, 45, 60, and 90 degree angles can be constructed. You can then use these angles and subtract or add them to create other angles like 15 or 75. Also, any angle can be bisected. Are there any other basic angle measures that can be constructed like 30, 45, etc.? So 82.5° is an angle measure  that can be constructed because you can add 60+60+45 to get 165 and then bisect it. Sum of $k$-th powers In Triangle, $\sin\frac A2\!+\!\sin\frac B2\!+\!\sin\frac C2\!-\!1\!=\!4\sin\frac{\pi -A}4\sin\frac{\pi -B}4\sin\frac{\pi-C}4$ To prove  $$\sin\frac A 2+\sin\frac B 2+\sin\frac C 2-1=4\sin\frac{\pi -A}4\sin\frac{\pi -B}4\sin\frac{\pi-C}4$$  My approach :   $$ \begin{align} \text{L.H.S.} &amp; = \sin\frac{A}{2}+\sin \frac{B}{2}+\sin\frac{C}{2} -1 \\[8pt] &amp; = 2\sin\frac{A+B}{4}\cos\frac{A-B}{4}+\cos\left(\frac{\pi}{2}-\frac{C}{2}\right)-1 \\[8pt] &amp; = 2\sin\frac{\pi -C }{4}\cos\frac{A-B}{4} - 2\sin^2\left(\frac{\pi -C}{4} \right) \\[8pt] &amp; =2\sin\frac{\pi -C }{4}\left\{ \cos\frac{A-B}{4} - \sin\left(\frac{\pi -C}{4} \right)\right\} \end{align} $$  Unable to move further please help. thanks. I get this error message   NMI watchdog: BUG: soft lockup - CPU#2 stuck for 23s! [plymouthd:305]    on the startup of my system (even with live-cd).  My PC is a dell inspiron 7559 with intel graphic and nvidia.  UPDATE - this issue also happens when attempting to install ubuntu 18.10 using LiveUSB If $x_1,x_2,\ldots,x_n$ are real numbers larger than $1$, prove that $$\dfrac{1}{1+x_1}+\dfrac{1}{1+x_2}+\cdots+\dfrac{1}{1+x_n} \geq \dfrac{n}{\sqrt[n]{x_1x_2\cdots x_n}+1}$$   Attempt  AM-GM doesn't work here since we will get an upper bound. I don't see Cauchy-Schwarz working either. Thus, I think a substitution might work, but I am unsure of which one to use. Editing polygons simultaneously in ArcMap? I have two polygons:    How can I reshape both Polygon 1 and Polygon 2 at the same time?  Will the area of each polygon change automatically in the table after reshaping?  I'm using ArcMap 10.1. Say that we have a secure random number generation that outputs 32 bit random numbers, so it's output is a true random number between 0 and a MAX.  What is the best way to map this random number to a defined range (say I want something random between X and Y) without loosing too much entropy? Best way to randomize an array with .NET One way to prove that there is an infinity of consecutive powerful integers is to just note that there are infinite solutions to the equation $x^2-8y^2=1$, because clearly $x^2$ and $8y^2$ are clearly powerful. But this uses a bit of theory.  I found this problem under an induction worksheet, and all of the surrounding problems are easy. Is there really an elementary solution to the problem?  All of my attempts have been fruitless.  Note: a number is powerful if whenever a prime $p$ divides it we have that $p^2$ also divides it. I'd like to use a sequence of boxes to show how TeX works. I read some time ago that everything (or almost) in TeX are boxes.  So, how to show only the TeX boxes that surround each character, each line, each paragraph?  I'd like something similar to the image below, not fbox which contains blank space around it.