categories
Database Management Systems
- MS SQL Server
- MySQL
- Oracle Berkeley DB
Libraries
- Apache Portable Runtime
- Apache Portable Runtime Utility
- Flex
- Freetds
- Libiconv
- Libmcrypt
- Libmhash
- Libpng
- Libxml
- Libxslt
- m4
- Neon (webdav)
- OpenSSL
- zLib
Miscellaneous
- Bison
- Byacc
- UML
- Varnish Cache
Operating Systems
- Linux
- MacOS X
- MS Windows
Servers
- Apache Web Server
- Internet Information Services
- Node.js
- vsftpd FTP Server
Tools
- Development
- Security
Web Development
- AJAX
- Dart
- Javascript
- PHP
- Python
tags cloud
Tutorials
Bundle, validate, compress javascript files
Submitted by Webmaster on Saturday June 20, 2015
Due to a number of javascript files and libraries I had included in my project (and custom code written myself), I realized that I should do something to minimize the number of HTTP requests to server by bundling up source files somehow. I used simple OS shell commands to do so on a Mac OSX but instructions should work fine on Linux (with or without some adjustments)...(Read more)
Category:
Web Development > Javascript > Tips and Tricks
Tags:
Removing lines with strings from text files on Linux/Mac OS X
Submitted by Webmaster on Friday May 01, 2015
I used this technique to remove strings from bash history file containing passwords and other sensitive data on a Mac OS X shell...(Read more)
Category:
Operating Systems > MacOS X > Tips and Tricks
Tags:
How to set innodb_flush_log_at_timeout in MySQL 5.6?
Submitted by Webmaster on Monday September 15, 2014
A setting that isn't used much but could be used more is innodb_flush_log_at_timeout, which controls how often InnoDB does an fsync from the OS buffer to disk. Here's how it interacts with innodb_flush_log_at_trx_commit...(Read more)
Category:
Database Management Systems > MySQL > Administration
Tags:
How to setup quick, passwordless login using SSH?
Submitted by Webmaster on Thursday May 01, 2014
There are two parts to this tutorial. In the first one, I am going to show how to login to a remote server without using a password (when you normally do need a password to login). Secondly, I am also going to show you how to setup SSH on your local machine so that you can use short aliases to connect to remote machines. I have successfully used these techniques on Linux and Mac OS X for the past year or so...(Read more)
Category:
Tools > Security > Tips and Tricks
Tags:
How to setup Spamassasin to run as a deamon?
Submitted by Webmaster on Thursday October 31, 2013
SpamAssasin is perhaps the most powerful spam filter out there and many companies and projects are using it on a regular basis. In this tutorial, I am going to explain you how to run SpamAssasin as a daemon and use spamc program to check for spam in email's content...(Read more)
Category:
Tools > Security > Administration
Tags:
Starting with Git - Setting up remote environment for Git
Submitted by Webmaster on Saturday June 08, 2013
In the tutorial, I will discuss the setup and configuration for remote and local Git repositories using SSH to transfer files between server and client. I used a Linux based server and a Mac OS X client for development but steps should work on similar environments supporting SSH...(Read more)
Category:
Tools > Development > Configuration
Tags:
How to SSH into EC2 instances without identity file and password?
Submitted by Webmaster on Monday May 27, 2013
I had to type in the location and name of my identity file and a long string of username@hostname anytime I'd try to SSH into my Amazon EC2 instance for administration. I found an easy solution that I am sharing with you here...(Read more)
Category:
Operating Systems > MacOS X > Tips and Tricks
Tags:
Is MySQL 5.6 slower than MySQL 5.5? No, it's faster
Submitted by Webmaster on Friday February 22, 2013
MySQL 5.6 is believed to be the best MySQL release ever. In order to find out if it is true or not I ran some benchmarks and I am going to share the results with you in this tutorial. Please note that I only tested with default settings (in both cases) and using sysbench as a benchmarking tool, so its a pretty basic test. I highly recommend that you test on your particular workload before upgrading and share your results...(Read more)
Category:
Database Management Systems > MySQL > Tips and Tricks
Tags:
Download, configure, compile, and install MySQL 5.6
Submitted by Webmaster on Wednesday February 06, 2013
MySQL 5.6 is the latest production-ready release of the most popular opensource database management system on the planet ie. MySQL...(Read more)
Category:
Database Management Systems > MySQL > Installation
Tags:
Fast, parallel restore from SQL dumps (mysqldump) for MySQL
Submitted by Webmaster on Friday June 29, 2012
I have used the technique that I am going to describe below on several occasions to restore from a SQL dump generated using mysqldump. In some cases, the restore that had taken 2 days and still could not finish successfully was completed in 5-6 hours using this simple technique. Please keep in mind that this is not a pure parallel method but I'd say it is almost parallel and have proven to be faster than regular single-threaded restore...(Read more)
Category:
Database Management Systems > MySQL > Tips and Tricks
