Top-Aktivitäten
Sehen Sie hier, wer zu den aktivsten Mitgliedern der letzten Woche zählt:
Top-Mitglieder
Sponsored Links
query_cache_limit | 1048576 | query_cache_size | 0 | query_cache_type | ON mysql> set global query_cache_size = 10000000;mysql> show variables like 'query_cache_size';mysql> FLUSH QUERY CACHE; mysql> RESET QUERY CACHE;mysql> SHOW STATUS; Qcache queries in cache 2 Qcache inserts 3888 Qcache hits 1797 Qcache lowmem prunes 3376 Qcache not cached 185 Qcache free memory 924784 Qcache free blocks 9 Qcache total blocks 24 
mysql>SHOW VARIABLES LIKE 'have_query_cache'mysql> SHOW STATUS LIKE 'Qcache%'; +-------------------------+--------+ | Variable_name | Value | +-------------------------+--------+ | Qcache_free_blocks | 36 | | Qcache_free_memory | 138488 | | Qcache_hits | 79570 | | Qcache_inserts | 27087 | | Qcache_lowmem_prunes | 3114 | | Qcache_not_cached | 22989 | | Qcache_queries_in_cache | 415 | | Qcache_total_blocks | 912 | +-------------------------+--------+
query_cache_limit = 16M query_cache_size = 128M query_cache_type = 1 query_cache_limit = max. Größe für einen einzelnen Query Aufruf, der in den Cache aufgenommen wird. query_cache_size = Wie viel Speicher der gesamte Query-Cache belegen darf query_cache_type = Query-Cache ein (1) der (0) ausschalten (2 per SQL aktivieren (SQL_CACHE) /deaktivieren (SQL_NO_CACHE) )
query_cache_limit = 16M query_cache_size = 128M query_cache_type = 1 

[client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer=256M max_allowed_packet = 16M sort_buffer_size =5M table_cache = 4000 set-variable= max_connections=400 join_buffer_size=1M key_buffer_size=64M net_buffer_length = 8K read_buffer_size = 512K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M lower_case_table_names = 1 character_set_server = utf8 query_cache_limit = 3M query_cache_size = 50M query_cache_type = 1 query_prealloc_size = 163840 query_alloc_block_size = 32768 query_cache_min_res_unit=9K tmp_table_size=64M low_priority_updates=1 server-id = 1 innodb_data_file_path = ibdata1:1300M:autoextend:max:3500M innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ innodb_buffer_pool_size = 1300M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 5M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 wait_timeout=60 connect_timeout=10 interactive_timeout=120 thread_cache_size=256 thread_concurrency=2 thread_stack=128K sql-mode=NO_BACKSLASH_ESCAPES [safe_mysqld] err-log=/var/lib/mysql/mysqld.log [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout