Can anyone suggest a workaround? A lot of people (including a couple of projects and a
couple of bots) in EN wiki use my scripts and I don't want to put them on hold
indefinitely.
I want to do big joins with tables in the enwiki_p database without causing replag on the
new sql-s1 box.
- Jason (JaGa on EN wiki)
Ja Ga:
Now that sql-s1 is on a new box, my queries are
creating a replag that
never happened before.
as i mentioned in my mail, this could be caused by
innodb_locks_unsafe_for_binlog being disabled, which is needed to work around
this mysql bug:
<http://bugs.mysql.com/bug.php?id=39320>
(otherwise, certain queries crash the server.)
when that bug is fixed, we will change the configuration back.
- river.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (HP-UX)
iEYEARECAAYFAkmtmRkACgkQIXd7fCuc5vJgxQCfeRMVqQ3EdaVy3OzdHaCAcDXr
R3EAoKyE42MIXZ/cJbP0WO5nJIjg179W
=OAGk
-----END PGP SIGNATURE-----