Re: MySQL on an SMP system - exploiting it
From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Mon, 22 May 2017 23:04:04 +0100
Message-ID: <ofvn27$acd$1_at_dont-email.me>
>
> It depends on how your web server works. But this is the mysql group,
> not the web server intro question group.
>
>
>
well actually it depends how mysqld works
Date: Mon, 22 May 2017 23:04:04 +0100
Message-ID: <ofvn27$acd$1_at_dont-email.me>
On 22/05/17 18:59, John Levine wrote:
> In article <e8750643-af20-4042-af0f-85e6d50e664c_at_googlegroups.com>,
> <bit-naughty_at_hotmail.com> wrote:
>>> 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?
>
> It depends on how your web server works. But this is the mysql group,
> not the web server intro question group.
>
>
>
well actually it depends how mysqld works
https://stackoverflow.com/questions/3883178/multithreading-in-mysql
-- "In our post-modern world, climate science is not powerful because it is true: it is true because it is powerful." Lucas BergkampReceived on Tue May 23 2017 - 00:04:04 CEST