…extending the VARCHAR column to trigger table rebuilds without affecting the table size. mysql> SET expand_fast_index_creation=…tmp table | 19.805849 | | restoring secondary keys | 53.885502 | . . . +——————————+———–+ 19 rows in set (0.00 sec) So, as expected, a small buffer…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…Processor 1TB – Disk My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/…_size = 65536 read_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…table will perform complex operations such as full table scans, sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock… on its own we have the primary key of the table fit completely in the buffer pool. However when mysqldump is ran concurrently…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…key_buffer_size Key Buffer used to buffer Index blocks (row data is not cached). Used only for MyISAM tables. If you do not use MyISAM tables…. tmp_table_size This variable specifies maximum size implicit temporary table (created during query execution automatically) will grow as MEMORY table before …
Comment: What to tune in MySQL Server after installation
October 6, 2006 By 118 Comments
… – except my tmp_table_size. I’ve got 110mb assigned to it and still 50% or more of the tmp tables created are … = 300 key_buffer = 16M myisam_sort_buffer_size = 16M read_rnd_buffer_size = 1M join_buffer_size = 2M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 1000 thread_cache_size = …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…have configured MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of …Tables MEMORY tables can take memory. There are implicit MEMORY tables which are allocated for query execution, which size can be controlled by tmp_table_size…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…InnoDB buffer …tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size…tables, running mk-duplicate-key…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…key_buffer = 256M key_buffer_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
May 17, 2006 By 21 Comments
… tmpdir = /tmp skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size…
