Project Managment,School

Isole in Rete

21 Set , 2019  

L’arte di accorciare le distanze.

Lipari 21 Settembre 2019

Guarda la presentazione isole in rete
More…

Like
Like Love Haha Wow Sad Angry
1

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.

Like
Like Love Haha Wow Sad Angry

School

Ripensare il PECUP

21 Mag , 2017  

More…

Like
Like Love Haha Wow Sad Angry

School

Google classroom

11 Mar , 2017  

La giuda ufficiale con i video by Google e il link al materiale di supporto.

More…

Like
Like Love Haha Wow Sad Angry

School

Eolie Google Group

10 Mar , 2017  

More…

Like
Like Love Haha Wow Sad Angry

School

Lavorare per eas

22 Nov , 2016   Video

More…

Like
Like Love Haha Wow Sad Angry

School

Lavorare per competenze

22 Nov , 2016  

Come si lavora materialmente “per competenze” nella propria attività didattica?

More…

Like
Like Love Haha Wow Sad Angry
1

School

Tinkercad, online 3D design and 3D printing app for everyone.

12 Ott , 2016  

Tinkercad, online 3D design and 3D printing app for everyone.Tinkercad is used by designers, hobbyists, teachers, and kids, to make toys, prototypes, home decor, Minecraft models, jewelry – the list is truly endless! More…

Like
Like Love Haha Wow Sad Angry

School

3D design made easy!

12 Ott , 2016  

Doodle3D Transform is a new app we’re working on.
It makes designing in 3D really easy and fun!
Transform your 2D drawings easily into 3D designs.
You can get early access by supporting our campaign. More…

Like
Like Love Haha Wow Sad Angry
1

School

Open school

30 Mar , 2016  

Open School

Open School Support è un’attività di supporto didattico che mette a disposizione degli studenti un ambiente fruibile su internet che consente :

  • di fare domande sugli argomenti disciplinari e ricevere le risposte dagli altri studenti e dai docenti
  • di partecipare a un servizio di doposcuola in audio video su
  • di consultare il materiale didattico creato dai docenti su
  • di affrontare argomenti sulle problematiche giovanili e discuterne insieme a compagni e docenti all’interno di uno spazio di confronto.

More…

Like
Like Love Haha Wow Sad Angry
1