Archives
- February 2025
- January 2025
- October 2024
- August 2024
- June 2024
- May 2024
- February 2024
- December 2023
- October 2023
- June 2023
- April 2023
- August 2016
- June 2016
- May 2016
- February 2016
- December 2015
- October 2015
- May 2015
- April 2015
- January 2015
- December 2014
- November 2014
- October 2014
- January 2014
- December 2013
- November 2013
- October 2013
- August 2013
- July 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- April 2012
Categories
Meta
Category Archives: Linux
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
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
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