1
vote
1answer
99 views

Query cache for MariaDB Galera cluster

I've read from multiple sources now that you can't have query caches with Galera, but my current application could really benefit from a query cache. I'm load-balancing this cluster with HAProxy and ...
0
votes
1answer
175 views

Cent OS - MySQL Daemon failed to start [closed]

I'm running AWS micro instance with 0.615 GB Memory. I have APC running on it with 35 MB size max as default. Now I have restarted mysqld and it wont start. It has just stopped. I really need to get ...
2
votes
1answer
2k views

Open table cache in MySQL

I have my open table cache set to 1800 and I have a total of 1112 tables. MySQL Tuning Primer reports that 100% of my table cache is used yet my table cache hit rate is 5%. I understand that this ...
1
vote
3answers
176 views

Is it safe to use up all memory on linux server, not leaving anything for the cache?

I have a CentOS server fully dedicated to MySQL 5.5 (with innodb tables mostly). Server has 32 GB RAM, SSD disks, and avarage memory usage looks like this: So about 25GB is in use and about 6.5GB ...
0
votes
2answers
73 views

Faster caching method

I have a service that provides HTML code which at some point it is not updated anymore. The code is always generated dynamically from a database with 10 million entries so each HTML code page ...
3
votes
2answers
178 views

MySQL caching (innodb_buffer_pool_size vs query_cache_*)

What's the relation between: innodb_buffer_pool_size and query_cache_* Both are use for caching queries but what's the difference? Can I use both? Thank you
2
votes
1answer
938 views

MySQL com_select?

I'm looking to tune my query cache a bit. According to 7.6.3.4. Query Cache Status and Maintenance in the manual: The Com_select value is given by this formula: Qcache_inserts + ...
1
vote
2answers
2k views

MySQL consuming nearly all memory in cache?

I am running a server with 24G of RAM. The only thing running here is a MySQL server configured as Master. When I check the memory via free -m I am getting this: total used ...
1
vote
3answers
4k views

Should I increase MySQL cache?

I tried to run tuningprimer.sh to tweak my mysql settings. I already increased mysql query cache few times to current 2GB but it's still not enough according to test results: > QUERY CACHE Query ...
0
votes
1answer
282 views

Ubuntu buffer cache freezes on sync

I am not that strong in linux / unix so asking for any help on problem I have. I am running site on amazon ec2. I am running apache tomcat mysql on one large instance 8gb of RAM. Database is quite ...
0
votes
2answers
118 views

MySQL remote cache

We have a website whose database is on a separate machine. Both the application server and the database server are relatively underused, but the network link between them is the bottleneck. The MySQL ...
1
vote
1answer
404 views

Magento Full Page Cache & Load Testing

Magento Enterprise 9 Full Page Caching is on Cache depth: 1 (ex. catalog.html?p=1) Current results from JMeter after about 1,000 samples: Throughput: Homepage: 8.5/sec - ~40kb Catalog: 6.1/sec - ...
1
vote
2answers
254 views

Set mysql query cache to never expire

I've googled all over the interwebs but can't find any documentation on this. how do i set my query cache to never expire?
1
vote
2answers
5k views

Why is our MySQL table-opens so large and cache-hit so low?

We're seeing a weird statistic on the number of table-opens. I've appended the mysqltuner dump below. It says we've open 94,000 tables in the past 24 hours. But there's only 15,000 tables total and ...
4
votes
2answers
763 views

MySQL 5.5.9 Query Cache not working when schemas have hyphens (“-”) in their name

I am running MySQL 5.5.9 x86_64 RPM as downloaded from mysql.com. Running on CentOS 5.5 Xen DomU. I have enabled the Query_cache however MySQL NEVER uses it. All of my tables are InnoDB. Why is the ...
3
votes
1answer
322 views

Why is the MySQL query cache disabled by default?

I've a pretty simple question... Why is the MySQL query cache disabled by default? In most packaged versions of MySQL I've come across the defaults values are: query_cache_type = 1 query_cache_size ...
1
vote
1answer
107 views

mysql cache question

is there a such thing as too much cache? i have a 2GB ram server. i run 2-3 sites off the following: [mysqld] set-variable = max_connections=50 log-slow-queries safe-show-database skip-networking ...
2
votes
2answers
135 views

MySQL Query Caching - Watching in MySQL administrator bounces between 0 and 97% hit rate?

My current settings: query_cache_size=20M query_cache_type=1 query_cache_limit=1M Most of the queries return the exact same set of results (about 15 rows) and occur every few seconds. Can anyone ...
0
votes
2answers
57 views

MySQL stop responsing when modify main tables

It's an InnoDB database. The query cache has 1.2GB in size with 300k queries in the cache. Most of the cached queries are related to 3 major tables (260MB data length plus 600MB index length ...
1
vote
1answer
276 views

How does MySQL expires the cache?

Suppose the memory is enough, how does MySQL determine whether to fetch from cache or re-query?
0
votes
1answer
864 views

How to disable MySQL's cache?

So that the same queries will take similar amount of time each time, this is for developing purpose only
0
votes
2answers
322 views

Does MySQL have an option for compressing data in its cache?

This morning I was introduced to the concept of compressing a database cache to allow a bigger cache in a given amount of RAM. I understand Microsoft SQL 2008 offers this functionality. I was ...