Re: MySQL 5.7 Innodb performans issue
- Date: Wed, 20 May 2015 20:34:47 +0200
- From: "Jørn Dahl-Stamnes" <sql07@xxxxxxxxxxxxxxxx>
- Subject: 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.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql