Web lists-archives.com

Re: MySQL 5.7 Innodb performans issue




On Wednesday, May 20, 2015, Morgan Tocker wrote:
> Hi Jørn,
> 
> Wagner’s point about SHOW ENGINE INNODB STATUS is a good one.  A couple of
> other questions about your workload:
> 
> - The data collector system processing jobs, is it multi threaded?

Sorry, forgot about that. No, it is not multi threaded. It is a PHP bases system using several 
script running sequently in an infinite loop. Each script taking care of part of the job of 
processing the data.

> - Do you have a sample schema + set of queries we could look at?
>  (We pay close attention to regressions.)

This will be BIG, since it it so many different queries and tables.
Not sure what you mean by "We pay close attention to regressions".

> In terms of your configuration:
> 
> I would usually recommend assuming the default values for some of the
> settings you’ve specified (table_open_cache, sort_buffer_size,
> thread_cache_size, innodb_log_buffer_size, innodb_thread_concurrency..).  
> A 25G buffer pool on a 32G server with some of your other buffers being
> quite large is something you may need to look into too.

I know, but sofare no swapping is taking place. The test server is used for testing this system 
only. And in 99% of the time, only one client is using the SQL server.

-- 
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/

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