Tag: log

Decreasing shutdown time of MySQL with large transaction log file

July 15, 2014 / halfgaar

If you need/have a large transaction log file, a shut down can take a while. This post lists how you can force a flush before you do so, decreasing shut down time.

In short:

mysql> set global innodb_max_dirty_pages_pct = 0;

Then monitor the dirty pages:

mysqladmin ext -i10 | grep dirty

Making apache log files world readable

October 1, 2010 / halfgaar

Just chmod the dir, and to make sure rotated files are also readable, change /etc/logrotate.d/apache2. The mask is defined in there.

/var/log/apache2/*.log {
        blablabla
        create 644 root adm
        blablabla
}

Copyleft: These days everything you can think of is copyrighted, patented, protected or otherwise made into someone's imaginary intellectual property. I have a lot of imagination but not enough to pretend that I have some divine right to share things with you without giving you the right to share it further. That would be childish. So, everything here is licensed under a Creative Commons Attribution-Noncommercial-Share Alike license. That means that you can bloody well do anything you like with my content as long as you tell that it's from me (or the respective author). Only if you want to make money from my content do you have to ask me permission first. (As if I could be bothered to sue.) Oh, and you can't redistribute your derivative content under more restrictive terms. Share the love.

Theme by Anders Noren — Up ↑

Tag: log

Decreasing shutdown time of MySQL with large transaction log file

Making apache log files world readable

Categories

Tags/Keywords

Recent Posts

Recent Comments