Archive for November, 2014

Apache Tuning

Posted: 18th November 2014 by Thorben Hemmler in CentOS, Serveradministration

mod_deflate LoadModule deflate_module modules/mod_deflate.so Konfiguration anlegen: /etc/httpd/conf.d/deflate.conf <IfModule mod_deflate.c>  AddOutputFilterByType DEFLATE text/plain  AddOutputFilterByType DEFLATE text/html  AddOutputFilterByType DEFLATE text/xml  AddOutputFilterByType DEFLATE text/css  AddOutputFilterByType DEFLATE text/javascript  AddOutputFilterByType DEFLATE image/svg+xml  AddOutputFilterByType DEFLATE image/x-icon  AddOutputFilterByType DEFLATE application/xml  AddOutputFilterByType DEFLATE application/xhtml+xml  AddOutputFilterByType DEFLATE application/rss+xml  AddOutputFilterByType DEFLATE application/javascript  AddOutputFilterByType DEFLATE application/x-javascript    DeflateCompressionLevel 9   # Browser specific settings  BrowserMatch ^Mozilla/4 […]

Mysql Latin1 auf UTF-8 umstellen

Posted: 3rd November 2014 by Thorben Hemmler in MySQL, Serveradministration

iconv -f iso-8859-1 -t utf8 mysql.sql > mysql-new.sql mysql -u USER -p PASSWORT -h HOST –default-character-set=utf8 DB < mysql-new.sql