Senza categoria

Sito e Blog : Tecniche e Regole

27 Set , 2017  

Creare un blog non è un gioco e, soprattutto, ci vuole del tempo prima di ottenere dei risultati.

Mettere online il  sito  e poi stupirsi quando non si vedono i risultati  verso la  fine della campagna elettorale è molto ricorrente

Se lo metti online tardi, se non sai come strutturarlo e se non sai come curarlo, il mio consiglio è quello di lasciar perdere. Si evitano  brutte figure.

Ancora peggio affidare la realizzazione del blog politico al figlio, a parenti, ad amici e web agency tradizionali, che non sanno come si struttura un blog dedicato esclusivamente alla politica.

La frase che molto spesso sentirete dalle persone che vi circondano suona così:

Tanto che ci vuole per fare un blog su blogspot o su wordpress

Digital marketing

Pubblicità comportamentale

27 Set , 2017  

Che cos’è? come gestire la mia privacy?

Your online choice
More…

Work

Twig

14 Set , 2017  

The flexible, fast, and secure template engine for PHP
More…

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à

More…

School

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.

innodb_buffer_pool_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.

key_buffer_size
– 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.

max_connections
– 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

query_cache_size
– 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
More…

Senza categoria

AMP Tutorial By Google

6 Mag , 2017  

https://www.ampproject.org/docs/tutorials/

Work

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…