…size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | MAX_ALLOWED_PACKET | 1048576 | 4194304 | | JOIN_BUFFER_SIZE… now allowing MySQL to handle larger queries. Makes sense as amount of memory available is much larger these days. join_buffer_size have…_batch_size have been increased from 20 to 300 which I guess is one of the component of purging fine tuning in MySQL…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql…size)/1024/1024 as data_size_mb from innodb_sys_tables as t inner join…tuning…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…larger than 16K – is exact size allocated or also segment based allocation…MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent environments. Sets the max…if ORDER and ORDERLINE tables are joined to form a single table),…
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… off tends to be best for well tuned OLTP and web sites using queries …entry/mysql_server_5_6_default . thread_cache_size is quite low, and dynamic based on max_…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…mysql tables in use 1, locked 1 3 lock struct(s), heap size 320 MySQL… will also grow and innodb_max_purge_lag will become your friend. … in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is quite … active database size is smaller than allocated buffer pool size so you can tune it…
