Hi!
Alex Baumeister reported a couple of days ago that Innobase is
slow when a big DELETE is concurrent with UPDATES.
The bug can cause slowing down several database operations
on non-Linux platforms.
You have to edit mysql/innobase/os/os0thread.c.
About on line 140 it is now:
............................
struct timeval t;
t.tv_sec = 0;
t.tv_usec = tm;
............................
It should be:
............................
struct timeval t;
t.tv_sec = tm / 1000000;
t.tv_usec = tm % 1000000;
............................
I.e., the number of microseconds specified in timeval must not be
>= 1000000. The bug caused thread sleeps to be zero length and the buffer
pool flush to run constantly, greatly reducing the speed of the database
in some situations.
Best regards,
Heikki Tuuri
Innobase Oy
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
