geeksww tutorials tutorials

How to delete rows in table when PK is referenced in another table

Submitted by Webmaster on May 09, 2016

Before data insertion, updates, deletes etc, database management systems that support foreign keys (like MySQL) make sure you do not introduce any inconsistencies. So, you need to make sure you're not leaving orphan records behind in child tables.

Category:

Database Management Systems > MySQL > Tips and Tricks

Tags:

mysql keys foreign delete insert referential integrity

Unique primary keys(PKs) for MySQL using Redis

Submitted by Webmaster on April 21, 2016

MySQL provides an auto increment feature (AUTO_INCREMENT attribute) that can be used to generate unique identities for new rows/records. However, this may become a problem when you are writing to more than one MySQL databases and merging them, since all of them will be generating their own unique keys.

Category:

Database Management Systems > MySQL > Tips and Tricks

Tags:

mysql administration key unique redis auto-increment incrby

How to rename MySQL DB by moving tables

Submitted by Webmaster on April 21, 2016

RENAME DATABASE statement was removed from MySQL because it was found to be dangerous. However, MySQL still supports the RENAME TABLE command.

Category:

Database Management Systems > MySQL > Administration

Tags:

mysql database administration table rename

How to compile and install Varnish-cache on Linux

Submitted by Webmaster on July 01, 2015

I used Ubuntu 12.04 LTS on Amazon EC2 to download, compile, and install Varnish cache. As of this writing, you can find the latest stable release at https://www.varnish-cache.org/releases

Category:

Miscellaneous > Varnish Cache > Installation

Tags:

linux web http performance optimization installation varnish cache proxy

How to setup node.js/express.js, compass, bootstrap project

Submitted by Webmaster on June 22, 2015

In this tutorial, I will explain how to initialize and configure a Node.js+Express.js, Compass (CSS framework), and Bootstrap (front end UI framework) project. Please note that the tutorial expects all programs already installed and installation instructions will not be provided in this tutorial. However, it should be easy to find out how to install each program.

Category:

Servers > Node.js > Configuration

Tags:

javascript project css installation configuration node.js express.js compass bootstrap

Bundle, validate, compress javascript files

Submitted by Webmaster on 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).

Category:

Web Development > Javascript > Tips and Tricks

Tags:

web javascript google development minify compress bundle merge closure

Removing lines with strings from text files on Linux/Mac OS X

Submitted by Webmaster on 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.

Category:

Operating Systems > MacOS X > Tips and Tricks

Tags:

linux macosx string sed awk

How to set innodb_flush_log_at_timeout in MySQL 5.6?

Submitted by Webmaster on 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.

Category:

Database Management Systems > MySQL > Administration

Tags:

mysql performance tuning

How to setup quick, passwordless login using SSH?

Submitted by Webmaster on 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.

Category:

Tools > Security > Tips and Tricks

Tags:

linux security macosx ssh passwordless config

How to setup Spamassasin to run as a deamon?

Submitted by Webmaster on 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.

Category:

Tools > Security > Administration

Tags:

linux security opensource spam spamassasin

More Tutorials >>

subscribe for tutorials subscribe

Geeksww.com RSS Follow geeksww on Twitter

tags cloud tags cloud

php mobile business iphone facebook software apple linux microsoft new-release security database ubuntu twitter opensource mysql windows development google fedora