MySQL query profiling is a useful technique when trying to analyze the overall performance of a database driven application. When developing a mid to large size application, there tends to be hundreds of queries distributed throughout a large code base. This article will demonstrate some useful query profiling techniques using tools that are built into MySQL server.
Swap space can be used as an “overflow” area for your system when you run out of RAM. The operating system can store data that would normally be kept in RAM on the hard drive in a specially formatted file. In this guide, we’ll demonstrate how to create and use one of these files in Ubuntu 14.04.
In this the cloud provider article, as a part of a series to help developers with scaling, we will be talking about configuring Varnish with Drupal. This will greatly reduce the amount of time it takes users to load your Drupal based website, and increase the simultaneous serving capacity of your the cloud provider VPS by passing requests through the Varnish Cache software first.
Al enfrentar tareas técnicas repetitivas, encontrar soluciones de automatización que funcionen puede volverse una tarea en sí. Con Jenkins, un servidor de automatización de código abierto, puede administrar de manera eficiente las tareas, desde la…
MySQL and MariaDB are popular database management systems that can be used in conjunction with an application or a website. While the querying syntax is easy to learn and very powerful, some operations take a long time. This article will discuss some steps you can take to optimize your queries and table structure.
Mytop is an open source, command line tool used for monitoring MySQL performance. It was inspired by the Linux system monitoring tool named top and is similar to it in look and feel. Mytop connects to a MySQL server and summarizes the information in a useful format. Using mytop, we can monitor (in real-time) MySQL threads, queries, and uptime as well as see which user is running queries on which database, which are the slow queries, and more.
How fast a website will load depends on the size of all of the files that have to be downloaded by the browser. Reducing the size of files to be transmitted can make the website not only load faster, but also cheaper to those who have to pay for their bandwidth usage. In this guide, we’ll discuss how to configure Nginx installed on your CentOS 7 server to utilize `gzip` compression to reduce the size of content sent to website visitors.
This article will cover the pros and cons of using virtual memory or a swap file (paging), determining if your droplet already uses virtual memory or paging, the differences between a swap partition and a swap file, information on how to create a swap file, and how to configure the system’s “swappiness” (how likely it is to use virtual memory as well as determining the appropriate size to use).
Si vous devez réaliser des tâches techniques répétitives, cela peut s’avérer être difficile de trouver des solutions d’automatisation qui répondent à vos attentes. Avec Jenkins, un serveur d’automatisation open-source, vous pouvez gérer vos tâches…
In this article, we will explore a few ways to exploit Unicorn’s concurrency, while at the same time control the memory consumption.
Progressive Robot: Your Gateway to Comprehensive IT Solutions — Specializing in Web Development, Mobile App Development, and Expert IT Services.
© All Copyright by Progressiverobot.com
VAT Number ( 506152326 )
