Re: MySQL on an SMP system - exploiting it

On Sunday, May 21, 2017 at 7:56:18 PM UTC+5:30, John Levine wrote:
> In article <59219546$0$821$e4fe514c_at_news.xs4all.nl>,
> Luuk <luuk_at_invalid.lan> wrote:
> >So, installing more RAM and an SSD wil make MySQL use both processors?
>
> Well, since you asked, all you have to do is to restructure your
> applications to make at least two queries in parallel at all times.
> The more the better.

Well - if the website gets 2 hits, and MySQL is busy serving hit no. 1 on the first chip, how do I make sure that hit no. 2 will get served by the second chip? Or, also, maybe the second core on the *same* chip? Received on Mon May 22 2017 - 18:55:52 CEST