Fixed (using the Debian settings)!!! Thanks! On Tue, Nov 11, 2014 at 2:45 PM, <[email protected]> wrote:
> 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 >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
