Category Archives: Linux

This is where all my linux pages will live.

MySQL bin logs

To create bin-logs enable log-bin, set that to a directory (/var/lib/mysql) Restart mysql To read them out: mysqlbinlog /var/lib/mysql/bin-log.000001 > /root/textform

Posted in Linux, MySQL | Comments Off on MySQL bin logs

Sed

To replace all instances of search with replace throughout the file called filename: “sed -i -e s/search/replace/g filename” to edit one in place “cat filename | sed s/search/replace/g > /tmp/tmpfile ; mv /tmp/tmpfile filename”

Posted in Linux | Comments Off on Sed

How to Index For Joins in MySQL

http://hackmysql.com/case

Posted in Linux, MySQL | Comments Off on How to Index For Joins in MySQL

Keepalives

Using Apache keepalives on your server can reduces CPU usage since it allows the same connection to be used for images, stylesheets, javascript, etc. If KeepAlive is disabled a separate connection must be made for each of those files. Creating … Continue reading

Posted in Linux | Comments Off on Keepalives

Fixing 503 Service Unavailable error

Cause of 503 Service Unavailable Errors The 503 Service Unavailable error is an HTTP status code that means the web site’s server is simply not available right now. Most of the time this is because the server is too busy … Continue reading

Posted in Linux | Comments Off on Fixing 503 Service Unavailable error

Troubleshooting a site that is slow

When you are trying to troubleshoot a site and see that, from a host perspective, nothing is overloaded or in trouble. Run: lsof -ni | grep httpd | wc -l If that number is the same as (or about the … Continue reading

Posted in Linux | Comments Off on Troubleshooting a site that is slow

chkconfig or update-rc.d

TO ensure that a service does not start at reboot, use the following tools: chkconfig servicename off or ubuntu: update-rc.d servicename disable

Posted in Linux | Comments Off on chkconfig or update-rc.d

Changing a user’s default group

Pick the appropriate one for your operating system: usermod -g www-data -G username username usermod -g apache -G username username

Posted in Linux | Comments Off on Changing a user’s default group

Tomcat stuff

How to connect apache and tomcat mod_proxy_ajp is an Apache module which can be used to forward a client HTTP request to an internal Tomcat application server using the AJP protocol. Make sure this line is in the httpd.conf: LoadModule … Continue reading

Posted in Linux | Comments Off on Tomcat stuff

Making files only executable locally

Add the following to your .htaccess file to prevent files from being accessible from external sites: Order deny,allow Deny from all Allow from localhost 127.0.0.0/8 ::1 externalIP/32

Posted in Linux | Comments Off on Making files only executable locally