https://bugzilla.wikimedia.org/show_bug.cgi?id=30051
--- Comment #8 from Reedy <[email protected]> 2011-07-26 15:31:15 UTC --- (In reply to comment #7) > I had a look at the subselect. That would be pretty hard to rewrite into a > JOIN > query. Could you please check if you really need to be compatible to MySQL > 4.0? > That version was released over 8 years ago. Subselect support is included in > 4.1, which was released about 7 years ago... <Reedy> Does anyone know know many mysql4 boxes have we still got in production on the cluster? domas? <domas> few! You don't have to rewrite it, but we'd just have to be careful enabling the extension (if reviewed to be otherwise ok) on wikis with still 4.1 in the cluster. Those are more likely to go away when we've got EQIAD up, and have extra database capacity so we can finish the upgrades. I thought we had some documentation about this, but seemingly not. Quick checking around, it seems the dewiki (s5) cluster (at least) has a mysql4 master. It is more likely that all slaves are on mysql 5.1, as they can work with older mysql masters. Same for s6 with frwiki, jawiki, ruwiki reedy@fenari:~$ sql dewiki Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4008271479 Server version: 4.0.40-wikimedia-log The raw sql (granted, a lot of it is done correctly) being fixed up, and any reinventing of the wheel with query building things -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
