Hi,
saqibsaleem wrote:
> Hello,
> This question is regarding the initialization time
> of the cluster (startup time).
>
> The version we used before was 4.1.7 and the
> startup time of the cluster was 5-6 minutes. Now,
> we are using version 4.1.9 and the startup time is
> 23 minutes with the same database.
>
> Before the problem was local checkpoint that was
> taking all the resources while initializing and
> also in the middle when the cluster was up. This
> was the problem because while running local
> checkpoint in the middle, it was decreasing the
> response time significantly. But now, the local
> checkpoint is not taking much resource and in the
> middle when the server is up, the response time is
> quite reasonable. What I need to ask is, is it
> really true that this configuration has been
> changed in the newer versions of MySQL.
>
Not really sure, it is possible to get that info from BitKeeper but it was too
hard for me to make the attempt. Your results indicate that DuringRestart
was lowered from 160 to 40.
> Secondly, can't I just configure the config.ini to
> use all the system resources just on
> initialization (startup) but not while running
> checkpoint in the middle when the server is
> already up.
>
This is very possible, there is DuringRestart and AfterRestart parameters for
both data (TUP) and indexes (ACC).
Rgrds Mikael
> Regards
> Saqib
>
> We are using the following hardware:
> Sun Fire 2.4G Dual, 12GB RAM
> SAN (Storage Area Network) connected with Fiber
> channel configured with Raid Type 10
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com