14 Set , 2017  

The flexible, fast, and secure template engine for PHP

Digital marketing

16 Esempi di Lead Magnet

31 Ago , 2017  

Spiegarti meglio cos’è un lead magnet e perché grazie ad esso il tuo business può fare un salto di qualità



How to fix Mysql high usage

26 Lug , 2017  

Depending on what’s causing the memory bottleneck, the solution can vary.

Here are the top resolutions for MySQL high memory usage.

1. MySQL settings optimization

MySQL uses memory in two ways:

Memory permanently reserved for its use
– This category of memory known as “Global Buffers” is obtained from the operating system during server boot-up and is not released to any other process.

Memory which is requested dynamically based on requests
– MySQL uses “Thread Buffers“, which is memory requested from the operating system as and when a new query is processed. Once the query is executed, this memory is released back to the operating system.

So, you can say the memory usage of MySQL is

“Global Buffers + (Thread Buffers x maximum number of allowed connections)”.

This value should always be kept below 90% of server memory for a dedicated database server.

If it is a shared server, it should be kept below 50%.

Here are a few of the common MySQL settings that determines memory usage, and how you can decide it’s size.

– For InnoDB storage engine, caching is done in the buffer pool. The size of the buffer pool is important for system performance and is assigned a value that is between 50-70% of available RAM. Too small pool size can cause excessive flushing of pages and too large size can cause swapping due to competition for memory.

– For MyISAM storage engine, this parameter determines the caching and key_buffer_size has to be set according to the RAM, which is around 20% of RAM size.

– To limit the number of connections possible for MySQL at any instant of time, to avoid a single user from overloading the server, max_connections is used.
Each thread uses a portion of the RAM for allotting its buffers and hence limiting the maximum no of connections based on the RAM size is important.

Approx formula, max_connections = (Available RAM – Global Buffers) / Thread Buffers

– The query cache can be useful in an environment where you have tables that do not change very often and for which the web server receives many identical queries such as a blog or record lookup.
The query cache stores the text of a SELECT statement together with the corresponding result that was sent to the client. So this parameter is used only for such application servers or otherwise disabled and set to 0 for other servers. To avoid resource contention, even if it is enabled, the value is set a minimal one of around 10MB.

Digital marketing

Come costruisce Google i risultati di ricerca?

24 Mag , 2017  

Search Engine Results Page

In questo articolo si possono trovare molto di quello che devi sapere sul funzionamento della ricerca di Google e la creazione delle SERP

Senza categoria

AMP Tutorial By Google

6 Mag , 2017


Web Push Notifications

5 Mag , 2017  

If you ask a room of developers what mobile device features are missing from the web, push notifications are always high on the list. More…


Ottimizza le immagini per la Page Speed

5 Mag , 2017  

Ottimizzare le immagini per Google aiuta ad aumentare la visibilità online del sito web dove sono ospitate. Quando si inserisce una immagine in una pagina web è importante seguire sempre alcune semplici regole che andrò a descrivervi.


Senza categoria

Come fare una Diretta Facebook da computer con OBS Studio

4 Mag , 2017  

Stai cercando il modo per fare una diretta Facebook utilizzando un video? Ho la soluzione per te. More…