Displaying 6 results from an estimated 6 matches for "query_cache_size".
2011 Oct 11
3
/etc/init.d/mysql =fail mysqld=success
...= /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-external-locking
bind-address = 0.0.0.0
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
query_cache_limit = 1M
query_cache_size = 16M
log_error = /var/log/mysql/error.log
expire_logs_days = 10
max_binlog_size = 100M
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
!includedir /etc/mysql/conf.d/
root@cloneubuntu:/var/log/...
2007 Mar 18
0
Performance Tuning Mysql and how mongrel is effected
...default interactive_timeout to 8hrs (28800) 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 twea...
2009 Oct 21
4
Concurrent calls including mysql taking lot of time for execution
...0-500 simultaneous calls, calls were
going through properly but at around 200-250 calls, mysql (connect ...)
statement was taking at least 5-10 sec to connect to the database. I
optimized all possible parameters in 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....
2015 Mar 12
3
mysql replication - problems
...e = 4
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
;plugin-load=rpl_semi_sync_master=semisync_master.so
;plugin-load=rpl_semi_sync_slave=semisync_slave.so
;rpl_semi_sync_master_enabled=1
;rpl_semi_sync_master_timeout=10
;rpl_semi_sync_slave_enabled=1
;performance_schema
query_cache_size = 8MB
innodb_buffer_pool_size = 199M
general_log_file=/var/log/mysql/mysql.log
general_log=1
log-error=/var/log/mysql/mysql_error_log
log-slow-queries=/var/log/mysql/mysql_slow_log
wait_timeout = 86400
[mysqld_safe]
general_log_file=/var/log/mysql/mysql.log
general_log=1
log-error=/var/log/mysql/m...
2015 Mar 12
0
mysql replication - problems
...r/lib/mysql/mysql.sock
> symbolic-links=0
> ;plugin-load=rpl_semi_sync_master=semisync_master.so
> ;plugin-load=rpl_semi_sync_slave=semisync_slave.so
> ;rpl_semi_sync_master_enabled=1
> ;rpl_semi_sync_master_timeout=10
> ;rpl_semi_sync_slave_enabled=1
> ;performance_schema
> query_cache_size = 8MB
> innodb_buffer_pool_size = 199M
> general_log_file=/var/log/mysql/mysql.log
> general_log=1
> log-error=/var/log/mysql/mysql_error_log
> log-slow-queries=/var/log/mysql/mysql_slow_log
> wait_timeout = 86400
>
> [mysqld_safe]
> general_log_file=/var/log/mysql/mysql....
2015 Mar 12
3
mysql replication - problems
...c-links=0
> > ;plugin-load=rpl_semi_sync_master=semisync_master.so
> > ;plugin-load=rpl_semi_sync_slave=semisync_slave.so
> > ;rpl_semi_sync_master_enabled=1
> > ;rpl_semi_sync_master_timeout=10
> > ;rpl_semi_sync_slave_enabled=1
> > ;performance_schema
> > query_cache_size = 8MB
> > innodb_buffer_pool_size = 199M
> > general_log_file=/var/log/mysql/mysql.log
> > general_log=1
> > log-error=/var/log/mysql/mysql_error_log
> > log-slow-queries=/var/log/mysql/mysql_slow_log
> > wait_timeout = 86400
> >
> > [mysqld_safe]
>...