…buffer_size=32M innodb_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_size…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… I’ve discovered even read_buffer_size selection may be less than obvious. What do we generally hear about read_buffer_size tuning ? If you want… set this variable to some high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default… performanceread_buffer_sizeTime (sec)820045.216K44.832K45.664K43.4128K43.0256K51.9512K60.82M65.28M66.832M67.2 8200 bytes is the minimum size for read_buffer_size…
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 = 128K… the rows 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…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this… open_files_limit = 9216 tmp_table_size=1000M sort_buffer_size = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length_for_sort_data…
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…=0 partition=ON port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… /etc/my.cnf,i add wsrep_cluster_address=gcomm:// to fill it ,the mysql server will not running [root@mysql1 ~]# vi /etc/my.cnf… reporting any bugs at http://bugs.percona.com/ key_buffer_size=0 read_buffer_size=131072 max_used_connections=0 max_threads=151 thread_count… It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 329809 K bytes of memory Hope that…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
… 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: 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…buffer_size = 8M read_buffer_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: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
…:41 2.2 706m 172m 4764 S mysqld Below is my.cnf configuration file [mysqld] datadir=/var/lib/mysql socket=/var/lib… table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M log_queries_not…
Comment: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…many user acces my web, this server become very very slow. i have about 400 user active. here of my.cnf setting : […table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 8…
