…back_log = 50 + ( max_connections / 5 ) …efficiently automatically. join_buffer_size = 256k…my.cnf and getting rid of old my-huge.cnf which are great. Perhaps my jokes about my-huge my-large etc referring to amounts of memory we have in the phones these days, I made in my Optimizing MySQL…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
…MySQL configuration, we quite often want to know how various buffer sizes are used. This matters because some buffers (sort_buffer_size…size). There are many examples of this. What about join_buffer_size? I saw a my.cnf with a 128M join_buffer_size…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… bit instances. MySQL will fail to start on a micro instance, simply decrease the values in the /etc/my.cnf file if you…,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine…=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max…
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…size = 2M query_prealloc_size = 65536 read_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…a predominantly SELECTed table, I went for MYISAM. My my.cnf variables were as follows on a 4GB RAM…thread_cache_size=60 key_buffer=750M join_buffer=10M max_heap_table_size=50M tmp_table_size=64M max_allowed_…in the application. Just my experience. I know some big websites are using MySQL, but we had …
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…size)/1024/1024 as data_size_mb from innodb_sys_tables as t inner join…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…max_connections was the best proxy we had for expected high connection rates when dynamically configuring it at startup. join_buffer_size…the server defaults but in the default my.cnf file that we ship. It’s …entry/mysql_server_5_6_default . thread_cache_size is quite low, and dynamic based on max_…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…my.cnf is [mysqld] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size…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
… start. Here is our my.cnf: skip-name-resolve max_connections = 2000 skip-innodb log-bin = /usr/mysql/logs/mysql-bin.log binlog-do-db=tp server-id=1 wait_timeout = 15 key_buffer = 16M key_buffer_size = 32M max_allowed… = 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
