2
My server is set to limit mysql memory usage by 70%,
at all times mysql is at 73.8% or even 74%, even when almost no one is using the system gets like this, ai from time to time error in someone using, the error is this :
Use PDO and PHP, one thing I do not do is close the connections with bank because I was told that I did not need it was already automatic, but what will be the reason for this 'stocking' of memory?
<?php
$conn = new PDO("mysql:host=host;dbname=banco", "usuario", "senha", array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
?>
My accounts did not match. If it is set to use at most 70%, as it is constantly at 73.8%?
– Woss
I can’t explain it either, but the biggest problem is that he keeps making that mistake sometimes, and at least I suspect it’s because of his memory
– Paulo Roberto
Can you show your.cnf? Putting innodb_buffer_pool_size on 70% doesn’t make the server only use 70%.. connections consume memory, queries consume memory, etc. With my.cnf the server may help, but that "74%" is normal
– jtomaszon