|
|
Posted by Rik Wasmus on 01/04/08 11:34
On Fri, 04 Jan 2008 09:34:20 +0100, Gilles Ganault <nospam@nospam.com>
wrote:
> Hello,
>
> I'm no LAMP expert, and a friend of mine is running a site which is a
> bit overloaded. Before upgrading, he'd like to make sure there's no
> easy way to improve efficiency.
>
> A couple of things:
> - MySQL : as much as possible, he keeps query results in RAM, but
> apparently, each is session-specific, which means that results can't
> be shared with other users.
> Is there something that can be done in that area, ie. keep the maximum
> amount of MySQL data in RAM, to avoid users (both logged-on and
> guests) hitting the single MySQL server again and again?
AFAIK, more RAM is not always a good thing for MySQL. I've known setups
where actually reducing RAM usage/cache sizes sped it up tremendously.
It's somewhat out of my expertise though. Consult the MySQL manual, and
possibly ask for advise in comp.databases.mysql.
--
Rik Wasmus
Navigation:
[Reply to this message]
|