0
votes
1answer
52 views

Is enabling MySQL query_cache_size Innodb Lock Safe?

The query_cache_size looks like the kind of setting that one would usually want enabled which puzzled me since it defaults to 0. Then I read the following about the query_cache_wlock_invalidate ...
0
votes
1answer
52 views

Nginx cache entire site while performing MySQL maintenance

I currently have a high traffic WordPress site that is entirely static. But it currently generates each page via the MySQL database anyway (I know I should be caching content). I will be moving the ...
1
vote
2answers
254 views

MySQL query caching - what happens if Server runs out of RAM?

so I have enabled query caching on my server but now from the 8 GB RAM there is almost non left! CPU is around 3% ! Now what happens when there is no more RAM left? Will this just increase CPU load? ...
0
votes
1answer
51 views

Scalable server configuration for dynamic growing social site [closed]

My team is writing (social) website, witch should in theory grow up very fast. My task is to attempt to define the hardware requirements for such a page (for investors). Technology in which we create ...
4
votes
2answers
2k views

Optimizing MySQL for small VPS

I'm trying to optimize my MySQL config for a verrry small VPS. The VPS is also running NGINX/PHP-FPM and Magento; all with a limit of 250MB of RAM. This is an output of MySQL Tuner... -------- ...
0
votes
1answer
123 views

Which is faster, key_cache or OS cache?

In a tb with 1 mil. rows if I do (after I restart the computer - so nothing it's cached): 1. SELECT price,city,state FROM tb1 WHERE zipId=13458; the result is 23rows in 0.270s after I run 'LOAD ...
2
votes
4answers
116 views

MySQL Server : Most Frequent Requests

I would like to know if there is anyway I can display the most frequent sql requests onmy mysql server in order to memcache it. 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 ...