[italy-tech] restart mysql e conferma file conf di postgre

[ameba00x]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 18 Nov 2008 17:29:55 +0100
ameba00x <ameba00x at autistici.org> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> On Tue, 18 Nov 2008 10:36:30 +0100
> ameba00x <ameba00x at autistici.org> wrote:
> 
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> > 
> > Sto cambiando alcuni parametri su mysql e quindi restarto il
> > servizio.
> > 
> 

usando mtop ho notato sta cosa:

TLW: 146
TLW: Table_locks_waited
    Number of times a table lock could not be acquired immediately and
a wait was needed. If this is high, and you have performance problems,
you should first optimise your queries, and then either split your
table(s) or use replication. Available after 3.23.33. (4.5.7.3)

sono 146 in 1:29 di uptime, secondo me sono tante

idee?

ciao
ameba00x

- -- 
Si muore un pò per poter vivere
			Arrivederci amore ciao
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQFJIwQMojBp3XUJuEURAhGzAJ9EW4o5DiWq/33XYxS2Wawi6/Rx8wCfVw5A
aKBG2+pgG8+AVSSOqu4ionI=
=9Dz2
-----END PGP SIGNATURE-----