[vpsFree.cz: community-list] =?utf-8?Q?Probl=C3=A9m_?=s MySQL

Tue Sep 16 08:10:20 CEST 2014

Ahoj,

http://lists.vpsfree.cz/pipermail/outage-list/2014-September/000245.html nedorazil? Ak nie, prosim napis, pozrieme kde sa stala chyba. 

Ad innodb_use_native_aio - predpokladam, ze sa jedna o zmenu po upgrade ZFS, snajpa ma doplni/opravi ak sa mylim (az vstane). 
— 
Regards,
Tomas Srnka

On 16 Sep 2014 at 08:01:01, Bc. Lumír Balhar (frenzy.madness at gmail.com) wrote:

Ahoj.

K čemu je na VPSFree Outage-list, když se z něj o plánovaném výpadku  
člověk nedozví a musí se to v noci dozvědět z Nagiosu?

Problém s MySQL jsem řešil také a našel jsem kromě hotfixu v podobě  
"innodb_use_native_aio=0" také toho vlákno [0], kde je popsáno i řešení  
v podobě navýšení nějakého limitu pro asynchronní operace pro celý  
systém. Se současným limitem podle všeho nastartuje jen tolik kontejnerů  
s MySQL, dokud se limit 65536 nevyčerpá a ti ostatní mají smůlu.

[0] http://forum.openvz.org/index.php?t=msg&goto=44068&

Lumír.

