MySQL is the most popular open-source database in the world, powering small blogs, high-volume websites, business applications and more. MySQL is used by some of the world’s most popular websites such as Facebook, Twitter, Youtube, Wikipedia ..etc. In this blog post, we will show you how to check the size of the MySQL databases and tables trough the MySQL shell. This post is written for MySQL but the exact same commands are also applicable for MariaDB.
Tag: Linux host support
How to Install LiteCart on Ubuntu 16.04
Today we’ll show you, how to install LiteCart on Ubuntu 16.04. LiteCart is a free and open source e-commerce platform which is developed in PHP, jQuery and HTML 5. In this tutorial, we will show how to install LiteCart on Ubuntu 16.04 VPS and setup a LAMP stack (Linux, Apache, MySQL, PHP) if you already haven’t. Installing LiteCart on Ubuntu 16.04 is fairly easy task and should take less than 15 minutes.
How to install Collabtive 3.1 on Ubuntu 16.04
In this tutorial, we will show how to install Collabtive 3.1 on Ubuntu 16.04. Collabtive is an open source web-based project management software written in PHP, that let you keep track of your projects. The main features of Collabtive are: task lists, milestones, time tracking, messaging / instant messaging, file management, role-based user permissions, reporting, exporting, calendaring and multilingual interface. This tutorial was tested and written for Ubuntu 16.04, but it should work on any Linux distribution. The entire process of installing Collabtive 3.1 on Ubuntu 16.04, should not take more than 10 minutes.
Speed Up SSH Connections in Linux
We’ll show you, how to speed up SSH connections in Linux. SSH is a very secure method for managing Linux servers. Sometimes it can be very slow especially if you need to open multiple SSH connections to your server. One such scenario would be if you use Git for your development work, as Git uses multiple SSH connections to transfer files and if your server is not configured correctly it will add unnecessary overhead by re-establishing a connection for every file transferred. In today’s tutorial we are going to learn how to speed up SSH connections in Linux. Let’s get started!
(more…)
How to Install Cacti SNMP Monitoring Tool on Debian 9
In today’s tutorial, we will show you how to install and Cacti on a Debian 9 server. Cacti is an open-source, web-based network graphing solution written in PHP and build on top of the industry-standard data logging tool RRDtool. Cacti stores all of the necessary information in a MySQL database and allows a user to poll services at predetermined intervals and graph the resulting data using RRDtool. This guide should work on other Linux VPS systems as well, but was tested and written for a Debian 9 VPS.
How to Setup Reverse SSH Tunnel on Linux
We’ll explain to you, how to set up reverse SSH tunnel on Linux. Let’s say you have a Linux machine behind NAT and a VPS.You want to SSH to the Linux machine behind NAT from your VPS but you don’t want to bother with port forwarding or your machine behind NAT doesn’t have a static IP address. We have an easy solution, in today’s tutorial we are going to learn how to set up a reverse SSH tunnel on Linux.
How to Install Let’s Encrypt with Apache on Ubuntu 16.04
In this tutorial we are going to show you, with step-by-step instructions on how to install Let’s Encrypt with Apache on Ubuntu 16.04. Let’s Encrypt is an open SSL Certificate Authority (CA) that offers free domain-validated (DV) certificates for your websites. SSL Certificates are used to establish a secure encrypted connection between a web server and a user’s web browser. The SSL certificates that have been issued by Let’s Encrypt are valid for 90 days and are trusted by most web browsers today.
(more…)
How To Set Up SSH Keys
In this tutorial, we will show you how to login to your Linux VPS using SSH keys. We will generate a key pair (private and public key), place the private key on your server and then use your locally stored private key to gain access to your server. This method provides a more secure way of connecting to your server, instead of just using a password. To set up SSH keys, carefully follow the steps below carefully.
(more…)
How To Use the Linux Fuser Command
We’ll show you, How To Use the Linux Fuser Command. The fuser command is used to identify which processes are using a specific file, unix socket or file system. In this tutorial we are going to show you few examples on how to use the fuser command on a Linux VPS.
How to Install Redmine on Ubuntu 16.04
We will show you, how to install and configure Redmine on Ubuntu 16.04, with Nginx and MySQL. Redmine is completely free and open source issue tracking, and project management system designed to help teams to achieve their desired project goals. It allows users to configure it according to their needs and suit their business needs. Redmine comes with a lot of useful features and plugins that can help you with the project management and all related processes. IInstalling Redmine on Ubuntu 16.04 is an easy task, just follow the steps below carefully.
(more…)