… used a 10GB key buffer. I used ALTER TABLE DISABLE KEYS and built the keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt…=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to prevent assorted security…
Comment: MySQL: what read_buffer_size value is optimal ?
September 21, 2008 By 25 Comments
… the buffers to 128 kbyte? I put this in 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… regarding to the my.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_size 131072 The key_buff shows the…
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…-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-error=/var/log/mysqld-innodb.log max-allowed-packet=1M net-buffer…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…insert throughput as in this benchmark. Could you post the my.cnf file used and the computer hardware specs that produced …sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=185M key_buffer_size=157M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K…
Comment: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… acces my web, this server become very very slow. i have about 400 user active. here of my.cnf setting :…rehash [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…. Hardware: 32 GB – RAM 12 Core Processor 1TB – Disk My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock …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…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… this is a predominantly SELECTed table, I went for MYISAM. My my.cnf variables were as follows on a 4GB RAM system, Red…_cache_size=60 key_buffer=750M 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…
Comment: What to tune in MySQL Server after installation
December 7, 2006 By 118 Comments
… GB ram All servers are on same gig network. All my tables are MyIsam. Following is out of mytop MySQL on…: 0.0 Threads: 37 ( 34/ 2) 01/00/00/00 Key Efficiency: 100.0% Bps in/out: 0.0/ 0.5…. My.cnf key_buffer = 4096M max_allowed_packet = 32M table_cache = 812 sort_buffer_size = 1024M read_buffer_size = 512M myisam_sort_buffer_size = 1024M thread_cache = 16 query_cache_size…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…. Raise the key_buffer_size until, when the buffer is full, Key_reads/Uptime reduces to a number you’re comfortable with. Set key_buffer_size really big… authoritative — the “key cache hit ratio.” This is a shame. When you are new to MySQL, trying to configure my.cnf, and you…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… corresponding buffers are allocated only as big as 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…
