Web lists-archives.com

Re: monitoring mysql performance






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