MySQL creator says 14,000 against Oracle-Sun deal

Michael Widenius, the creator of the MySQL database and a vocal opponent of Oracle Corp’s USD 7 billion takeover of Sun Microsystems Inc, has handed 14,000 signatures opposing the deal to regulators in Europe, China and Russia. Widenius, one of the most respected developers of open-source software, left Sun last year to set up database firm Monty Program Ab, which competes directly with MySQL. The European Commission initially objected to Oracle’s acquisition of Sun, saying it was concerned Oracle’s takeover of the MySQL database could hurt competition in that market. But the Commission signaled in mid-December that it would likely clear the deal after some of Oracle’s largest customers said they believed the takeover would not hurt competition. Since then, Oracle has said it expects to win unconditional EU clearance to close the deal by the end of January. Widenius, who delivered the signatures on Monday, said he would continue to gather signatures until the commission makes a final ruling, which is due by Jan. 27. “Our signatories don’t have faith that Oracle could be a good steward of MySQL,” Widenius said in a statement. Still, Beau Buffier, a partner in the anti-trust practice of law firm Shearman & Sterling, said signature drives carry little weight with the commission. He said regulators generally want each person who weighs in on pending cases to provide specifics on how an acquisition might affect their particular business. “What you would need is detailed statements from significant developers,” he said. More than 5,000 signatures are from self-employed developers and more than 3,000 from employees of companies and other organizations using MySQL, according to Widenius. He did not disclose the names of the people who signed the petition. The signatures were gathered during the first week of the campaign and were delivered to the European Commission and other European institutions, including the European Parliament and the competition authorities of the 27 member states, as well as to the Chinese Ministry of Commerce and the Russian Federal Antimonopoly Service. Officials with Oracle, the world’s No. 3 software maker, and Sun, the No. 4 server maker, declined comment. The acquisition will transform Oracle from a maker of software into a technology powerhouse that sells computers and storage equipment preloaded with its programs. Oracle Chief Executive Larry Ellison is betting the combination will give his company an edge over rivals such as IBM Corp, Hewlett-Packard Co, Microsoft Corp and EMC Corp. Sun bought MySQL for USD 1 billion in 2008.

[Source:- Moneycontrol]

What to do with optimizer hints after an upgrade?

At a recent optimizer webinar, I talked about MySQL introducing a new style for hints, and that MySQL 5.7 also added support for more hints, see Sergey Glukhov’s blog. A question I got at the end of the webinar was what to do with the hints in the application code after an upgrade?

The MySQL optimizer makes decisions on which query plan to choose based on the built-in cost model and statistics from storage engines, in addition to dictionary information. For each release, the optimizer gets smarter and smarter, the cost model becomes more advanced, statistics gets more fine grained, and with the planned histogram support, the optimizer will also get more information on data distribution.

While optimizer improves for each release, query plans a user has specified using hints in the application code remain unchanged. These hints may not be needed after an upgrade, and in the worst case, they can become counterproductive. We advise users to retest hints during upgrade and drop those that are no longer needed. This works fine if you have full control over the application code, but it doesn’t work if you don’t.

In 5.7, MySQL introduced a query rewrite plugin which can be very useful in such a scenario. Instead of adding hints directly into the application code, it allows users to rewrite a query by adding hints through the query rewrite plugin. Martin’s blog shows how to rewrite a query using this new plugin. During an upgrade, users can simply get a list of all rewrite rules from the rewrite_rules table, and then they can easily enable and disable each rewrite rule to verify if the hint is still useful. If not, the rewrite rule can be removed without changing any application code.


[Source:- Mysqlserverteam]