PerqueryvariablesettingsinMySQL/PerconaServer/WebScale_MySQL

Source: Internet
Author: User
PerqueryvariablesettingsinMySQLPerconaServerWebScaleSQL Recently there was a discussion on thewebscalesql mailing list started by Chip Turner on aproposed change to the MAX_STATEMENT_TIME patch. this feature has been known asper query variable settings (WL #681) and even shipping in Percona Server 5.6 asper-query variable statement.

This feature has piqued my interest since 2009, when the MySQL project (then owned by Sun Microsystems) participant ipatedin Google Summer of Code 2009, and we got code from Joseph Lukas to do just that (see his tree on Launchpad-lp :~ Jlukas79/+ junk/mysql-server ).

So code has been floating around und since 2009. it never made it into a shipping release of any MySQL-based distribution till 24 October 2013 whenPercona Server 5.6.14-62.0was released. percona's syntax implementation was as suggested inWL #681. this got me curious as to if a feature is already shipping in a distribution of MySQL, what is the WebScaleSQL answer to things-is there a look at other bran Ches or is compatibility from a user/DBA perspective only with focus on upstream?

I got myanswerfrom Steaphan Greene. very sensible, and a great ction to see how the companies involved can influence upstream MySQL and quite obviusly the downstream distributions. it is of course great to note that this feature will probably be in MySQL 5.7.5 DMR.

For what it's worth, this feature works well alongside server-side statement timeouts, which Percona Server 5.6 implements (as an alpha quality feature) via the Twitterpatchof Davi Arnaut. the MySQL team at Oracle has of course been listening, and in MySQL 5.7.4 DMR (release notes) they too haveimplemented this feature (WL #6936 ). kudos!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.