… examining MySQL configuration, we quite often want to know how various buffer sizes are used. This matters because some buffers (sort_buffer_size for …needed (key_buffer_size). There are many examples of this. What about join_buffer_size? I saw a my.cnf with a 128M join_buffer_size the other day…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool…-use-sys-stats-table innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log… partition=ON port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT…
Comment: MySQL: what read_buffer_size value is optimal ?
September 21, 2008 By 25 Comments
… my my.cnf: key_buffer_size = 256M sort_buffer_size = 128K read_buffer_size = 128K read_rnd_buffer_size = 128K join_buffer_size = 128K myisam_sort_buffer_size = 128K and restarted the mysql process, the result when running “SHOW VARIABLES LIKE ‘%buffer…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: I tested MySQL…join_buffer_size=1M max_allowed_packet=1M max_connections=3000 max_heap_table_size=64M max_prepared_stmt_count=1000000 query_cache_size…
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
…. Here is our my.cnf: skip-name-resolve max_connections = 2000 skip-innodb log-bin = /usr/mysql/logs/mysql-bin.log binlog-do…_size = 64 query_cache_limit = 0 #query_cache_size = 64M query_cache_size = 0 query_cache_type = 0 join_buffer_size = 512K log_slow_queries = /usr/mysql/logs/mysql-slow.log
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…buffer pool contents. mysql [localhost] {msandbox} (information_schema) > select concat_ws(‘.’, t.schema, t.name, i.name) as index_name, sum(data_size…size_mb from innodb_sys_tables as t inner join innodb_sys_indexes as i using(table_id) inner join innodb_buffer…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
….cnf…join_buffer=10M max_heap_table_size=50M tmp_table_size=64M max_allowed_packet=16M table_cache=1800 record_buffer=10M sort_buffer_size=24M read_buffer_size…buffer_size=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries=/var/log/mysql…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…buffer-size=4 -m64 -mtune=generic’ ‘CXXFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector –param=ssp-buffer-size…mysql-5.0.51a/ mysql-5.0.51a/bdb/ mysql-5.0.51a/bdb/Makefile.in mysql-5.0.51a/bdb/btree/ mysql…it in my.cnf file, the …, full_scan, full_join, tmp_table, tmp_…
