26.06.2013 18:08, Roberto Spadim пишет:
Nice, in this case, should be nice implement a cache server, and mysql
servers will send cache to it? something like:
5 mysql clients (no cache here) - 10 mysql servers (100mb of cache
each) - 2 cache servers (16gb of cache each)
we could use
25.06.2013 16:58, Roberto Spadim пишет:
it's a memory in client side with query_parameters (sql_mode, query text,
schema used, and others flags that change results) + query_results
example in php
$query_cache= array(
sql_mode=12341234124124;SELECT * from query_Table = array(
Nice, in this case, should be nice implement a cache server, and mysql
servers will send cache to it? something like:
5 mysql clients (no cache here) - 10 mysql servers (100mb of cache
each) - 2 cache servers (16gb of cache each)
we could use local cache + remote cache, for example, with
it's a memory in client side with query_parameters (sql_mode, query text,
schema used, and others flags that change results) + query_results
example in php
$query_cache= array(
sql_mode=12341234124124;SELECT * from query_Table = array(
tables_used=array(query_Table),
guys, i sent some (many) MDEV issues to have a better control over query
cache
i want to comment here to don't stay with this idea in my mind only...
i created some labels in JIRA:
querycache - relative to query cache
qc_info - relative to qc_info plugin
querycache_client - relative to implement
5 matches
Mail list logo