-5
votes
1answer
55 views

Memcached on MySQL Server? [closed]

I just installed memcache with yum on MySQL Server. However when I start the memcache daemon I see no changes in MySQL/Application performance. I think I still need to configure MySQL to work with ...
0
votes
2answers
100 views

Can I use two machines to set up memcache server for a php web app?

I have a web server which hosts my PHP web app and my MySQL server. I would like to throw out one more machine there to use it for memcache/memcached. In order to use Memcache, should I have a ...
-3
votes
3answers
245 views

Does mysql query cache have to be off to use memcached? [closed]

How do you know if memcached is being used? Server has mysql query cache on and I believe it also has memcahced installed, but how do I know if memcached is being used? Thanks!
-1
votes
1answer
378 views

Nginx , Apache , Mysql , Memcache with server 4G ram. How optimize to enought memory?

i have 1 dedicated server with Nginx proxy for Apache. Memcache, mysql, 4G Ram. These day, my visitor on my site wasn't increased, but my server get overload always in some specified time. (9AM - ...
3
votes
3answers
789 views

Copy MySQL to RAM as a poor man's memcached replacement?

What about this idea: I've got a 4GB MySQL database, with few UPDATEs. On system startup I copy it to RAM and run it from there. Every couple of hours or even on UPDATES, I dump it to disk. ...as ...
0
votes
2answers
166 views

Memcached and Mysql architecture

Right now we have 2 servers. webserver + memcached mysql server the mysql server is a new and a strong server and it is not being utilized fully. I was debating if I should migrate the memcached ...
1
vote
3answers
377 views

improve mysql server speed for an app hosted on VPS

I'm running several applications on my VPS. These apps are built with PHP and used in a social network. Currently, I have some problems with the server's speed. My VPS has the following ...
1
vote
1answer
570 views

Will innodb benefit from memcached?

from - http://www.readwriteweb.com/hack/2011/04/you-got-nosql-in-mysql-memcach.php (correct me if does not make sense) potential benefits saving complex query calculation into distributed ...
1
vote
1answer
278 views

How to backup MySQL (mysqldump) when Memcached installed?

The server OS is CentOS, with Memcached installed Before Memcached installed, I use mysqldump -u root -p --lock-tables --add-locks --disable-keys --skip-extended-insert --quick wcraze > ...
1
vote
7answers
4k views

How to deploy web application for 2 million users?

I've been tasked with figuring out how to do a large scale deployment for a high availability, high traffic, dynamic, flash based web application. There is a good possibility that this application can ...
0
votes
2answers
301 views

Can Memcached limit “write per second” and “read per second” on MySQL?

I need to reduce the value of "write per second" and "read per second" on MySQL (this is for statistics: total views of post). Can Memcached doing this job? Thanks
3
votes
1answer
207 views

What is the standard way to deploy memcached?

I have two IIS servers and two MySQL servers. On all servers I have some available memory (More than a GB). What is the standard way to deploy memcached? Should I add a new server especially for ...
1
vote
4answers
643 views

Improving on server configuration

I am trying to improve the performance of a Drupal (6) installation under load. One web server, one db server (MySQL5) both are Single Socket Quad Core Intel Xeon 2.5GHz with 16GB RAM. On the web ...
0
votes
2answers
1k views

Querying a Large Dataset Fast: MySQL MEMORY (HEAP) engine, MyISAM, or something else (e.g. MemCached)

Currently working on a project that is centered around a medical vocabulary known as SNOMED. At the heart of snomed is a (relational) dataset that is 350,000 terms/records in length. We want to be ...