[arch-general] mysqld (MySQL and MariaDB) polling

Christian Hesse list at eworm.de
Mon Feb 25 10:40:21 EST 2013


Hello everybody,

based on the thread "[RFC] Migration to MariaDB" in arch-dev-public by
Bartłomiej Piotrowski I started playing with MySQL and MariaDB. I noticed
both were polling every second:

<... futex resumed> )       = -1 ETIMEDOUT (Connection timed out)
futex(0x1d48050, FUTEX_WAKE_PRIVATE, 1) = 0
gettimeofday({1361806174, 246573}, NULL) = 0
futex(0x1d4808c, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME,
2849, {1361806175, 246573000}, ffffffff <unfinished ...>

Searching Google I found that the problem may be caused by the leap second,
though the load is not as high as some articles describe. (Continues polling
vs. one poll a second.)

However the polling stops as soon as I manually set the time with date -s and
it start again if I run ntpdate to sync the time. As this is a notebook I
rebooted more than once since the leap second happened. ;)

What is going on? This is a mobile system, so it would be great to get rid of
mysqld eating my battery power.
-- 
main(a){char*c=/*    Schoene Gruesse                         */"B?IJj;MEH"
"CX:;",b;for(a/*    Chris           get my mail address:    */=0;b=c[a++];)
putchar(b-1/(/*               gcc -o sig sig.c && ./sig    */b/42*2-3)*42);}
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: not available
URL: <http://mailman.archlinux.org/pipermail/arch-general/attachments/20130225/b1d7cee7/attachment.asc>


More information about the arch-general mailing list