MySQL 5.0 and MyISAM

[Viktor Popov]

Hi All,

We have a MySQL server 5.0 / MyISAM.
We use it to store a data base for a site written on PHP. We have
problems with the performance of the MySQL server when we have many
clients in the same time.
Can we use memcached in order to optimize the performance of the system?

Thank you in advance!

Viktor

[Josef Finsel]

Viktor,

In essence, that is what memcached is designed to do. Place it in your data layer to check memcached before going to the database and only going to the database if the data isn't in memcached  and you're in good shape. Depending on how compartmentalized the code for your site is, it may be easy to implement for the entire site or you may have to pick and choose the most painful (read expensive) database calls and cache them to begin with.

Josef

"If you see a whole thing - it seems that it's always beautiful. Planets, lives... But up close a world's all dirt and rocks. And day to day, life's a hard job, you get tired, you lose the pattern."
Ursula K. Le Guin

On Tue, Jul 1, 2008 at 12:39 PM, Viktor Popov <vpopov@...> wrote:

Hi All,

We have a MySQL server 5.0 / MyISAM.
We use it to store a data base for a site written on PHP. We have problems with the performance of the MySQL server when we have many clients in the same time.
Can we use memcached in order to optimize the performance of the system?

Thank you in advance!

Viktor

[Perrin Harkins]

On Tue, Jul 1, 2008 at 12:39 PM, Viktor Popov <vpopov@...> wrote:
> We have a MySQL server 5.0 / MyISAM.
> We use it to store a data base for a site written on PHP. We have problems
> with the performance of the MySQL server when we have many clients in the
> same time.
> Can we use memcached in order to optimize the performance of the system?\

Try switching to InnoDB first.  If what you have is locking problems
from concurrent writers, memcached is unlikely to help but InnoDB
will.

- Perrin