Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.2.8
-
Windows 2008 R1 32bit
Description
Hi,
I migrated from MySQL 5.6.36 to MariaDB 10.2.8 32bit on Windows 2008 R1.
I have started to see the following in our production environment.
2017-08-29 10:45:24 4432 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4197ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
|
I have not made any changes to the configuration file (my.ini); I was wondering do I need to
the settings are:-
MariaDB [(none)]> show global variables like 'innodb_buffer%';
|
+-------------------------------------+----------------+
|
| Variable_name | Value |
|
+-------------------------------------+----------------+
|
| innodb_buffer_pool_chunk_size | 134217728 |
|
| innodb_buffer_pool_dump_at_shutdown | ON |
|
| innodb_buffer_pool_dump_now | OFF |
|
| innodb_buffer_pool_dump_pct | 25 |
|
| innodb_buffer_pool_filename | ib_buffer_pool |
|
| innodb_buffer_pool_instances | 1 |
|
| innodb_buffer_pool_load_abort | OFF |
|
| innodb_buffer_pool_load_at_startup | ON |
|
| innodb_buffer_pool_load_now | OFF |
|
| innodb_buffer_pool_populate | OFF |
|
| innodb_buffer_pool_size | 268435456 |
|
+-------------------------------------+----------------+
|
11 rows in set (0.00 sec)
|
Do I need to increase innodb_buffer_pool_instances, or anything else to stop this latency which I never saw logged with MySQL 5.6.36?
many thanks for your advice and guidance.
Attachments
Issue Links
- is duplicated by
-
MDEV-13949 Improve help when reporting page cleaner loop taking too long
- Closed
- relates to
-
MDEV-16526 Overhaul the InnoDB page flushing
- Closed
-
MDEV-23399 10.5 performance regression with IO-bound tpcc
- Closed
-
MDEV-14550 Error log flood : "InnoDB: page_cleaner: 1000ms intended loop took N ms. The settings might not be optimal."
- Closed
- links to