June 18, 2013

Post: MySQL sources from development tree

… you get it, you can clone latest tree: bkf clone bk://mysql.bkbits.net/mysql-5.0 mysql-5.0 New client supports “changes….0 mysql-5.0.30 Latest Falcon release is available on bk://mysql.bkbits.net/mysql-5.2-falcon Full list of available tree you can see here http://mysql.bkbits.com/

Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact

… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take… what is it aimed at. Index Condition Pushdown Traditional B-Tree index lookups have some limitations in cases such as range…

Post: 10+ Ways to Crash or Overload MySQL

… side variables one can create. Parse Tree The query is internally presented using parse tree inside MySQL which of course depends on query size which is controlled by max_allowed_packet. However some MySQL optimizations such as equity propagation and range expansion can cause Parse Tree to blow up in size…

Post: Percona Server 5.1.49-rel12.0

….0 RC contains a couple of patches from the Facebook-MySQL tree – https://launchpad.net/mysqlatfacebook . Of particular note is better integration…. New features added: error_pad – Implements error code compatibilities with MySQL 5.5. (Oleg Tsarev) query_cache_totally_disable – Allows the…_trx_commit_session – Implements a session-level version of the MySQL global system variable innodb_flush_log_at_trx_commit. (Yasufumi…

Post: New MySQL Community Release Policies published

… main issue for me is Change policy for MySQL Community version. We are patching MySQL with minor extension so this concerns us… built from the same tree but as goal was reached process slowed down a lot. Submitting patches to MySQL 5.2 now… interesting to note 4 source releases for MySQL Community Version vs Monthly rapid updates for MySQL Enterprise version – to me this means…

Post: Top 5 Wishes for MySQL

… saying about XA which were released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit… inside who can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise… MySQL got back to spend significant resources on taking care of Web guys needs but at least we have now Community tree

Post: MySQL EXPLAIN limits and errors.

… query execution, sometimes being dynamic based on data. With EXPLAIN MySQL kind of simulates execution but it obviously does not access… of rows is estimated performing btree dive with certainly structured tree you still can get number of rows off 3-10… how many rows will be examined MySQL will still print full number. Here is example: mysql> explain select * from lt limit 10…

Post: Profiling MySQL stored routines

… – which is included in all Community tree based Percona MySQL builds since it is part of MySQL community version ever since 5.0.37 (note – not all Percona builds are done on Community tree) – comes into play. Let me show you how this works: mysql> set profiling=1; Query OK…

Post: Where to get recent MySQL version ?

Tree If you would like absolutely recent version this is a way to go. The address for MySQL 5.0 is bk://mysql.bkbits.net/mysql-5.0 (HowTo Docs) Note version you… is about free MySQL Enterprise Version ? Well at the time of this writing as far as I know source tree for Enterprise…

Post: MySQL Community contrubutions

….planetmysql.org/kaj/?p=123 about MySQL plans of including community contributions into releases. I understand MySQL‘s interest to make releases stable, and includes contributions only into development tree, but this is not something I would like to see. Look, MySQL 5.0 was shipped…