← Back to team overview

maria-discuss team mailing list archive

Re: MariaDB-10.2.11 Long Time To Start

 

Hi Marko,

Kinda outside of my element here, but attached are a few screenshots from perf top -g

Thanks,

Mike

On 2018-01-08 10:34 AM, Michael Caplan wrote:
Hi Marko,

I can reproduce this reliably with every start up.

Poor man's profiler output:

84    ../sysdeps/unix/syscall-template.S: No such file or directory.
     10 ??,??,??,??,??,??,start_thread,clone
      5 at,??,??,start_thread,clone
      1 pread64,??,??,??,??,??,??,??,??,??,??,??,ha_initialize_handlerton(st_plugin_int*),??,plugin_init(int*,,??,mysqld_main(int,,__libc_start_main,_start
      1 at,??,start_thread,clone
      1

Anything else I can get you?

Best,

Mike


On 2018-01-08 09:52 AM, Marko Mäkelä wrote:
Hi Michael,

    2018-01-07  9:38:18 139980432365760 [Note] InnoDB: Highest
    supported file format is Barracuda.
    2018-01-07 10:11:48 139980432365760 [Note] InnoDB: 128 out of 128
    rollback segments are active.

This is really unacceptable behaviour. It looks like you have encountered
https://jira.mariadb.org/browse/MDEV-9843 where this exactly same behaviour has been documented.

Can you reproduce the delay on every startup? Stack traces (from http://poormansprofiler.org/ or "perf top -g" or similar) during this startup delay would be very useful.

With best regards,

Marko




_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp


Attachment: Selection_471.png
Description: PNG image

Attachment: Selection_470.png
Description: PNG image

Attachment: Selection_469.png
Description: PNG image

Attachment: Selection_468.png
Description: PNG image


References