Hi Pedro
This should sort your problem, we are adding this on centos and deb
servers to stop the vt Lag
#copy of centos 6 my.cnf /etc/my.cnf
[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
bind-address = 0.0.0.0
innodb_flush_log_at_trx_commit=2
sync_binlog=2
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqldump]
quick
max_allowed_packet=4096
......................................................................................
#debian 7 below my.cnf /etc/mysql/my.cnf
[mysqld]
max_connections=50
join_buffer_size = 2M
tmp_table_size = 24M
max_heap_table_size = 24M
query_cache_size = 256M
key_buffer=256M
key_buffer_size = 1332M
thread_cache_size = 4
table_cache = 500
table_open_cache = 96
innodb_buffer_pool_size = 27M
slow_query_log
local-infile=0
innodb-flush-log-at-trx-commit=2
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
hope this helps
PLease change as desired
Regards
Les
Bigl & Bigl2 International
Zackfm
On 11.11.2014 00:42, Pedro Picoto wrote:
It used to work fast after adding this lines @ my.cnf file after
inserting these two lines:
innodb_flush_log_at_trx_commit=2
sync_binlog=2
I August I even posted a message sharing this solution, wich was based
on a search
I made after someone suggested a similar fix that didn't work.
The problem is that after a fresh instalation I can't get the DB
working as it did.
I not sure where I placed those lines on the my.cnf file when it
worked. I've made so many
placements this time but none of them seem to work.
I have the old 50'' to save a VT, another to Do Over, another to save
a log change, so on, problem back...
Hints?
Thanks.
Side note: after a trip to CentOS appliance CD I got back to Ubuntu.
Ubuntu Studio this time.
CentOS it's not acceptable to my home setup, wich depends on Jack. No
issues with the soundcard.
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
