… MySQL which of course depends on query size which is controlled by max_allowed_packet. However some MySQL… IO system and wipe off both MySQL and OS caches which can cause other users queries …This is not to mention many Virtual Hosting companies use old MySQL versions which typically have more issues…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…somewhere around of 99% of advice about tuning MySQL‘s key cache hit ratio is wrong, even when you hear…problems with the key buffer hit ratio, and a host of smaller ones. If you make some assumptions …re comfortable with. Set key_buffer_size really big, and then measure its size as it fills up, in …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…’ execution plan (which includes things like whether Query cache was used or not, if Filesort was used, …MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26 # User@Host…is not much considering the fact that tmp_tbl_size variable is set to 32M on the server, …
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…size = 256M myisam_sort_buffer_size = 16M join_buffer_size = 64M read_buffer_size = 16M sort_buffer_size = 8M table_cache = 3600 table_definition_cache = 4096 thread_cache_size…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…Com_show_slave_hosts‘, ’61′ ‘…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…size=32M # Only for MyISAM which isnt used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… already wrote innodb_log_file_size and innodb_buffer_pool_size affect recovery time significantly as… MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are cleaned, so may be OS caches… hundreds of thousands of tables per database host). This one is pretty much part of…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…: Reusing existing ‘/var/lib/mysql//galera.cache‘. 130221 17:59:05 [Note] WSREP: Passing config to GCS: base_host = 192.168.14.150… = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…_file_size=128M innodb_thread_concurrency=0 innodb_extra_rsegments=16 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=2048…-table-size 10000000 –oltp-dist-type uniform –oltp-dist-pct –oltp-dist-res –db-ps-mode auto –mysql-host localhost –mysql-port 3306 –mysql-socket…
Comment: MySQL Query Cache
October 11, 2009 By 70 Comments
….ini) MySQL configuration file with setting the query-cache-type variable to 1. The query-cache-size variable is the size of the query cache in… which won’t be available on shared hosts. More info about query cache is available on techiecorner.com and the MySQL Performance blog. [...]
Post: Limiting InnoDB Data Dictionary
February 11, 2009 By 13 Comments
… with say 100-1000 tables. But for hosting providers and for user oriented applications ( each… http://mysqlperformanceblog.com/files/patches/innodb_dict_size_limit_standalone.patch. Currently patch is on … on MySQL level. We made it by checking MySQL table_cache. If table is placed in table_cache …
