Hi Mats,
Mats Kindahl, 10.07.2008 21:15:
...
> let $before_pos = query_get_value("SHOW MASTER STATUS", Position, 1);
> INSTALL PLUGIN example SONAME 'ha_example.so';
> let $after_pos = query_get_value("SHOW MASTER STATUS", Position, 1);
> eval SELECT $after_pos - $before_pos AS Delta;
The latter showed up in the result as SELECT 106 - 106 AS Delta. I guess
this might also not be future proof. I did the following:
...
--disable_query_log
eval SELECT $after_pos - $before_pos AS Delta;
--enable_query_log
Regards
Ingo
--
Ingo Strüwing, Database Group
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schröder, Wolfgang Engels, Dr. Roland Bömer
Vorsitzender des Aufsichtsrates: Martin Häring HRB München 161028