In this tutorial, we will go over how to optimize MySQL InnoDB tables. The first step is to determine if your database is fragmented, and then connect to the MySQL database and run the following query mentioned below, which tells you how much free space each table has. Log into MySQL command prompt: mysql [(none)] […]
In this tutorial, we will go over how to increase the /tmp directory for cPanel/WHM based servers. First and foremost, you will need root SSH access to your server. Once connected to your server via SSH, check how /tmp is configured and it’s size by running the “df -h” command: root@ip:/home# df -h Filesystem Size […]
How to install SSL on Virtualmin? It’s quite common to come across SSL if you work on websites or related services. It’s called secure socket layer (SSL). It’s a protocol that secures communication over the network. It can be web server to client (browser and web server), e-mail server to e-mail client (eg. Thunderbird). SSL […]
Article by: Dustin B. Cisneros, CEO of RackNerd Recently, in the hosting industry, I’ve noticed that there have been some providers who were doing very well for a period of time, quickly fall down the ranks. As an actual example, there have been several providers who were gaining popularity very quickly in the hosting industry […]
Many of us have come across the error “503 service unavailable” while working with web servers. It simply says the server is unable to serve the HTTP request given at the time. There can be numerous reasons for 503 status code. Let’s discuss some possibilities, and see what are the possible tweaks we can do […]
Restoring a large MySQL database When we restore a large database, usually we come across two errors as shown below: “MySQL server has gone away” & “Lost connection to MySQL server during query” These errors means that MySQL server (mysqld) timed out and closed the connection if nothing happened after the specified time duration. Here […]
What is a SYN flood attack? How to Block SYN DDoS? In order to understand how to block SYN attacks, it is first necessary to understand what it is. We’ll start with the basics: 1. The client initiates a connection with the server by sending a SYN (synchronise) packet. 2. The server responds with SYN-ACK […]
What does htaccess stand for? This file is used to set up the web site without changing the server configuration. Creation of htaccess file You can build an htaccess file using text editing software via the command line or via the file manager in cPanel. Examples for htaccess 1. To redirect a domain permanently If […]
If you are looking to configure remote desktop on your Ubuntu server, you’ve found the perfect tutorial! By default, when you buy a Ubuntu VPS server, you will not get GUI access to server, as these servers only come with command line access over SSH by default. However, with just a few commands you can […]
Are you working on Deep Learning/Machine Learning/AI based projects? If so, this tutorial is for you! In this tutorial, we go over how to setup TensorFlow on a VPS or Dedicated Server. Due to higher resource/CPU requirements, we highly recommend running TensorFlow within a dedicated server (instead of a VPS) environment. Before deep diving into […]
