Displaying 3 results from an estimated 3 matches for "read_buffer_size".
2013 Nov 11
1
Tuning MySQL - what's the best place for mysqld parameters?
...e_installation on
a CentOS 6.4 machine with mucho RAM (32 GB)
and I wonder, what would be the best place
for the mysqld parameters descibed at
http://dev.mysql.com/doc/refman/5.1/en/server-parameters.html
mysqld_safe --key_buffer_size=64M --table_open_cache=256 \
--sort_buffer_size=4M --read_buffer_size=1M &
Should I just edit the file /etc/init.d/mysqld or is
there a better place in CentOS for that (under sysconfig?)
Thanks
Alex
2009 Oct 21
4
Concurrent calls including mysql taking lot of time for execution
...ion=1000
wait_timeout=60
query_cache_type=1
query_cache_limit=4M
query_cache_size=512M
interactive_timeout=120
connect_timeout=80
table_cache=1024
thread_concurrency=8
long_query_time=10
tmp_table_size=64M
join_buffer_size=1M
thread_cache_size=200
key_buffer=32M
table_cache=1024
sort_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size=4M
And I am running on asterisk 1.4.22.1, Quadcore processor 2.4Ghz, 4GB RAM,
mysql 5.0. Some times we get dead air even after 50-100 calls. Is there any
other additional parameters or variables or resources (hardware) to be
looked into to increase the speed of mysql connec...
2009 Apr 15
3
MySQL On ZFS Performance(fsync) Problem?
...a3/binlog/mysql-bin
sync_binlog=1
#log warnings
log_warnings
#******************************* Replication related settings
**********************
#master
server-id = 3
binlog_format=mixed
#******************************* MyISAM Specific options
****************************
key_buffer_size = 32M
read_buffer_size = 8M
read_rnd_buffer_size = 2M
bulk_insert_buffer_size = 16M
myisam_sort_buffer_size = 64M
myisam_max_sort_file_size = 10G
myisam_max_extra_sort_file_size = 10G
myisam_repair_threads = 1
myisam_recover
# ***************************** INNODB Specific options
****************************
innodb_file...