Re: monitoring mysql performance

2017-11-02 Thread Reindl Harald 



Am 02.11.2017 um 20:09 schrieb Miguel González:

  I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with
MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using
innodb.

  So I´m thinking of ways of improving MySQL performance and of course
for that, you need to measure.

  Currently I´m checking, there are no slow queries and read and writes
perform well. I have enabled slow queries logging but the truth is that
most queries logged are not slow, they are just slow when the web server
load is too high, so when you try to check those queries at other time,
there isn´t anything wrong with them


so what evidence do you have that it's the database server at all?

mysqltuner would be a good start for config hints in that case

but mostly the webserver load is high because wordpress, joomla and all 
that crap is terrible inefficient even with PHP7 and opcache enabled and 
so you need caching in the application - not query results, whole 
content parts like navigation and so on - parts of the page which don#t 
change every time and are shared between different pages


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

monitoring mysql performance

2017-11-02 Thread Miguel González 
Hi,

 I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with
MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using
innodb.

 So I´m thinking of ways of improving MySQL performance and of course
for that, you need to measure.

 Currently I´m checking, there are no slow queries and read and writes
perform well. I have enabled slow queries logging but the truth is that
most queries logged are not slow, they are just slow when the web server
load is too high, so when you try to check those queries at other time,
there isn´t anything wrong with them.

 So I migrated from MySQL 5.5 to 5.6 and enabled query cache. I´ve heard
you can use memcached for caching reads and writes but not sure about this.

 So I started to look into graphical open source tools to measure my
server (mostly  MySQL) performance before doing any change.

 Sincerely, I´m overwhelmed on the possibilities, kibana, grafana, etc
and I don´t know which one to choose.

 For starters I was thinking of setting up a virtual machine on my
laptop and configure one of those and get the data from the server (not
sure if this is feasible without loosing information when the VM is not
running).

 What do you guys recommend me?

 Thanks!

 Miguel





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql