… KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G…_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
When examining MySQL configuration, we quite often want to know how various buffer sizes are used. This matters because some buffers (sort_buffer_size… (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 and needed to research this quickly before I gave advice. The join buffer is…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are…deal with simple and complicated queries efficiently automatically. join_buffer_size = 256k The default is now double of… also promises updated sample my.cnf and getting rid of old my-huge.cnf which are great. …
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-instances=2 innodb-buffer-pool-size…-use-sys-stats-table innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… ‘joiner’ ’10.195.206.117′ ” ‘/var/lib/mysql/’ ‘/etc/my.cnf‘ ’20758′ 2>sst.err’ 120619 13:20:….0M 120619 13:21:17 InnoDB: Completed initialization of buffer pool 120619 13:21:18 InnoDB: highest supported… group. 120619 13:21:19 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 105) 120619 13:21:20 [Note] …
Comment: MySQL: what read_buffer_size value is optimal ?
September 21, 2008 By 25 Comments
…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….cnf): key_buffer_size 268435456 sort_buffer_size 131064 read_buffer_size 126976 read_rnd_buffer_size 126976 join_buffer_size 126976 myisam_sort_buffer…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql…_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb…_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock run [root@localhost msb_ps_5_5_15]# time mysqldump –defaults-file=my.sandbox.cnf…look at the buffer pool contents. mysql [localhost] {msandbox} (information_schema)…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 141 Comments
… table, I went for MYISAM. My my.cnf variables were as follows on a 4GB RAM…buffer=750M join_buffer=10M max_heap_table_size=50M tmp_table_size=64M max_allowed_packet=16M table_cache=1800 record_buffer…max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…bits physical, 48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-… additional scalability fixes for buffer_pool (split_buffer_pool_mutex patch). my.cnf is [mysqld] user=root …io_threads = 16 innodb_read_io_threads = 16 join_buffer_size=1M max_allowed_packet=1M max_…
