Re: MySQL 5 slow startup

ralph wrote:
[SNIP]

This logs tells me that the db was ready for connections 1 second after
it was started.
(What is InnoDB?).

InnoDB is one of MySQL's storage engines. It provides transactional capabilities, referential integrity and other features that some people deem essential in a mission-critical database.

If you're not actually using InnoDB tables, then you can switch this feature off via a line in the server configuration file or with your favourite GUI config tool. This should make the MySQL server start up much faster.

But the log of my program says that it took 20 seconds:

[SNIP] 
This happens only on some machines. On other machines the time between
starting the process and a successful connection is less than a second.
With MySQL 3.25 everything worked fine on all machines. All machines
are identical. The users' profiles may differ.

But *are* all the machines identical? If they are being used by different people, then all bets are off!

Is it possible that the machines on which the MySQL server is slow to start accepting connections have many background processes running? If these processes are using a lot of memory, then the MySQL server must compete with them to grab enough memory for itself, so that it can go through its startup procedure, allocate the memory buffers that it needs, and load its privilege tables.

My experience with Windows is that all kinds of crap starts up in the background without the user really being aware of it, and each of these background processes grabs ten or twenty megabytes of memory, so before you know it, there's very little free memory.

In such an environment, MySQL may have difficulty getting enough memory to allocate its buffers.

That may explain the delay.

David Harper
Cambridge, England
.

Relevant Pages

  • =?windows-1252?Q?www=2Eelectronics=2Dmac=2Dsony=2Ecom_Toshiba_Satellite_P205=2D?= =?windows-
    ... Product Features and Technical Details ... X3100 graphics (up to 251 MB of available memory) ... Intel GMA X3100 video card with up to 251 MB of shared video memory. ... This PC also comes preinstalled with Microsoft Windows Vista Home ...
    (comp.sys.laptops)
  • =?windows-1252?Q?www=2Eelectronics=2Dmac=2Dsony=2Ecom___Sony_VAIO_VGN=2DCR320E=2F?= =?windows
    ... Product Features and Technical Details ... Stylishly designed notebook in dove white with 14.1-inch screen ... Processor, Memory, and Motherboard ... Microsoft Windows Vista Home Premium includes all of the Windows Media ...
    (comp.sys.ibm.pc.hardware.chips)
  • Re: Canadian OpenVMS Seminar (07.02.20)
    ... appropriate answer to the question of "What specific RAS-related features ... Re: Solaris x86: Neil wrote about "running Solaris or LINUX on x86 to see ... support for DDR2 memory and support for online spare memory chips, ... relationship with Intel)? ...
    (comp.os.vms)
  • Re: incredible
    ... True - the best part is that this MMU feature has been sitting idle ever ... The segments are registered with the Memory Management Unit - who enforces ... The last part is probably *why* the memory separation features are not ...
    (sci.electronics.design)
  • Re: Can I get rid of a typing lag in Word?
    ... turns off all of the features that suck power. ... you to work properly in a complex document without the pauses. ... For small simple documents 256 MB of memory is probably ... or if you wish to use a graphics program as well as ...
    (microsoft.public.word.docmanagement)