MySQL server has gone away error means that MySQL server (mysqld) timed out and closed the connection. By default, MySQL will close connections after eight hours (28800 seconds) if nothing happens. However, in some cases your web host, DBA or app developer may have decreased this timeout setting, discussed below. MySQL server has gone away, can be […]
How to Convert OpenSSH keys to Putty (.ppk) on Linux
June 3, 2019 by Hayden James, in Blog LinuxPuTTYgen is an key generator for creating SSH keys for PuTTY. PuTTYgen is comparable in certain respects to the ssh-keygen tool. PuTTYgen can be used to create public and private key pairs (in .ppk file format). In addition, PuTTYgen can also be used to convert keys to and from other formats. On Windows PuTTYGen is a graphical tool. A command-line version is available for […]
25 Best CDN Providers 2019
May 24, 2019 by Hayden James, in Blog LinuxA content delivery network, also referred to as a content distribution network (CDN) is a geographically distributed network of data centers containing proxy servers. CDN Providers serve Internet content, including web objects (text, graphics and scripts), downloadable objects (media files, software, documents), applications (e-commerce, portals), live streaming media, etc… closer to and thus faster, to end users. Some of the main advantages […]
Pruning Magento Cache & Sessions Using Cron
May 22, 2019 by Hayden James, in Blog LinuxNote: Magento 1.x only. Over the weekend a client contacted me because they had serious performance issues with their Magento based store. The three main issues were: Checkout taking more than 30 seconds to complete after clicking to submit payment. (Causing double orders/payments and users just leaving the store) Login to the front or back end […]
20 Top Server Monitoring & Application Performance Monitoring Solutions
May 8, 2019 by Hayden James, in Blog LinuxUPDATE: 50 Top Server Monitoring & Application Performance Monitoring (APM) Solutions Last Update – Fixed broken links. (including defunct, mergers, acquisitions, or changed links) Back in September I wrote about an article than touched on the subject of server performance monitoring. Then just last month a LinkedIn connection asked: “I am using New Relic to monitor my cloud servers […]
PHP Performance: Additional CPU cores or Faster CPU cores
April 30, 2019 by Hayden James, in Blog LinuxSome time ago I received an email from a client experiencing slow performance issues with a LEMP (Linux, Nginx, MySQL and PHP web server). During a full audit, I found that the server’s load average was pretty low (see above screenshot). However, the website was indeed very slow. There were some misconfigurations, but one […]
PHP-FPM tuning: Using ‘pm static’ for max performance
April 23, 2019 by Hayden James, in Blog LinuxLets take a very quick look at how best to setup PHP-FPM for high throughput, low latency and a more stable use of CPU and memory. By default, most setups have PHP-FPM’s PM (process manager) string set to dynamic and there’s also the common advice to use ondemand if you suffer from available memory issues. However, lets compare the two management […]
Set PHP realpath_cache_size ‘correctly’
April 22, 2019 by Hayden James, in Blog LinuxBack in 2012 I started enabling PHP realpath_cache_size and realpath_cache_ttl for the performance benefits. At the time, I followed settings I found here (has since been deleted). It bugged me that I was blindly setting the size of the cache without actually knowing how much storage was being used. In this post I will show you how to […]
Linux Performance: Why You Should Almost Always Add Swap Space
April 17, 2019 by Hayden James, in Blog LinuxWe know that using swap space instead of RAM (memory) can severely slow down the performance of Linux. So then, one might ask, since I have more than enough memory available, wouldn’t it better to remove swap space completely? The short answer is, No. There are performance benefits when swap is enabled, even when you have more […]
Linux server needs a RAM upgrade? Check with top, free, vmstat and sar.
April 9, 2019 by Hayden James, in Blog LinuxSometimes it can be a bit of a challenge knowing if and when you should upgrade the RAM (random access memory) on your Linux server. Even more so when deciding how much memory you should add, or, if you have adequate memory, how do you make best use of it? This article will walk you […]
Linux benchmark scripts and tools
April 6, 2019 by Hayden James, in Blog LinuxThis list of Linux benchmark scripts and tools should prove useful for quick performance check of CPU, storage, memory and network on Linux servers and VPS. Recently, I used a Linux benchmark script which was no longer maintained by the. As a result, I compiled this quick list of scripts and tools for Linux benchmarking. […]