[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
Roedy Green - 27 Jan 2006 00:39 GMT
On Thu, 26 Jan 2006 15:20:24 GMT, David Harper
<devnull@obliquity.u-net.com> wrote, quoted or indirectly quoted
someone who said :
>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.
You see them with a Ctrl-Alt-Del to bring up the task manager. Sort by
memory usage to see the pigs.

Signature
Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.