Displaying 4 results from an estimated 4 matches for "sort_buffer_size".
2013 Nov 11
1
Tuning MySQL - what's the best place for mysqld parameters?
...n /usr/bin/mysql_secure_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
2007 Mar 18
0
Performance Tuning Mysql and how mongrel is effected
...this has bitten me
a few times with sleeping processess or stale connections. What I have
done in the past was optimize mysql with the following variable
changes (/etc/my.cnf)
wait_timeout=60
connect_timeout=10
interactive_timeout=120
join_buffer_size=1M
query_cache_size=128M
query_cache_limit=2M
sort_buffer_size=8M
key_buffer = 256M
key_buffer_size=64M
...
According to the mongrel docs it says to use 4hrs - assuming you
didn''t edit mysql default settings- but what I am curious to know, is
what most people set this to, those of us who do performance tweak
their mysql servers. Also, if there is an...
2009 Oct 21
4
Concurrent calls including mysql taking lot of time for execution
...my.cnf:
max_connection=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 s...
2009 Apr 15
3
MySQL On ZFS Performance(fsync) Problem?
...3/tmpdir
skip-locking
skip-name-resolve
back_log=100
interactive_timeout=172800
default-storage-engine = INNODB
default-character-set = utf8
max_connections = 500
max_connect_errors=100000
max_allowed_packet = 4M
max_heap_table_size = 1024M
max_length_for_sort_data = 4096
net_buffer_length = 8K
sort_buffer_size = 8M
join_buffer_size = 16M
#if lock memory
#memlock
table_cache = 1024
thread_cache_size = 512
thread_concurrency = 8
query_cache_type=0
#memory table max size
tmp_table_size = 128M
#******************************* Logs related settings
***************************
log-error=/usr/local/mysql/...