On 16.9.2014 07:46, community-list-request at lists.vpsfree.cz wrote:
> Send Community-list mailing list submissions to
> community-list at lists.vpsfree.cz
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.vpsfree.cz/listinfo/community-list
> or, via email, send a message with subject or body 'help' to
> community-list-request at lists.vpsfree.cz
>
> You can reach the person managing the list at
> community-list-owner at lists.vpsfree.cz
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Community-list digest..."
>
>
> Today's Topics:
>
> 1. Vysledek update z dnesni noci (Pavel Snajdr)
> 2. Re: Vysledek update z dnesni noci (bacu at centrum.cz)
> 3. Re: Vysledek update z dnesni noci (Stepan Liska)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 16 Sep 2014 04:19:27 +0200
> From: Pavel Snajdr <snajpa at snajpa.net>
> To: "vpsFree.cz Community list" <community-list at lists.vpsfree.cz>
> Subject: [vpsFree.cz: community-list] Vysledek update z dnesni noci
> Message-ID: <54179E2F.6050804 at snajpa.net>
> Content-Type: text/plain; charset=utf-8
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> Ahojte,
>
> akorat jsme konecne dodelali vsechno, co bylo rozdelane dlouhou dobu:
>
> - - vzkernel updated to 2.6.32-042stab093.4
> - - zfs updated to 0.6.3-75_g2d50158
> - - spl updated to 0.6.3-9_gf9bde4f
>
> - - nasazeny SaltStack configuration management
> (viz. https://github.com/vpsfreecz/salt-configuration)
>
> - - opravene VE_ROOT u starsich VPS (zpusobovalo obcas problemy pri
> migracich, etc.)
>
> - - node1.prg dostal +128GB RAM (dalsi na rade bude node7, ktery to
> epicky potrebuje taky)
>
> - - primary router je zpatky v podobe CCR1036-8G-2S+, svisti jak ma a
> vypada to, ze bude problem ho vytizit, aby nestihal, coz je dobre :)
>
> Velky dik patri Medvedovi za kus prace, co na tom nechal a Aitherovi
> za skriptik na fix VE_ROOT :)
>
> /snajpa
>
> - --  
> S pozdravem / Best regards,
>
> Pavel Snajdr
>
> +421 948 816 186 | +420 720 107 791 | 110-010-956
> CTO of Relbit | Predseda vpsFree.cz, o.s. | RHCE
> http://relbit.com | http://vpsfree.cz | https://www.redhat.com
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
>
> iF4EAREIAAYFAlQXniwACgkQMBKdi9lkZ6oWkQEAyCLXcn+A8s7mqy9Zj3ewoCSO
> oKZG0AbyTdPZSxCZQAwA/imGVxUcvOno+NYNZQB0xNQlCbhGBrGSrH5tbABrXWKV
> =7jhK
> -----END PGP SIGNATURE-----
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 16 Sep 2014 07:31:11 +0200
> From: <bacu at centrum.cz>
> To: vpsFree.cz Community list <community-list at lists.vpsfree.cz>
> Subject: Re: [vpsFree.cz: community-list] Vysledek update z dnesni
> noci
> Message-ID: <20140916073111.71929BB5 at centrum.cz>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
> ahoj,
>  
> dnes rano me nesel nastartovat mysql server
>  
> InnoDB: Using Linux native AIO
> InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
> InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
> You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
>
>
> Nemam tuseni jestli to souvisi s UPDATEM
>  
> ale pomohlo me pridat do /etc/my.cnf
>  
> innodb_use_native_aio = 0
>  
> Jan Macík
> IT DEVELOPER
>  
> 776 005 239
>  
>  
> ______________________________________________________________
>> Od: Pavel Snajdr <snajpa at snajpa.net>
>> Komu: "vpsFree.cz Community list" <community-list at lists.vpsfree.cz>
>> Datum: 16.09.2014 04:19
>> Předmět: [vpsFree.cz: community-list] Vysledek update z dnesni noci
>>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> Ahojte,
>
> akorat jsme konecne dodelali vsechno, co bylo rozdelane dlouhou dobu:
>
> - - vzkernel updated to 2.6.32-042stab093.4
> - - zfs updated to 0.6.3-75_g2d50158
> - - spl updated to 0.6.3-9_gf9bde4f
>
> - - nasazeny SaltStack configuration management
> (viz. https://github.com/vpsfreecz/salt-configuration <https://github.com/vpsfreecz/salt-configuration>)
>
> - - opravene VE_ROOT u starsich VPS (zpusobovalo obcas problemy pri
> migracich, etc.)
>
> - - node1.prg dostal +128GB RAM (dalsi na rade bude node7, ktery to
> epicky potrebuje taky)
>
> - - primary router je zpatky v podobe CCR1036-8G-2S+, svisti jak ma a
> vypada to, ze bude problem ho vytizit, aby nestihal, coz je dobre :)
>
> Velky dik patri Medvedovi za kus prace, co na tom nechal a Aitherovi
> za skriptik na fix VE_ROOT :)
>
> /snajpa
>
> - --  
> S pozdravem / Best regards,
>
> Pavel Snajdr
>
> +421 948 816 186 | +420 720 107 791 | 110-010-956
> CTO of Relbit | Predseda vpsFree.cz, o.s. | RHCE
> http://relbit.com <http://relbit.com> | http://vpsfree.cz <http://vpsfree.cz> | https://www.redhat.com <https://www.redhat.com>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
>
> iF4EAREIAAYFAlQXniwACgkQMBKdi9lkZ6oWkQEAyCLXcn+A8s7mqy9Zj3ewoCSO
> oKZG0AbyTdPZSxCZQAwA/imGVxUcvOno+NYNZQB0xNQlCbhGBrGSrH5tbABrXWKV
> =7jhK
> -----END PGP SIGNATURE-----
> _______________________________________________
> Community-list mailing list
> Community-list at lists.vpsfree.cz
> http://lists.vpsfree.cz/listinfo/community-list <http://lists.vpsfree.cz/listinfo/community-list>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.vpsfree.cz/pipermail/community-list/attachments/20140916/8865c251/attachment-0001.html>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 16 Sep 2014 07:38:39 +0200
> From: Stepan Liska <stepan at comlinks.cz>
> To: "vpsFree.cz Community list" <community-list at lists.vpsfree.cz>
> Subject: Re: [vpsFree.cz: community-list] Vysledek update z dnesni
> noci
> Message-ID: <5417CCDF.4050401 at comlinks.cz>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
>
> +1
>
> psal jsem na podporu.
>
> Š.
>
>
> Dne 16.9.2014 v 07:31 bacu at centrum.cz napsal(a):
>> ahoj,
>>
>> dnes rano me nesel nastartovat mysql server
>>
>> InnoDB: Using Linux native AIO
>> InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts
>> before giving up.
>>
>> InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
>>
>> You can disable Linux Native AIO by setting innodb_use_native_aio = 0
>> in my.cnf
>>
>>
>> Nemam tuseni jestli to souvisi s UPDATEM
>>
>> ale pomohlo me pridat do /etc/my.cnf
>>
>> innodb_use_native_aio = 0
>>
>> Jan Macík
>>
>> IT DEVELOPER
>>
>> 776 005 239
>>
>> ______________________________________________________________
>>> Od: Pavel Snajdr <snajpa at snajpa.net>
>>> Komu: "vpsFree.cz Community list" <community-list at lists.vpsfree.cz>
>>> Datum: 16.09.2014 04:19
>>> Předmět: [vpsFree.cz: community-list] Vysledek update z dnesni noci
>>>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA256
>>
>> Ahojte,
>>
>> akorat jsme konecne dodelali vsechno, co bylo rozdelane dlouhou dobu:
>>
>> - - vzkernel updated to 2.6.32-042stab093.4
>> - - zfs updated to 0.6.3-75_g2d50158
>> - - spl updated to 0.6.3-9_gf9bde4f
>>
>> - - nasazeny SaltStack configuration management
>> (viz. https://github.com/vpsfreecz/salt-configuration)
>>
>> - - opravene VE_ROOT u starsich VPS (zpusobovalo obcas problemy pri
>> migracich, etc.)
>>
>> - - node1.prg dostal +128GB RAM (dalsi na rade bude node7, ktery to
>> epicky potrebuje taky)
>>
>> - - primary router je zpatky v podobe CCR1036-8G-2S+, svisti jak ma a
>> vypada to, ze bude problem ho vytizit, aby nestihal, coz je dobre :)
>>
>> Velky dik patri Medvedovi za kus prace, co na tom nechal a Aitherovi
>> za skriptik na fix VE_ROOT :)
>>
>> /snajpa
>>
>> - --  
>> S pozdravem / Best regards,
>>
>> Pavel Snajdr
>>
>> +421 948 816 186 | +420 720 107 791 | 110-010-956
>> CTO of Relbit | Predseda vpsFree.cz, o.s. | RHCE
>> http://relbit.com | http://vpsfree.cz | https://www.redhat.com
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1
>>
>> iF4EAREIAAYFAlQXniwACgkQMBKdi9lkZ6oWkQEAyCLXcn+A8s7mqy9Zj3ewoCSO
>> oKZG0AbyTdPZSxCZQAwA/imGVxUcvOno+NYNZQB0xNQlCbhGBrGSrH5tbABrXWKV
>> =7jhK
>> -----END PGP SIGNATURE-----
>> _______________________________________________
>> Community-list mailing list
>> Community-list at lists.vpsfree.cz
>> http://lists.vpsfree.cz/listinfo/community-list
>>
>>
>>
>> _______________________________________________
>> Community-list mailing list
>> Community-list at lists.vpsfree.cz
>> http://lists.vpsfree.cz/listinfo/community-list
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.vpsfree.cz/pipermail/community-list/attachments/20140916/9611113d/attachment.html>
>
> ------------------------------
>
> _______________________________________________
> Community-list mailing list
> Community-list at lists.vpsfree.cz
> http://lists.vpsfree.cz/listinfo/community-list
>
>
> End of Community-list Digest, Vol 38, Issue 8
> *********************************************

_______________________________________________
Community-list mailing list
Community-list at lists.vpsfree.cz
http://lists.vpsfree.cz/listinfo/community-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vpsfree.cz/pipermail/community-list/attachments/20140916/35a044c8/attachment-0002.html>